STS: Error Message After You Change Password: ADO Error 80040E4D: Login Failed for User 'sa'

Article translations Article translations
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:
256986 Description of the Microsoft Windows Registry
Expand all | Collapse all

SYMPTOMS

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'

CAUSE

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.

WORKAROUND

To work around this issue, configure the Office 2000 Server Extensions to use the new database connection password. To do this, follow these steps:
  1. Start OSE Administrator (HTML). If an Enter Network Password dialog box appears, type your user name, password, and domain into the corresponding boxes, and then click OK.
  2. On the Microsoft Office Server Extensions Administrator home page, click Database Settings.
  3. On the Database Settings page, click Change Office Database.
  4. Type the SQL Server name and the Database name into the corresponding boxes.

    If you do not know this information, follow these steps to obtain it from the Microsoft Windows registry:WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

    1. Click Start, and then click Run.
    2. In the Open box, type regedit, and then click OK.
    3. In Registry Editor, expand the following subkey:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Web Server\OWS Metadata Stores\SQL MDStore1
    4. In the right pane, record the Data value that corresponds to the DNS entry. For example:
      Provider=sqloledb;Server=server name;Database=Default_Web_Site_Collab
    5. Quit Registry Editor.
    6. On the Office Server Extensions Database Settings page, type the server name that you recorded in step d in the SQL Server box.
    7. In the Database Name box, type the name of the database that you recorded in step d.
  5. In the User Id box, type sa.
  6. In the Password box, type the new database connection password, and then click Submit.
  7. Restart the server computer.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

For additional information about configuring SQL database passwords, click the article number below to view the article in the Microsoft Knowledge Base:
222828 Err Msg: Microsoft OLE DB Provider for ODBC Drivers Error '80040e4d'

Properties

Article ID: 292644 - Last Review: February 21, 2007 - Revision: 2.2
APPLIES TO
  • Microsoft SharePoint Team Services
  • Microsoft FrontPage 2002 Server Extensions
Keywords: 
kbbug kberrmsg kbnofix KB292644

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com