Asp.Net News
Free Tech Magazines
Asp.Net Web Hosting
Suggest Us
Link to Us
Feeds Subscription
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


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

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.
Post Your Reply If you still have problem, post it again under this reply for better response.

Sponsored by
Website Magazine
When Good HTML Goes Bad: How You Can Protect Your Web Applications
Introduction to Software Development