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 |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2005-01-31 : 07:35:51
|
| I am having a problem getting the sqlagent windows service to start for an instance of sql server. I've double checked the logon parameters (userid/password) and these should be correct. The windows user has full authority on this instance. The error I'm getting when I try to start is 'the sqlagent$instance service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service.'.When I look at the event viewer, it says 'sqlserveragent could not be started (reason: unable to connect to server 'server\instance'; sqlserveragent cannot start'.What am I doing wrong? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-01-31 : 11:04:20
|
| have you removed the BUILTIN\Administrators group from SQL Server? How is your sqlagent user granted access to the database? Can you test by explicitely giving that particular user SA privs in the instance?-ec |
 |
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2005-01-31 : 11:15:20
|
| the builtin\administrators group has been removed. The windows user that we are trying to use has full access (all roles). It is also the same user that is starting the mssql$instance service and it appears to be working alright there. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-01-31 : 11:57:09
|
| when you say all roles, what specific roles are you talking about? I am saying that this user needs the fixed server role called 'sysadmin'. You should also doublecheck to make sure that this user is actually trying to connect with the proper user. If you removed BUILTIN\Administrators, the local system account will not be granted access to the database. It sounds very much like your sqlagent is trying to start as the local system account.Also, there are some ramifications with full text search and removing the BUILTIN\Administrators account from SQL Server. If you are going to be using full text search, you might want to look into technet for the workaround. -ec |
|
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2005-01-31 : 12:13:31
|
| the windows user is a member of the administrators group on the machine. The windows user also has the system administrator role in the sql server instance. I agree that it sounds like it's trying to start as the local system account, but I cannot see a reason why yet. |
|
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2005-01-31 : 12:43:41
|
| I've figured it out. Windows authenication wasn't selected within the sql server agent properties (connection). |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-01-31 : 18:10:49
|
quote:
Originally posted by helpme
I've figured it out. Windows authenication wasn't selected within the sql server agent properties (connection).
thanks for posting the fix for this problem. Hopefully it helps someone down the road.-ec |
|
|
|
|
|
|
sqlagent won't start