Home / server / Questions / 31591
Accepted
Mike Cole
Asked: 2009-06-26 06:28:59 +0800 CST

New SQL Server User cannot view databases when logging into SSMS

  • 772

I am using SQL Server 2005.

I set up a new user on my development SQL Server, and made him an owner on a specific database. I can log in as him, see all the databases, and open only the database specified.

I set up the user on my production SQL Server using the same exact procedure (set as owner on a specific database), but when I log in as him I cannot see any databases listed. What can I do to fix this?

sql-server-2005

3 Answers

  1. Best Answer

    If your using SQL Server 2005 tools aka SSMS (SQL Server Management Studio). Make sure you install SQL Server 2005 SP3. Even if you don't have the SQL Server Services / DB Engine running this has a number of bug fixes and upgrades for the SSMS tools.

    SQL Server 2005 SP3

    • 1

  2. Right click and refresh on database folder? Sometimes SSMS gets weird refreshing data. Also make sure his login account is under Security folder and mapped to the specific database. Are both dev and prod at same SP level?

    • 0

  3. If your production server is 2008 you may run into an issue. I answered a similar sounding question on stackoverflow.

    click View, Object Explorer Details. Then, open Databases. Finally, click the header columns and uncheck Collation.

    Source: http://sqlblog.com/blogs/aaron_bertrand/archive/2008/07/07/a-little-management-studio-oops.aspx

    I solved this for my own machine a while ago and had to look the issue back up. Hopefully this link and the links from there will help you find the answer if this doesn't. It seems familiar to what i had to do.

    • 0