vanroybel
asked on
SQL server account lost password
Hello,
I had a problem this morning arriving at work, our SQL server was down. I checked the service and the service was stopped. Then I try to restart it and it doesn't (it gives a 1069 error). After looking a bit it seems it's a logon problem. My configured SQL user cannot log into sql server anymore. So i simply put another user in its place and it works for now.
I got my quick fix with this but I still got a few problem with it. I would like to reconfigure the user I had before. Problem is this server was installed by other people. I tried finding the user in the active directory users but I couldn't find it.
Is it possible this user is hidden some way? Or maybe it's configured as a system user so that it doesn't show where my "normal" users are? I need to change the password for that user so I can log in with it again. The active directory is on the primary domain controller which is a small business server 2003.
Thanks for your help.
I had a problem this morning arriving at work, our SQL server was down. I checked the service and the service was stopped. Then I try to restart it and it doesn't (it gives a 1069 error). After looking a bit it seems it's a logon problem. My configured SQL user cannot log into sql server anymore. So i simply put another user in its place and it works for now.
I got my quick fix with this but I still got a few problem with it. I would like to reconfigure the user I had before. Problem is this server was installed by other people. I tried finding the user in the active directory users but I couldn't find it.
Is it possible this user is hidden some way? Or maybe it's configured as a system user so that it doesn't show where my "normal" users are? I need to change the password for that user so I can log in with it again. The active directory is on the primary domain controller which is a small business server 2003.
Thanks for your help.
Vitor Montalvão
Go to the server and check in Services which user are running de SQL Server service.
try to see this to restore the password
http://community.spiceworks.com/how_to/show/22044-recover-sa-password-on-microsoft-sql-server
http://community.spiceworks.com/how_to/show/22044-recover-sa-password-on-microsoft-sql-server
king2002, he don't need to do that. He already have access to the instance so he can replace the SA password for a new one.
He's asking how to reconfigure the user that it was there before.
He's asking how to reconfigure the user that it was there before.
Are you talking about Service account, SQL Server Users that has Database access rights, some time same AD/or windows user may play both roles. anyway you can create user at your AD and grant required permission [user role, user mapping] as you wish, if you have Sysadmin permission. please let me know if you need some help.
ASKER
So to clarify :
The user SVCSQL was created by external people and is used to launch the SQL service. I replaced that user in the service by another but I would like to use SVCSQL again soon. I cannot find SVCSQL in the active directory so I cannot change the password and use that user again.
Where should I look in the AD to find this user? It is not with the "normal" users.
Seems Vitor understood the problem.
Pushpa, I'm not sure what you mean by Service account, but I suppose you mean the account that launches the service. I can create another user, but I would like to find where the user SVCSQL is. It seems abnormal to me that I cannot find this user in the AD since we've been using SQL server for 3 months in production now.
The user SVCSQL was created by external people and is used to launch the SQL service. I replaced that user in the service by another but I would like to use SVCSQL again soon. I cannot find SVCSQL in the active directory so I cannot change the password and use that user again.
Where should I look in the AD to find this user? It is not with the "normal" users.
Seems Vitor understood the problem.
Pushpa, I'm not sure what you mean by Service account, but I suppose you mean the account that launches the service. I can create another user, but I would like to find where the user SVCSQL is. It seems abnormal to me that I cannot find this user in the AD since we've been using SQL server for 3 months in production now.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I agree with Victor - sounds like somebody deleted that user from AD. Re-create the user.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help. I recreated the user and it seems to work.
I don't understand what happened, I was the only administrator at work, my colleague was on holiday. I didn't delete the user and nobody else should be able to.
Well anyway, thanks for the solution.
I don't understand what happened, I was the only administrator at work, my colleague was on holiday. I didn't delete the user and nobody else should be able to.
Well anyway, thanks for the solution.
If you have backups from the Active Directory you can see when was last time that user existed in AD.
Maybe was miss deleted.
Maybe was miss deleted.
ASKER
Thanks, gonna check that right away.
ASKER
Well...
I checked, and I couldn't find the user before either.
I don't know what to make of it, but it seems to be working now, that's the important part.
I checked, and I couldn't find the user before either.
I don't know what to make of it, but it seems to be working now, that's the important part.
Sure. It's important that's working but weird that you don't have a clue with what happened to the user.
Cheers
Cheers
ASKER
Is it possible that it continued to work even if deleted from the active directory? The problem I had at the beginning from what I read on the web is that my SQL server service somehow lost its password. So I changed the user and launched it again with an network administrator login.
Then when I got into the SQL server manager, I could see in security the previous user was still set. Maybe the fact that it was set there was enough to launch the service. Of course I could not reset the password, since the configuration in security is linked to the AD user.
I don't remember seeing that user for quite a while, it's possible we deleted it a long time ago since this SQL server was not used for more than a year.
Then when I got into the SQL server manager, I could see in security the previous user was still set. Maybe the fact that it was set there was enough to launch the service. Of course I could not reset the password, since the configuration in security is linked to the AD user.
I don't remember seeing that user for quite a while, it's possible we deleted it a long time ago since this SQL server was not used for more than a year.
Your last sentence can explain what happened.
Anyway depends on where and for what are you using the SQL Server user account. It only goes to read from AD when it need to do some action (job, script, ...). If not action is required then only you have a SQL Server's service restart that it will complain.
Anyway depends on where and for what are you using the SQL Server user account. It only goes to read from AD when it need to do some action (job, script, ...). If not action is required then only you have a SQL Server's service restart that it will complain.