Post reply

Unable to see User Databases in SSMS

  • August 29, 2013 at 11:46 pm

    #279203

    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

  • August 30, 2013 at 1:39 am

    #1646240

    Check out this article:

    http://www.mssqltips.com/sqlservertip/2995/how-to-hide-sql-server-user-databases-in-sql-server-management-studio/

    [font="Verdana"]Markus Bohse[/font]

  • August 30, 2013 at 9:07 am

    #1646399

    It worked.

    You are genious Marcus.

    Thank you so much.

    Alex

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply