April 8, 2010 at 11:09 am
When I grant access to users or groups to a database and the users try to connect using SSMS, they receive an error which says they don't have access to msdb database. I believe this was a problem on the beta version of SQL, but I'm installing SP1.
Any suggestions? My databases aren't set to auto-close.
TIA
April 8, 2010 at 12:05 pm
I assume you created a login, and then created a user account mapped to that login for at least one user database. do they have this database defined as their default database? Also, is their client attempting to connect to the msdb database directly? Do you have any useful information in the log like "failed login attempt trying to connect to msdb database"
April 8, 2010 at 1:05 pm
That is correct, I created a login and then mapped it to a user in a database. The default database is master. They are using SSMS to connect to the SQL instance and are able to. The issue is when you expand the databases node in SSMS it gives an error (see attachment). Microsoft connect mentions this error is fixed in CU3 and the machine i'm testing this on has SP1.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply