November 14, 2008 at 6:43 am
I have taken over a SQL Server 2000 server, appears to set up with Windows authentication.
It has 2 domain accounts set up as well as the sa account.
No one knows the passwords of the 2 windows accounts or the sa account.
So, I can't connect to the databases.
If I reset the password for sa, it doesn't get me anywhere since the install is set for Windows authentication.
I really don't want to change the passwords of either of the 2 domain accounts since no one knows what applications, services etc are using these accounts.
Any suggestions?
November 14, 2008 at 7:05 am
Have you considered enabling mixed authentication so that sa will work?
If you've done all the research you can, nobody knows anything about those accounts and you really don't have any other options, you can always temporarily disable each domain account (one at a time) to see what, if anything breaks. If anything is relying on them, you should find out quickly enough. Once you know, re-enable the accounts and arrange the password change. Just make sure the accounts get documented so you don't end up in this situation down the road. I know it's not very elegant but sometimes you have to rely on such tactics to move things forward.
November 14, 2008 at 10:55 am
I would like to enable mixed authentication but I don't know the passwords of the 2 domain or the sa account in order to change anything.
Unless I can change the authentication without admin rights.
November 14, 2008 at 11:06 am
Hmm. Is your own domain user account in the Administrators group of the server that SQL is installed on?
November 14, 2008 at 1:20 pm
Yes, my domain account is part of the servers local administrators group.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply