March 3, 2008 at 12:32 pm
I am having issue with SQL Agent while starting , it does not restart until i explicitely run sp_configure 'Agent XPs', 1 , also not able to create any jobs and errors says
"Cannot perform this operation while SQLServerAgent is starting. Try again later. (Microsoft SQL Server, Error: 14258)"
I am using SQL 2005 SP1 on win 2 K3 and with out fibre mode.
Thanks
March 3, 2008 at 12:42 pm
what account are you using to run the service? and have/are you making chnages through config manager and not services. Not sure about SP1 but don't think it's relevent here.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
March 3, 2008 at 1:58 pm
I am using domain service account and there was no issue with until yesterday suddenly all replication jobs start failing and when i tried to create other new job i get the error , lot of articles suggested to switch off fiber mode but it is already off.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply