July 3, 2008 at 1:11 pm
My SQL Server 2000 is configured for SQL Server and Windows authentication. After I delete or take offline one particular user database, I can no longer Windows authenticate to the server using Enterprise Manager. I use the SA account to get back in to restore the user database and Windows authentication works again. Any idea what is causing this? I don't encounter the same issue when taking offline other user databases. My windows account is a member of the local Administrators account which is set up as a System Administrator role. Thanks.
July 3, 2008 at 2:05 pm
Check the DEFAULT Database Assigned to the WINdows LOGIN.
Change it to master.
Maninder
www.dbanation.com
July 3, 2008 at 2:40 pm
Interesting. Thanks for the tip. It worked! I changed default db for the login that was based on a Windows Group where I was a member.
But why did this work? I just assumed that if the login only has access to one user db, then it made sense to set the default db to be the same. Sorry for the newb question; I didn't think the default db setting had such major implications and want to avoid future problems. Many thanks.
July 3, 2008 at 6:39 pm
YES True, and that is what the Default Database Setting is ment to be. But as it stands, More Freedom, more issues. So i personally Stopped the usernames getting their default database and insted now i use master.
Maninder
www.dbanation.com
July 4, 2008 at 8:51 am
Thanks again. You saved me a lot of time figuring this out. 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply