FIX: The SQL Server 2008 agent does not automatically resume running after you upgrade to SQL Server 2008 CU7 or SQL Server 2008 SP1 CU3/CU4 in a stand-alone environment

Article translations Article translations
Article ID: 976953 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

In a stand-alone environment of Microsoft SQL Server 2008, you upgrade SQL Server 2008 to one of the following versions:
  • SQL Server 2008 Cumulative Update (CU) 7, build number from 10.00.1818 to 10.00.1822.
    973601 Cumulative update package 7 for SQL Server 2008
  • SQL Server 2008 Service Pack 1 (SP1) CU3 or CU4, build number from 10.00.2734 to 10.00.2739.
    971491 Cumulative update package 3 for SQL Server 2008 Service Pack 1
    973602 Cumulative update package 4 for SQL Server 2008 Service Pack 1


However, after you complete the upgrade, the SQL Server agent does not automatically resume running even if it was running before you performed the upgrade.

RESOLUTION

To resolve this problem, use the following table to find the appropriate method for your version of SQL Server.
Collapse this tableExpand this table
The SQL Server version before upgradeThe SQL Server version that you try to upgrade toResolution
The release version of SQL Server 2008SQL Server 2008 CU7, build number from 10.00.1818 to 10.00.1822Use the method that is described in the "Workaround" section. Or, wait for a hotfix solution.
SQL Server 2008 SP1SQL Server 2008 SP1, build number from 10.00.2734 to 10.00.2739Use the method that is described in the "Workaround" section. Or, install the hotfix that is mentioned in Microsoft Knowledge Base (KB) article 976761.

For more information, click the following article number to view the article in Microsoft Knowledge Base:

976761 FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster : "18401, Login failed for user SQLTEST\AgentService. Reason: Server is in script upgrade mode. Only administrator can connect at this time.[SQLState 42000]"

WORKAROUND

To work around this problem, manually start the SQL Server agent after you perform the upgrade.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

To know whether the version of SQL Server that is installed on your computer is affected by this problem, check whether the version of the Sqlagent.exe file matches one of the affected versions in the "Symptoms" section. Generally, the Sqlagent.exe file is in one of the following folders, depending on whether SQL Server is installed by using Windows on Windows (WOW) mode.
  • drive:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\Sqlagent.exe
  • drive:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\Sqlagent.exe

For more information about how to identify the SQL Server version, click the following article number to view the article in the Microsoft Knowledge Base:
321185 How to identify your SQL Server version and edition

REFERENCES

For more information about the same issue in a cluster environment, click the following article number to view the article in Microsoft Knowledge Base:

976761 FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster : "18401, Login failed for user SQLTEST\AgentService. Reason: Server is in script upgrade mode. Only administrator can connect at this time.[SQLState 42000]"


For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates

Properties

Article ID: 976953 - Last Review: November 13, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Workgroup
Keywords: 
kbexpertiseadvanced kbsurveynew kbqfe kbfix KB976953

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com