February 8, 2011 at 7:28 am
We had SQL Server 2007 installed. We upgraded to SQL Server 2010. All is well, but the SQL Agent will not start - I have tried using different credentials for the service, so it LOOKS like it starts, but Windows Event Viewer reports this error:
"SQLServerAgent could not be started (reason: This installation of SQL Server Agent is disabled. The edition of SQL Server that installed this service does not support SQL Server Agent.)."
Here is the version of our server:
Microsoft SQL Server Management Studio 10.0.4000.0
Microsoft Analysis Services Client Tools 10.0.4000.0
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4952
Operating System 6.1.7600
How can I just install the SQL 2008 Agent for our server?
February 8, 2011 at 8:37 am
I think that you installed SQL Server Express. That doesn't support SQL Agent. You can't install it because it just won't work. You have to look for some other method of scheduling jobs on the machine. A quick google search shows several third party apps. Here's one.
By the way, there is no SQL Server 2007, and SQL Server 2010 has not been released yet. 2010 is under development with the code name Denali. There is a Client Technology Preview available. The SQL Server releases are SQL Server 2000, 2005, 2008, and 2008 R2. Prior to that there was SQL Server 7, maybe you were upgrading from that?
"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
February 8, 2011 at 11:07 am
February 8, 2011 at 11:10 am
February 8, 2011 at 12:39 pm
pavan_srirangam (2/8/2011)
I think the code nam edenali is sql server 2011 I guess not sql 2010.
If it comes out on schedule, it will be SQL 2011, yes.
"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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply