SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Services
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

montu
Yak Posting Veteran

60 Posts

Posted - 01/13/2008 :  19:20:47  Show Profile  Reply with Quote
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

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 01/13/2008 :  19:42:20  Show Profile  Reply with Quote
Any related message in sql agent error log and win event logs?
Go to Top of Page

montu
Yak Posting Veteran

60 Posts

Posted - 01/13/2008 :  20:06:07  Show Profile  Reply with Quote
nothing
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 01/13/2008 :  21:13:14  Show Profile  Reply with Quote
Can you start it manually?
Go to Top of Page

montu
Yak Posting Veteran

60 Posts

Posted - 01/13/2008 :  21:28:23  Show Profile  Reply with Quote
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.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 01/13/2008 :  21:36:54  Show Profile  Reply with Quote
Any error? Is password correct?
Go to Top of Page

montu
Yak Posting Veteran

60 Posts

Posted - 01/13/2008 :  22:24:08  Show Profile  Reply with Quote
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

Edited by - montu on 01/13/2008 23:09:13
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 01/13/2008 :  23:35:35  Show Profile  Reply with Quote
Many reasons, that's why you have to look at error message.
Go to Top of Page

montu
Yak Posting Veteran

60 Posts

Posted - 01/14/2008 :  21:21:16  Show Profile  Reply with Quote
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.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 01/14/2008 :  23:30:59  Show Profile  Reply with Quote
Sql agent service account needs sysadmin rights while sql server service account doesn't.
Go to Top of Page

montu
Yak Posting Veteran

60 Posts

Posted - 01/15/2008 :  00:06:26  Show Profile  Reply with Quote
That domain account got sys admin rights
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 01/15/2008 :  23:30:27  Show Profile  Reply with Quote
Then have to look at error message, should be in windows app event log.
Go to Top of Page

mdubey
Posting Yak Master

USA
133 Posts

Posted - 05/26/2008 :  22:21:46  Show Profile  Reply with Quote
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).

Manoj
MCP, MCTS
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 05/26/2008 :  22:58:36  Show Profile  Reply with Quote
>> deny on login

Hope you are not talking about sql agent account. By the way, how far you like to go back?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000