Err Msg: SAWIZARD The New Membership Server Wizard Has Failed to Configure the Site Server LDAP Service (229044)

The information in this article applies to:

Microsoft Site Server 3.0

This article was previously published under Q229044

SYMPTOMS

When you move your Membership Directory database from its original SQL Server to a new SQL Server, the following error message may occur when you attempt to create a new membership instance to the existing data:

SAWIZARD
The new membership server wizard has failed to configure the site server LDAP service.

CAUSE

The information in the database is no longer valid because it has been moved.

RESOLUTION

To resolve this issue, edit the data in the database using the following steps:

Execute the following SQL Server query on the Membership database:

      update dsogrid 
      set vc_datasource = '<new sql servername>' 
      where vc_datasource = '<old sql servername>'

Depending upon the changed values, you may need to repeat step one
for the following values as well:

      vc_login is for your SQL access account name
      vc_password is for the SQL access account password
      vc_database is for the membership directory name

MORE INFORMATION

The Membership database contains information on the SQL Server and access account for use when creating multiple membership instances to the same data.

CAUTION: It is completely unsupported to directly modify the data in the SQL Server database. If you modify this data, and the directory becomes inaccessible, you will be required to start from a restore backup.

Modification Type:	Major	Last Reviewed:	10/20/2000
Keywords:	kbprb KB229044