Login failed for user

[dpdoug]

I'm trying to connect to a local SQL Server DB the project I am developing. I'm using the following connection string:

Initial Catalog=reqsql;Data Source=DEV;Integrated Security=SSPI

where DEV is the name of my local pc. I've also tried using Data Source=(local) instead of Data Source=DEV.

But I get the following error:

Login failed for user 'DEV\ASPNET'. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'DEV\ASPNET'.

I can log in to the same db using an access adp and VB6 with no problem using integrated windows security - but not for ASP.NET.

Does anybody have a clue to what the problem is?

David

 

[Isadore]

dp: shot in the dark - cd it be related to map path?

 

[dpdoug]

Isadore,

I put this line in the Web.config file:

<identity impersonate="true" userName="myusername" password="mypassword"/>

and that did the trick!!

Thanks for the consideration though.

David

 

[AtomicChip]

dpdoug -

By changing the <identity> tag in the web.config, your whole application will run under that user instead of the asp.net worker account.

To avoid this, try connecting to your SQL server like this:

SqlConnection con = new SqlConnection("server=locahost;uid=userName;password=password;inital catalog=dbName;");

This is the connection method that I (and most other developers who have written articles about this) use as a standard.

-----------------------------------------------

http://www.liquidfuzion.com

"The night sky over the planet Krikkit is the least interesting sight in the entire universe."
-Hitch Hiker's Guide To The Galaxy

 

[dpdoug]

I tried that and it gave me the error:

SQL Server does not exist or access denied

 

[AtomicChip]

Use the machine name or IP address instead of localhost then.

-----------------------------------------------

http://www.liquidfuzion.com

"The night sky over the planet Krikkit is the least interesting sight in the entire universe."
-Hitch Hiker's Guide To The Galaxy