Microsoft KB Archive/296377

= SMS: SMS May Produce Access Violation Errors During SQL Server Upgrade =

Article ID: 296377

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q296377



SYMPTOMS
When you perform a service pack upgrade to a Microsoft SQL Server that is a Systems Management Server (SMS) Site Database server, the SMS Executive service may generate an &quot;Access Violation&quot; error and log the following entries repetitively:

Compsumm.log:

Error: Could not get a SQL connection from the connection cache. Will try again in 60 seconds. : The handle is invalid.

Sitestat.log:

Error: Could not get a SQL connection from the connection cache. Will try again in 60 seconds. : The handle is invalid.

>: This is a Primary Site, the datastore is SQL



CAUSE
This issue occurs because during a SQL Server service pack upgrade, the MSSQLSERVER service restarts in single-user mode, which disconnects any processes that are currently connected to the SQL Server databases and which does not allow them access to any database objects until the upgrade is complete.



WORKAROUND
To work around this issue, on the SMS Site server, manually stop the SMS_SITE_COMPONENT_MANAGER service, the SMS_EXECUTIVE service, and the SMS_SQL_MONITOR service prior to performing the SQL Server service pack upgrade.



MORE INFORMATION
Sites may stop and cease to function until you manually restart the services if you do not stop them prior to any SQL upgrades. Microsoft recommends that you always shut down the SMS_SITE_COMPONENT_MANAGER service, the SMS_EXECUTIVE, and the SMS_SQL_MONITOR service before you perform a SQL Server upgrade.

Additional query words: prodsms sql database AV

Keywords: kbdatabase kbinterop kbprb kbserver kbsetup kbupgrade KB296377

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.