No Trusted SQL Server Connection

[Jonathan Wood]

I'm a programmer but not a database administrator and really don't want to
be either.

After a fair amount of reading and many problems related to SQL and related
stuff, I finally figured out how to create a database in Visual Studio and
enter some data into it. Now, I'm trying to make a Web site application
populate an HTML table with that data. (Running locally.)

Now, when I run the code, I get the error "Login failed for user ''. The
user is not associated with a trusted SQL Server connection."

It appears to be related to my SQL connection string, which is currently
"Data Source=localhost\\SQLEXPRESS;Initial Catalog=DataTest;"

It seems like that should work. Can anyone help me figure out the problem?

Thanks.

 

[KJ]

Try adding Trusted_Connection=Yes to the connection string. What
happens?

 

[Guest]

Dear Jonathan,

You may try to use in web.config identity=impersonate