AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
Questions & Answers
Tips & Tricks
 server error
Posted by deepa on  12/11/2008 11:55:46 AM Category: Asp.Net 2.0
Add to my favorites
Email to friend
Its showing Error

Server error in /onlineshopping application


Login failed for user 'sa',The user is not associated with a trusted sql server connection



Thanks,
Deepa

Post Your Reply Post New Question

 Viewer's Reply
Server Problem
Answered By pasumarthy rajesh on 12/12/2008 11:33:22 PM
This problem normally we get because sql server has not configured with trusted authentication.While installing sqlserver mixedmode should be choosen in authentication section.

Following steps may help you,try once...
1.connect sqlserver with windows authentication
2.Goto sa properties, and change the password,click on OK.
3.Now try with sqlserver authentication with respected credentials

By
Rajesh
 
Login failed for SQL server
Answered By Hemlakshmi Raaj on 12/30/2008 1:48:18 AM
This error occurs because by default SQL 2000 does not support SQL Server authentication and supports only Windows authentication. To overcome this limitation:

Enter SQL Enterprise Manager.

Find your server name in the tree on the left.

Right mouse click on the server name and select properties.

Click the Security folder. You should now see the screen below with “Windows Only” set as the default authentication.

Try this link for detailed explanation.

http://www.banmanpro.com/support/sql2k.asp
 
Post Your Reply If you still have problem, post it again under this reply for better response.

 
Sponsored by
Everything You Know About CSS Is Wrong! - Free 37 Page Preview!
Programmers Heaven C# School Book - Free 338 Page eBook
Building a Web Application Security Program