Help with Setup

Troubleshooting SQL Server

Troubleshooting

Help with Setup

The online Setup Troubleshooter is designed to help you resolve problems you may encounter when installing one of these editions of Microsoft® SQL Server™ 2000:

  • Microsoft SQL Server 2000 Personal Edition

  • Microsoft SQL Server 2000 Standard Edition

  • Microsoft SQL Server 2000 Enterprise Edition

Note  For international users of SQL Server Books Online, the text of the problems as well as the references to Knowledge Base articles appear in English and can be found on nonlocalized Web sites.

Common starting points for troubleshooting the installation of the Personal Edition include:

  • Does Setup stop responding when it tries to connect to the server?

  • Do you get an error when setup is trying to configure the server?

  • Does setup fail with an error indicating that you are running an evaluation version?

  • Does your system meet the minimum software and hardware requirements?

  • Do you get an error message that asks you to close all ODBC components?

  • Is Family Logon the primary network logon?

  • Do you get an error message indicating that setup cannot find SQL Server 2000?

  • Do you receive an error message indicating problems with character set and sort order?

  • Do you receive an error indicating that setup was unable to create a registry key?

  • Do you receive an error indicating that the file mfc42u.dll is read-only?

  • Is there a line in your sqlstp.log file indicating that "LoadLibrary failed on sqlsui.dll"?

  • Are you experiencing a system File Protection (SFP) issue around the install of MDAC?

Common starting points for troubleshooting the installation of the Standard Edition include:

  • Does your system meet the minimum software and hardware requirements?

  • Do you get an error message that asks you to close all ODBC components?

  • Does setup fail with an error indicating that you are running an evaluation version?

  • Do you get an error message indicating that setup cannot find SQL Server 2000?

  • Do you receive an error message indicating problems with character set and sort order?

  • Do you receive an error indicating that setup was unable to create a registry key?

  • Do you get an error when setup is trying to configure the server?

  • Do you receive an error indicating that the file mfc42u.dll is read-only?

  • Is there a line in your sqlstp.log file indicating that "LoadLibrary failed on sqlsui.dll"?

  • Are you experiencing a system File Protection (SFP) issue around the install of MDAC?

Common starting points for troubleshooting the installation of the Enterprise Edition include:

  • Does your system meet the minimum software and hardware requirements?

  • Are you installing SQL Server on a compatible operating system?

  • Do you get an error message that asks you to close all ODBC components?

  • Does setup fail with an error indicating that you are running an evaluation version?

  • Do you get an error message indicating that setup cannot find SQL Server 2000?

  • Do you receive an error message indicating problems with character set and sort order?

  • Do you receive an error indicating that setup was unable to create a registry key?

  • Do you get an error when setup is trying to configure the server?

  • Do you receive an error indicating that the file mfc42u.dll is read-only?

  • Is there a line in your sqlstp.log file indicating that "LoadLibrary failed on sqlsui.dll"?

  • Are you experiencing a system File Protection (SFP) issue around the install of MDAC?

To access troubleshooters online, see Viewing Online Troubleshooters and other PSS Web-Based Information.