Login failed for user 'IUSR_DEVSQL01'.

[byrne1]

I'm new to IIS and ASP and can't seem to get by this error. I've created an ASP page that takes a user ID and password and then validates it against an SQL database. But when I try to submit the information I get the following error:

Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'IUSR_DEVSQL01'.

I've set up permissions for DEVSQL01\IUSR_DEVSQL01 in both my WinNT and

http://wwwroot

directories. Can anyone help me get around this problem? Thanking you in advance for your help.

 

[FengShui1998]

byrne1,

Did you set up NT authentication in the SQL database? Also,
are you sure you did not use "0" instead of zero(0) in the user name?


fengshui1998

 

[byrne1]

In the SQL database I've tried both "SQL Server and Windows NT" as well as "Windows NT Only" authentication and both give me the same error message. I'm positive that I did not use the letter "O" instead of a zero(0) in the user name.

 

[FengShui1998]

byrne1,

Can you show some code on how you are connecting to the datsabase w/o showing your username ans password?

fengshui1998

 

[byrne1]

conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=LoanIO;Data Source=DEVSQL01"

conn.Open

I have the ASP set up to use the IUSR_DEVSQL01 user ID (I set this up in the IIS console).

 

[FengShui1998]

byrne1,

I believe IUSR_DEVSQL01 is the username from your web server, not your SQL server. Since your ASP page is trying to access the SQL server, use the asp/web server name. Do not use your NT account because the web server does not pass this along.


Good luck!
fengshui1998