Database Error When Creating Membership Directory Using SQL Server Alias

• Microsoft Site Server version 3.0

SYMPTOMS

When you create a new Membership directory, the following error message may occur in the New Membership Server Wizard:

Verify that the information entered is correct and that the database is empty. The database specified is either empty or not valid.

CAUSE

You are attempting to connect to the SQL Server computer using a SQL Server alias name and you have Microsoft Data Access Components version 2.1 SP2 on your Site Server computer. This configuration is not supported.

RESOLUTION

You must connect to your SQL Server computer using the actual name of the SQL Server computer.

MORE INFORMATION

For additional information, please see the following articles in the Microsoft Knowledge Base:

Q216415 INF: How to Set Up SQL Server for Access Through Proxy Server

Q239855 Event Log Errors on Membership Directory After Upgrading to MDAC 2.1 SP2

Additional query words:

Keywords :
Version : winnt:3.0
Platform : winnt
Issue type : kbprb