September 29, 2005 at 2:24 pm
2 developers here got this message today "Cannot open User Default Database" while trying to open Enterprise Manager. They didn't have any problem yesterday.
I have Windows Global groups, in Local Groups, and those Local Groups have SQL Logins. They're in the Global group. I had them close EM, re-open, I dropped the users out of the database, deleted the Local Group from SQL & re-added it, set the default databases to Master, took them out of, and back into the Global groups .... Had them close EM again etc ......... but still no-go.
As a workaround I gave them individual SQL logins using their Windows accounts, and everything's fine, but I don't want individual logins.
Can anyone think of what might be screwed up ?
Win2000, SQL2000, SP4
September 29, 2005 at 9:49 pm
One thing I can think of is if they were granted access to the database? You can make the default DB a DB that they don't actually have access to view. However EM gives an warning message with this so I would doubt that's it...
Hope that helps maybe a little... I can't think of any other reason that I've experienced...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply