STS: Error 18452 While Extending a SharePoint Team Web Site (295414)


The information in this article applies to:

  • SharePoint Team Services from Microsoft
This article was previously published under Q295414

SYMPTOMS

When you attempt to extend a web site based on SharePoint Team Services from Microsoft,the following error message appears:
Logon failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection (Error code: 18452).
The SharePoint team Web site is not extended, even though you are using the Administrator's account and the correct password.

CAUSE

This error message can occur if the SQL Server is using Windows only authentication. SharePoint Team Services requires SQL Server authentication and uses a system account to log on to the SQL Server.

RESOLUTION

To correct this problem, change the SQL Server authentication method to use both SQL Server and Windows. To do this, follow these steps:
  1. Start the SQL Server Enterprise Manager.
  2. Right-click the name of the server running SharePoint Team Services, and then click Properties on the shortcut menu.
  3. Click the Security tab.
  4. In the Authentication section, click SQL Server and Windows.
  5. Under the Startup service, select System.
  6. Click OK.
  7. If you are prompted to stop and restart the SQL server, click Yes.
  8. Extend the SharePoint team Web site by using the 'sa' account.

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 more information about SharePoint Team Services, please see the following Microsoft Web site:

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sharepnt/Default.asp

Modification Type:MajorLast Reviewed:4/19/2002
Keywords:kbbug KB295414
©2002 Microsoft Corporation. All rights reserved.