Hi All Today 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
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.
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 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.