Categories
ASP.NET SQL SQL Server

Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection.

The cause of this problem is the SQL server has been configured to operate in “Windows Authentication Mode (Windows Authentication)” and doesn’t allow the use of SQL accounts. This was the default setting in my case, I got the error after installing a new instance of SQL Server 2005.

I was able to solve this problem by changing the Authentication Mode of the SQL server from “Windows Authentication Mode (Windows Authentication)” to “Mixed Mode (Windows Authentication and SQL Server Authentication)”.

Related posts:

  1. “HTTP Error 404 – File or Directory not found” error message when you request dynamic content with IIS 6.0 I ran across this problem with an ASP page and...
  2. App_GlobalResources maps to a directory outside this application, which is not supported. Problem I’ve created a very simple ASP.NET 2.0 application. I...
  3. How to disable anonymous authentication in IIS Express StackOverflow: IIS Express is automatically disabling anonymous authentication for my...
  4. SQL SERVER – 2005 – List all the database List all the database on SQL Servers. SQL SERVER 2005...