DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 976953 - Last Review: November 13, 2009 - Revision: 1.0

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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/971491/ ) Cumulative update package 3 for SQL Server 2008 Service Pack 1
    973602  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/824684/ ) Description of the standard terminology that is used to describe Microsoft software updates

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
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support