June 30, 2003 at 8:14 am
Hi everyone, I have SQL 8.0 running on a Win 2000 Advanced Server box. I've been trying to get the SQL Server Agent started so I can backup the my tables at regular intervals, but I get the following error in the events manager when I try to get it started:
SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).
Any ideas how I can rectify the above? I am not an SQL expert so feel free to treat me like a dummy when explainig how to go about this :-]
Thanks
George
June 30, 2003 at 8:24 am
Determine what account the SQL Server agent is attempting to run under. Add that user account to the System Administrators role (sysadmin) on the SQL Server itself.
In Enterprise Manager >> Security | Server Roles.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
June 30, 2003 at 8:33 am
Hi and thanks for the quick response. The account is "sa" and it's in the Systems Administrator server role. So as far as I can see it has the permissions necessary.
June 30, 2003 at 2:57 pm
But SQL Server Agent is a Windows service. That means it runs under the context of a Windows user account or the LocalSystem. If it's running under LocalSystem and you've removed BUILTIN\Administrators, you'll need to add [NT Authority\System] as a login and put it in the SysAdmin role.
You can find what account SQL Server agent is running under by Start | Run | Services.msc. Scroll down to where you see the service.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply