Chris Hough ( XXXX@XXXXX.COM ) writes:
Error 4060 is "Cannot open database "%.*ls" requested by the login. The
This would indicate that the database you are trying to connect to does
not exist, or that the login you are using to not map to a user in that
So the first thing would be to check that you have spelled the database
name correctly. It can be a good idea to change the connection to use "sa"
or somesuch for the test, just to exclude that you are not victim to a
blindness that happen to everyone.
Once that been done, you need to examine the credentials a little closer.
If I understand you correctly, you have granted database access to a
Windows group, and you are using integrated security. But did you also
grant access to SQL Server to this group? The login might be able to
enter SQL Server by some other group belonging.
Run SELECTs on sys.server_principals and sys.databases_principals in the
Erland Sommarskog, SQL Server MVP, XXXX@XXXXX.COM
Links for SQL Server Books Online:
SQL 2008: http://www.yqcomputer.com/
SQL 2005: http://www.yqcomputer.com/
SQL 2000: http://www.yqcomputer.com/