We previously had SQL Server 2008 R2 Express to try some things out (I know it is by design that the agent service is disabled in this version)
After proving the concept, we upgraded to the standard edition. I did feature add with management tools (complete) and then did a repair. The SQL Agent still wont start. All SQL services are being run as "Local Service" (I can set up limited accounts after things work more smoothly)
I found an MS site that had listed my particular issue, but the steps no the "fix it for me" would not work.
When I attempt to start the service I get this message in the Event Viewer:
Event ID 7034: The SQL Server Agent (SQLEXPRESS) service terminated unexpectedly. It has done this 1 time(s).
Any help would be greatly appreciated.
Best Answer
I was able to backup all of the sharepoint databases before completely removing and reinstalling SQL server 2008 r2 standard. I had to make sure to completely remove ALL of the SQL Server directories from Program Files & Program Files (x86). I didn't do this the first time and my SQL Agent service still wouldn't start/gave the same error.
Looking more closely at it, I am wondering if there was some .CER file conflict as I saw some files labeled with SQL Agent in the name in those directories after the second removal.
For added measure, this link seems to walk you through the general steps needed to migrate SP to a new SQL server: http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=255