Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 295414 - Last Review: March 29, 2007 - Revision: 1.1
STS: Error 18452 While Extending a SharePoint Team Web Site
This article was previously published under Q295414
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.
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.
To correct this problem, change the SQL Server
authentication method to use both SQL Server and Windows. To do this, follow
these steps:
- Start the SQL Server Enterprise Manager.
- Right-click the name of the server running SharePoint Team
Services, and then click Properties on the shortcut menu.
- Click the Security tab.
- In the Authentication section, click SQL Server and Windows.
- Under the Startup service, select System.
- Click OK.
- If you are prompted to stop and restart the SQL server,
click Yes.
- Extend the SharePoint team Web site by using the 'sa'
account.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
For more information about SharePoint Team Services, please
see the following Microsoft Web site:
APPLIES TO
- Microsoft SharePoint Team Services
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate