Microsoft KB Archive/295414

= STS: Error 18452 While Extending a SharePoint Team Web Site =

Article ID: 295414

Article Last Modified on 3/29/2007

-

APPLIES TO


 * Microsoft SharePoint Team Services

-



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/windowsserver/sharepoint/v1/default.mspx

Keywords: kbbug kbpending KB295414

-

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

© Microsoft Corporation. All rights reserved.