Running sql on my local pc, cannot start sql Agent

shanj
shanj used Ask the Experts™
on
Cannot start sqlagent from the config manager, getting the following error

2011-05-14 22:26:29 - ! [298] SQLServer Error: 15247, User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
2011-05-14 22:26:29 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_has_server_access', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
2011-05-14 22:26:29 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_info', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2011-05-14 22:26:29 - ! [298] SQLServer Error: 229, The UPDATE permission was denied on the object 'sysalerts', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (DumpAndCheckServerVersion)
2011-05-14 22:26:29 - ! [298] SQLServer Error: 229, The INSERT permission was denied on the object 'syssessions', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2011-05-14 22:26:29 - ! [000] Error creating a new session
2011-05-14 22:26:30 - ? [098] SQLServerAgent terminated (normally)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Daniel_PLDB Expert/Architect
Top Expert 2011

Commented:
Service account from which SQL Agent is running doesn't have administrative priviledges in SQL Server. It's adviced to change accounts and password using SQL Server Configuration Manager.

Use following procedure, it's for SQL 2005 but will apply:
Fixing Startup Failure of SQL Server Agent Service in SQL Server 2005

Author

Commented:
Hello Daniel!
      right on the Target the logon user is defined as NT AUTHORITY\NETWORKSERVICE

I do not find this user in my login so i tried to create this user
CREATE LOGIN [NT AUTHORITY\NETWORKSERVICE] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
GO

GETTING THE FOLLOWING ERROR
Msg 15401, Level 16, State 1, Line 1
Windows NT user or group 'NT AUTHORITY\NETWORKSERVICE' not found. Check the name again.

??
Daniel_PLDB Expert/Architect
Top Expert 2011

Commented:
Try following
USE [master]
GO
CREATE LOGIN [NT AUTHORITY\NETWORK SERVICE] FROM WINDOWS WITH
DEFAULT_DATABASE=[master]
GO

Open in new window

Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
Daniel!
   getting the same error
"Msg 15401, Level 16, State 1, Line 1
Windows NT user or group 'NT AUTHORITY\NETWORKSERVICE' not found. Check the name again."

This is of utmost importance, hope to solve it today.

Author

Commented:
Hello Daniel!
      the link u sent me it says that sql agent is not suported with the 2008 express ?
DB Expert/Architect
Top Expert 2011
Commented:
If you're using SQL Express edition it's not available. I didn't ask, but for future it's always good to paste your configuration in initial post ;)

Author

Commented:
The link helped me, did not read the entire replies.
Anyway found the solution in the link

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial