I am trying to access a database on MSSQL4 with SQL Server Manager 2008. I can successfully connect, but I can’t see any of my databases.
I have a ticket open (ZHC-49114-232) which I tried to respond to 2x and my response is not showing up in the support ticket. I know that it can take some time for responses to show up, but it’s been almost 2 hours.
The last response I got was that I’d have to use a SQL window and run queries to make changes to the database, but this is unacceptable. I need to be able to modify the table structure from within the SQL Server Manager.
You need SQLview permissions. that is what you need to request in ticket.
I did request that in the ticket and they told me that SQL View is disabled.
I tried to reply saying that that was unacceptable, but my reply isn’t showing up, which is why I came here.
This was their response:
If you are able to connect database by using sql management studio/sql lite manager and not able to see db that is not a issue, we have disable db view permission.
they can easily manage database and execute sql query by using below syntax
user db (database name)
go
your sql query
go
In the past I always just submitted a ticket for a SQL View login and it was done in a matter of minutes. This has taken all day to be resolved.
New custom login created for your database. Also replied that ticket too.