PRB: Cannot Reinstall SQL Server After Deleting Files Manually

 Last reviewed: August 28, 1997
Article ID: Q173180
The information in this article applies to:
  • Microsoft SQL Server, version 6.5

SYMPTOMS

SQL Server Setup fails during the installation process when it attempts to start SQL Server. Setup shows the following error message in a dialog box before it quits: 

   The SQL Server installation could not be successfully completed.
   Setup could not connect to the SQL server.
The Windows NT event log shows the following error message: 

   Msg 17113 : initconfig: error 2(The system cannot find the file
   specified.) opening 'master.dat' for config information

CAUSE

A previous installation of SQL Server was removed by deleting the files from the SQL Server directory. Manually deleting registry keys and removing files is not the best way to remove SQL Server. Doing this causes any subsequent reinstallation to fail with the following error in the errorlog: 

   initconfig: error 2(The system cannot find the file specified.) opening
   'master.dat' for config information
The "Remove SQL Server option" may also be unavailable in the Setup program, so the only way to correctly reinstall SQL Server is to cleanly remove SQL Server and then reinstall it.

WORKAROUND

To reinstall SQL Server correctly, perform the following steps:

  1. Run "setup /t RegistryRebuild = ON" (without the quotation marks) from the Binn directory under the directory where SQL Server was installed.

    This rebuilds the registry and fills in any missing parameters. Type the same information in the setup dialog boxes as the first time SQL Server was installed. Setup will not copy any files or run any scripts, but it will re-create the registry and services as if you had done a full installtion.

  2. Run Setup again, and this time choose to remove SQL Server. This not only removes all the files, but also removes the registry entries.

  3. Reinstall SQL Server normally.

MORE INFORMATION

The RegistryRebuild = ON switch can not only be used in this situation, but also to recover from a situation where the Windows NT registry has been damaged, inadvertently modified, or restored. For more information, see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q157805
   TITLE     : BUG: RegistryRebuild Option of Setup Is Not Documented

Additional query words: regrebuild rebuildregistry gray grey greyed grayed
disabled input enter
Keywords : SSrvInst kberrmsg kbsetup
Version : 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: August 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.