Error Message: The New Membership Server Wizard Has Failed to Create a New Site Server LDAP Service (302948)


The information in this article applies to:

  • Microsoft Site Server 3.0 Commerce Edition
This article was previously published under Q302948

SYMPTOMS

When you run the Site Server Personalization and Membership Wizard to create a Membership Instance to a new Membership Directory SQL Server database, you may receive the following error message after you confirm your settings:
The New Membership Server Wizard has failed to create a new Site Server LDAP Service. Continue? Yes/No
If you continue, you receive the following error:
The New Membership Directory Wizard has failed to generate the full distinguished name (DN) of the user name required to complete the configuration.

CAUSE

This error can occur if the Use Quoted Identifiers option is enabled on the new database or on the SQL Server computer.

RESOLUTION

To disable the Use Quoted Identifiers option from the database, follow these steps:
  1. Start SQL Server Enterprise Manager, and then connect to the appropriate SQL Server computer.

    Click to expand the Databases folder.

    Create a new blank database or drop all of the user tables in your existing database.

    NOTE: If the wizard fails with the error message listed in the "Symptoms" section, there will be eleven user tables that need to be deleted or dropped.

    Right-click the database, and then click Properties.

    Click the Options tag.

    Make sure that the Use Quoted Identifiers option is not selected (checked).
  2. Click to expand the Databases folder.

    Create a new blank database or drop all of the user tables in your existing database.

    NOTE: If the wizard fails with the error message listed in the "Symptoms" section, there will be eleven user tables that need to be deleted or dropped.

    Right-click the database, and then click Properties.

    Click the Options tag.

    Make sure that the Use Quoted Identifiers option is not selected (checked).
  3. Create a new blank database or drop all of the user tables in your existing database.

    NOTE: If the wizard fails with the error message listed in the "Symptoms" section, there will be eleven user tables that need to be deleted or dropped.

    Right-click the database, and then click Properties.

    Click the Options tag.

    Make sure that the Use Quoted Identifiers option is not selected (checked).
  4. Right-click the database, and then click Properties.

    Click the Options tag.

    Make sure that the Use Quoted Identifiers option is not selected (checked).
  5. Click the Options tag.

    Make sure that the Use Quoted Identifiers option is not selected (checked).
  6. Make sure that the Use Quoted Identifiers option is not selected (checked).
To disable the Use Quoted Identifiers option on the SQL Server computer, follow these steps:
  1. Start SQL Server Enterprise Manager, and then connect to the appropriate SQL Server computer.

    Right-click the SQL Server computer name.

    Click the Connections tab.

    Make sure that the Use Quoted Identifiers option is not selected (checked).
  2. Right-click the SQL Server computer name.

    Click the Connections tab.

    Make sure that the Use Quoted Identifiers option is not selected (checked).
  3. Click the Connections tab.

    Make sure that the Use Quoted Identifiers option is not selected (checked).
  4. Make sure that the Use Quoted Identifiers option is not selected (checked).

MORE INFORMATION

When Quoted Identifiers are used, there is a limitation of 128 characters on any string that is contained in quotation marks in a SQL statement. During the Personalization and Membership Wizard setup, Site Server needs to update the Attributes table with the default values that are required for any Site Server Membership Instance. One of these values contains more than 128 characters, which in turn causes SQL Server to return an error and the Membership Wizard to report a failure.

NOTE: If all the new databases created on the SQL Server computer have the Use Quoted Identifiers option enabled by default, make sure that the Model database has this option disabled (unchecked).
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbprb KB302948
©2004 Microsoft Corporation. All rights reserved.