Link to home
Start Free TrialLog in
Avatar of shanj
shanj

asked on

Running sql on my local pc, cannot start sql Agent

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)
Avatar of Daniel_PL
Daniel_PL
Flag of Poland image

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
Avatar of shanj
shanj

ASKER

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.

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

Open in new window

Avatar of shanj

ASKER

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.
Avatar of shanj

ASKER

Hello Daniel!
      the link u sent me it says that sql agent is not suported with the 2008 express ?
ASKER CERTIFIED SOLUTION
Avatar of Daniel_PL
Daniel_PL
Flag of Poland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of shanj

ASKER

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