SQL Server Does Not Initialize if Character Set Is Not Present on the SBS Computer (225484)


The information in this article applies to:

  • Microsoft BackOffice Small Business Server 4.0
  • Microsoft BackOffice Small Business Server 4.5
  • Microsoft BackOffice Server 4.5
This article was previously published under Q225484

SYMPTOMS

During SQL Server 7.0 Setup in BackOffice Small Business Server (SBS), you are prompted to choose the character set that SQL Server uses for character-based data types. After you choose a character set, SQL Server does not start when it is initialized.

CAUSE

This behavior occurs when you choose a character set that is not installed on the server.

RESOLUTION

To resolve this problem, rebuild the master database:
  1. Put SBS 4.5 CD-ROM 2 into the CD-ROM drive.
  2. In the SQL Server 7.0 installation folder (C:\Mssql7\Binn), run Rebuildm.exe.
  3. When the Rebuild Master dialog box appears, click Browse, and then click the x:\Sql70\X86\Data folder, where x is the CD-ROM drive.
  4. Click Settings to set the correct settings, and then click OK.
  5. Click Rebuild.
Modification Type:MajorLast Reviewed:11/19/2003
Keywords:kbbug kbnofix KB225484
©2003 Microsoft Corporation. All rights reserved.