May 5, 2010 at 1:00 pm
we have an SQL server 2008 server that communicates with sharepoint 2007 server.The communication between both servers works fine,except the search functionality .By investigating we found that sql server agent stopped.we cant get it to start working.The error message gives an unhandled exception with some stack errors.The account under which sql server agent runs has been given all the rights too.
Has anyone faced this problem before ?
May 5, 2010 at 5:31 pm
Can you post the specific error?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 6, 2010 at 7:31 am
Please find the attached document below with all the screen shots of error message
May 6, 2010 at 7:36 am
It's hard to tell from that, but I'd start in the usual places. Check the service in the Configuration manager and be sure that it's set to a good login. Security is frequently the initial problem, although it usually evidences in different ways than this.
If it's not security you may need to open a case with Microsoft. That's not an issue I see.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 6, 2010 at 9:33 am
I tend to agree with Grant. It does look like some type of corruption or issue with the Agent DLLs.
May 6, 2010 at 10:49 am
Safe to assume, you've bounced the box?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply