-
sql server agent not starting
Hi have you guys seen this error when trying to start the sql agent?
SQLServerAgent could not be started (reason: sqlserveragent must be able to connect to sqlserver as sysadmin, but '(unkown)' is not a member of the sysadmin rol.
What is this all about I can start the sql server service with the same account i'm trying to start the agent.
-
Fixed it, the BUILTIN\Administrators didnt have sysadmin roll, applied that and it started.
-
Better to add 'nt authority\system' in sql admin role, that way you don't have to give sa rights to all windows local admins.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|