Author |
Topic |
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-13 : 19:20:47
|
Hi AllToday i come across some thing new that i never experienced before. one of my SQL Server services running under domain account(which is part of sys admin group). this server restart on sat night SQL server service starts but SQL Server Agent service didn't. in properties Autostart SQL Server Agent is enabled. what i can't understand if SQL Server Service starts under domain account why SQL Server Agent Service didn't any clue please share |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-13 : 19:42:20
|
Any related message in sql agent error log and win event logs? |
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-13 : 20:06:07
|
nothing |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-13 : 21:13:14
|
Can you start it manually? |
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-13 : 21:28:23
|
i did but interestingly it didn't run under domain account then i start it under local admin account. question is why i did work for same domain account it used to run under and SQL Server Service is nicely running under same domain account. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-13 : 21:36:54
|
Any error? Is password correct? |
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-13 : 22:24:08
|
what i did go to services (mycomputer--manage--services) right click on SQLAgent click start. i didn't change the password or any thing. then i try it for local admin account and it works. i didn't record the error but i will get that may be tomorrow because i don't have the password of that domain account with me in order to test it again.but do u have experienced some thing that server runs but agent doesn't for same domain account |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-13 : 23:35:35
|
Many reasons, that's why you have to look at error message. |
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-14 : 21:21:16
|
Rmiao i could not get hold on the person who knows the password of that particular account moment i got it i will try and post the error here but in the mean while can u please advice me is it possible that SQL Server service runs fine under one account but SQL Agent service couldn't. i doubt it may be bacause of some group policies. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-14 : 23:30:59
|
Sql agent service account needs sysadmin rights while sql server service account doesn't. |
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-15 : 00:06:26
|
That domain account got sys admin rights |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-15 : 23:30:27
|
Then have to look at error message, should be in windows app event log. |
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-05-26 : 22:21:46
|
If SQL engine is running on domain a/c then you should get an issue on it. First thing without error log no one can give you the correct suggestion.Make sure SQL service a/c has Sysadmin access on the server, but again make sure noone can login with SQL service a/c. (deny on login).ManojMCP, MCTS |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-26 : 22:58:36
|
>> deny on loginHope you are not talking about sql agent account. By the way, how far you like to go back? |
|
|
|