Article ID: 292644 - View products that this article applies to.
This article was previously published under Q292644
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/256986/EN-US/ )Description of the Microsoft Windows Registry
After you change the database connection password for your SharePoint team Web site, you cannot use your Microsoft Office 2000 Server Extensions-based Web sites for discussions or collaborations.
When you view the Application Log from within Event Viewer, you see the following Office Web Server error message:
ADO Error 80040E4D: Login failed for user 'sa'
This behavior occurs because the Office 2000 Server Extensions-based virtual servers can no longer access the Microsoft SQL Server 2000 Desktop Engine.
NOTE: The previous version of Microsoft SQL Server 2000 Desktop Engine is named Microsoft Data Engine (MSDE).
When you use the Owsadm.exe utility to change the database connection password, the Office 2000 Server Extensions installation is not configured with the new password.
To work around this issue, configure the Office 2000 Server Extensions to use the new database connection password. To do this, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
For additional information about configuring SQL database passwords, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/222828/EN-US/ )Err Msg: Microsoft OLE DB Provider for ODBC Drivers Error '80040e4d'
Contact us for more help
Connect with Answer Desk for expert help.