October 29, 2014 at 4:14 am
Hi Everyone,
We are having Windows 2008R2 Server and SQL server 2012,
Today i installed an instance ,After successfull installation the SQL server Agent job shown "Agent XPS disabled",
So i reconfigure the
EXEC SP_CONFIGURE 'show advanced options',1
GO
RECONFIGURE
GO
EXEC SP_CONFIGURE 'show advanced options'
go
EXEC SP_CONFIGURE 'Agent XPs',1
GO
RECONFIGURE
After executing the above the Agent services showing like cross mark and its not starting
I changed the Account type as Administrator it is starting but if i change it to Local system it is not starting..
Can you please help me out..
Regards
Chowdary...
October 29, 2014 at 4:19 am
What does the SQL Server Agent log say? What's the error?
-- Gianluca Sartori
October 29, 2014 at 5:06 am
Hi Gianluca Sartori Thank you for your reply..
Pls find the below error msg...
"SQL Server :request failed or the service did not respond in a timely fashion"
Regards
Chowdary...
October 29, 2014 at 5:28 am
OK, this is the message you get from the service start operation.
What I wanted you to share is the contents of the SQL Server Agent log, which is located in the instance root folder, under the Log folder and is named "SQLAGENT.OUT".
In my laptop this is the path to the log:
D:\MSSQL11.SQL2012\MSSQL\Log\SQLAGENT.OUT
Can you please post what's inside this file?
-- Gianluca Sartori
October 29, 2014 at 6:11 am
PFA...
And If i change the login type as admin then it is starting and working fine,
But if a user wants to connect the server means whether he can access the jobs or not..
Please help me out..
Regards
Chowdary...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply