Microsoft KB Archive/239855

= Event Log Errors Occur on Membership Directory after Upgrading to MDAC 2.1 SP2 =

Article ID: 239855

Article Last Modified on 10/30/2003

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition

-



This article was previously published under Q239855



SYMPTOMS
When you upgrade the Microsoft Data Access Components (MDAC) on your Site Server computer, the System log may generate one or more of the following event IDs:

Event ID: 2500

Source: LDAPSVC

Description: The server failed to start due to an initialization error. Verify the configuration. Error description is: GetLastError=-2146893792: StaticStore.

Event ID: 481

Source: LDAPSVC

Description: Site Server LDAP Service cannot initialize the following object: GetLastError=-2146893792 : Init LdapExtension.

The Application log may also generate one or more of the following event log messages:

Event ID: 20

Source: P&M Directory Store

Description: Unable to connect to DB server with the connect string: Driver=(SQL Server);SERVER= ;DATABASE= ;UID= ;PWD= ;NETWORK=dbmssocn.dll. Validate login and verify database is running with TCP/IP support.

Event ID: 4107

Source: MembershipBroker

Description: The Site Server Authentication Service could not do an LDAP bind. Error: 81, virtual server number 2. If this happened during a reboot of the machine and the LDAP server is on the same machine, it is not critical. The Authentication Service wil automatically recover from this problem when the first authentication happens.

Note: The word 'wil' above is misspelled in the actual error message.

Event ID: 4102

Source: MembershipBroker

Description: The Site Server Authentication Service could not connect to the LDAP server. Error: 81, virtual server number 2. If this happened during a reboot of the machine and the LDAP server is on the same machine, it is not critical. The Authentication Service wil automatically recover from this problem when the first authentication happens.



CAUSE
This problem occurs when you attempt to connect to the SQL Server computer using a SQL Server alias name and you have Microsoft Data Access Components version 2.1 SP2 installed on your Site Server computer.



RESOLUTION
To resolve this issue, do one of the following:
 * Create a new Membership Server Instance using the actual SQL Server name to replace the failing Membership Server Instance. -or-


 * Correct the SQL Server name in the database and the LDAP properties.

Creating a New Membership Server Instance
  Change the server name that is stored in the Membership database. Using isql/w or Query Analyzer, execute the following script: Update DsoGrid Set vc_datasource = '' Where vc_datasource = ''  Create a new instance using the actual SQL Server name instead of the SQL Server alias. For more information, refer to the online documentation that ships with Microsoft Site Server. Re-map your services to the new Membership Server Instance.

Correcting the SQL Server Name
  Change the server name that is stored in the Membership database. Using isql/w or Query Analyzer, execute the following script: Update DsoGrid Set vc_datasource = '<actual SQL server name>' Where vc_datasource = '<SQL server alias>' </li> From the MMC, expand the Personalization and Membership object, expand your server, and expand the target membership server instance.</li> Right-click the LDAP object and click Properties.</li> Click OK on the two error dialog boxes.</li> Click the Root Database tab, change the SQL Server name to reflect the actual server name, and then click OK.</li> Click Yes to the confirmation message.</li> Right-click the LDAP object and click Start.</li></ol>

<div class="moreinformation_section">

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

216415 HOW TO: Set Up SQL Server with Proxy Server

238648 Database Error when Creating a Membership Directory Using a SQL Server Alias

Keywords: kbprb kbpending KB239855

-

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

© Microsoft Corporation. All rights reserved.