User does not see connection in Management Studio
-
I have a user that is trying to use the Management Studio tool to connect to a database server. When he clicks on the connect and puts in the server, it shows on the left hand side of the screen but it does not show the green arrow indicating he is connected. He can run a query against tables, but when he expands stored procedures in the object explorer he doesn't see anything. Has anyone come across this problem? I ensured that he was not a member of any group that has the login disabled and ensured he had data reader permissions to the database.
-
That's kind of a new one on me man.
It sounds like he's clearly connected to the DB though. Maybe a bad install of SSMS?
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
I realized I had not granted permissions on the schema to view the objects and have since fixed that, but any user that has just been granted data reader / view definition rights does not have the green arrow on SSMS when using the object explorer. It just seems weird that it would not show as connected, but apparently after giving schema view definitions permission they could see the stored procedures.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply