Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Richard81
Starting Member
3 Posts |
 Posted - 2005-11-21 : 11:02:20
|
| Hi all, firstly I would like to apologise because I don't actually use sql or know diddly squat about it. I am a network administrator and have a problem with a user's domain account getting locked out everytime he starts his sqlagent service (we are running a windows 2003 domain). I know this a vary vague post and I am sorry for that. I am just after some general ideas/information on why this keeps happening. Any help greatly appreciated.ThanksRich. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-11-21 : 11:10:08
|
| More than likely, he is using his account for the SQL Agent service, and doesn't have the correct password setup for the service.A likely cause for the bad password is that he has changed his password since he setup the service.CODO ERGO SUM |
 |
|
|
Richard81
Starting Member
3 Posts |
Posted - 2005-11-21 : 11:24:49
|
| Yeah thats what I thought but we changed his password in the service and it is still happening, I even tried setting up a local account to run the service and it still locked out his domain account! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-11-21 : 11:42:40
|
| Make sure you change his password on all services:SQL Server serviceSQL Agent serviceCODO ERGO SUM |
|
|
|
Richard81
Starting Member
3 Posts |
Posted - 2005-11-21 : 11:47:25
|
| Do all the sql services have to run off the same account? |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-11-21 : 11:59:09
|
No, but it has to have the correct password wherever it is used.quote:
Originally posted by Richard81
Do all the sql services have to run off the same account?
CODO ERGO SUM |
|
|
|
|
|
|
Locking out!