Windoes 7 and SqlExpress 2005 Trust error

Dale Hermsen

17y3.5k

I'm using Windows 7 64 bit and SQL Express 2005. I've created a database in a C# app and get the following error when attempting to access the database from the CreateUserWizard. I've got the ASPNET security set up properly as I can make changes to the database through the configuration manager. I've been all over the WEB and tried numerous solutions. None worked. Is this a W7 issue? I see where others are having the same problem, but nothing in the way of a "This will work" solution. Way too many speculations on try this or try that. Here's the error: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection. Sql exception 0x80131904.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Lalit M17y ago
Accepted answer
Try to Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".
Run following script in SQL Analyzer to change the authentication

LOGIN sa ENABLE GO ALTER LOGIN sa WITH PASSWORD = '' GO

OR

In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties. On the General page, you may have to create and confirm a password for the sa login. On the Status page, in the Login section, click Enabled, and then click OK.
Dale Hermsen17y ago
Thanks. I did finally get it to work by moving the database out of App Data into the SQL default Data directory, created a new connectionstring for a gridview and then used it for everything. The connection strings appear identical to me but one works and one doesn't. No clue as to why. What a pain! Thanks again, it's good to have another option.