Microsoft KB Archive/242596

= Membership Server Wizard Does Not Display Warning About not Using SQL 7.0 Databases with Numeric Names =

Article ID: 242596

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition
 * Microsoft Site Server 3.0 Commerce Edition

-



This article was previously published under Q242596



SYMPTOMS
When creating a new Membership Server instance with Site Server 3.0, Service Pack 2 (SP2), and attempting to use a SQL Server 7.0 database where the database name begins with a numeric character, the following error message appears:

The New Membership Server Wizard has failed to create a new Site Server LDAP Service.

Instead of an error that says that the Membership Server failed, a warning should be instead be displayed by the wizard to prevent you from using a database that begins with a numeric character.

NOTE: Not being able to use a database that begins with a numeric character is by design, in order to provide backwards compatibility to SQL Server 6.5.



WORKAROUND
Use database names in that the first character of the name begins with a letter rather than a number.



RESOLUTION
To resolve this problem, obtain the latest service pack for Site Server 3.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

219292 How to Obtain the Latest Site Server 3.0 Service Pack



STATUS
This problem was first corrected in Site Server 3.0 Service Pack 3.



Steps to Reproduce Behavior

 * 1) Open the Site Server Admin MMC snap-in, and then open Personalization and Membership in the scope pane.
 * 2) Right-click the computer name, click New, and then click Membership Server Instance.
 * 3) Create new membership instance, using membership authentication.
 * 4) Type a directory name and give it a password.
 * 5) Select SQL Server database.
 * 6) Type a name for SQL server, using a number for database name, and then enter the SQL Server authentication information.
 * 7) Use the default LDAP port, and then click Finish on the Complete the Configuration dialog box.

Additional query words: ss3 number

Keywords: kbbug kbfix KB242596

-

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

© Microsoft Corporation. All rights reserved.