Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to see User Databases in SSMS Expand / Collapse
Author
Message
Posted Thursday, August 29, 2013 11:46 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 11, 2014 2:21 PM
Points: 517, Visits: 219
Hi, need help

I set db_datareader role to the Security Login Group for the User Database in SQL2012 instance on Virtual Machine.
This Group cannot see this database in 2008 SSMS under Databases. The only way they can see this database if I would assign this Group a sysadmin role.

The same group does not have any problems to see another User database in 2008 SSMS from another SQL2012 Server with the same role.
This 2nd one is an actual Server (not Virtual Machine) that is probably not a relevant information.

Both Servers have the same version of Windows (Windows 2012) and SQL Server (SQL Server 11.0.3128)

Any help would be greatly appreciated.

Thank you
Alex




Post #1490006
Posted Friday, August 30, 2013 1:39 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 5:31 AM
Points: 4,429, Visits: 4,183
Check out this article:
http://www.mssqltips.com/sqlservertip/2995/how-to-hide-sql-server-user-databases-in-sql-server-management-studio/


Markus Bohse
Post #1490020
Posted Friday, August 30, 2013 9:07 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 11, 2014 2:21 PM
Points: 517, Visits: 219
It worked.

You are genious Marcus.
Thank you so much.

Alex



Post #1490199
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse