PRB: SQL Server May Appear to Stop Responding Upon Startup

 Last reviewed: October 21, 1997
Article ID: Q175398
The information in this article applies to:
  • Microsoft SQL Server version 6.5

SYMPTOMS

SQL Server starts successfully, but any attempt to connect to it is unsuccessful. It appears as if the server has stopped responding.

CAUSE

The automatically executed sp_sqlregister stored procedure calls the xp_sqlregister extended stored procedure. The DLL that contains this extended stored procedure has additional functions that depend on Open Database Connectivity (ODBC). If the versions of Odbcint.dll and Odbc32.dll on the computer are different, the ODBC Driver Manager produces the following message: 

   The ODBC resource DLL(C:\WINNT\System32\odbcint.dll) is a different
   version than the ODBC driver manager (C:\WINNT\System32\ODBC32.dll).

   You need to reinstall the ODBC components to ensure proper operation.

   PRESS OK to proceed, CANCEL to abort.
The problem occurs when SQL Server is running as a service without the "Allow Service to Interact with Desktop" check box enabled. If this is the case, the warning dialog box described above goes to the virtual desktop, so you never see it. Because you can't see it, you can never press OK to continue, so it appears that the server has stopped responding.

WORKAROUND

To permanently resolve this problem, update your ODBC components so that they all have the same file versions.

To temporarily work around this problem, do any one of the following:

  • Enable trace flag 4022 (-T4022) in the startup parameters, to bypass the startup stored procedures.
  • Change the startup account to system account with the "Allow Service To Interact With Desktop" option enabled so that you can get the warning message and press OK to continue.
  • Start SQL Server from a command prompt with the -c option.

Additional query words: hang hung xproc sproc stproc autoexec startup
Keywords : SSrvGen SSrvStProc kbenv kbinterop
Version : WINNT:6.5
Platform : WINDOWS
Issue type : kbprb
Solution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 21, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.