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.
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_ac
2011-05-14 22:26:29 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_i
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)
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_ac
2011-05-14 22:26:29 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_i
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)
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
Use following procedure, it's for SQL 2005 but will apply:
Fixing Startup Failure of SQL Server Agent Service in SQL Server 2005
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],
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.
??
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],
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
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.
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial