General discussion

Locked

NT Authentication, IIS 5 & SQL 7

By mbeall ·
I have SQL Server 7 installed on Windows 2000 (MYSQLSERVER). I have setup Windows NT access to my SQL Server for my network logon (MYDOMAIN\MYLOGIN). I have created a corresponding user for a database on the server and given it access to the necessary tables, procs, etc. The server does allow both Windows NT Authentication and Standard SQL Authentication.

I have IIS 5 running under Windows 2000 (seperate machine). I have Integrated Windows Authentication enabled and Anonymous access DISABLED. I also have Basic authentication checked (is this necessary?) with default domain set (MYDOMAIN).

My ASP has a connection string of "PROVIDER=SQLOLEDB;DATA SOURCE=MYSQLSERVER;trusted connection=YES;Integrated Security=SSPI". I then run a simply query against one table. I get the error: "Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." If I leave off the "Integrated Security=SSPI" from my connection string I get this error: "Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'MYLOGIN'." Both occur if I turn off Basic Authentication, so that is not it.

Can someone tell me what we are doing wrong? Any help would be greatly appreciated.

Thanks.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

NT Authentication, IIS 5 & SQL 7

by mbeall In reply to NT Authentication, IIS 5 ...

Point value changed by question poster.

Collapse -

NT Authentication, IIS 5 & SQL 7

by mbeall In reply to NT Authentication, IIS 5 ...

Point value changed by question poster.

Collapse -

NT Authentication, IIS 5 & SQL 7

by Bedri C. Kurdoglu In reply to NT Authentication, IIS 5 ...

It seems to me you have experienced the authentication problems. I think the given link is more appripriate one for your problem. Please check this link out.

http://support.microsoft.com/support/kb/articles/Q247/9/31.ASP?LN=EN-US&SD=gn&FR=0

Collapse -

NT Authentication, IIS 5 & SQL 7

by mbeall In reply to NT Authentication, IIS 5 ...

Poster rated this answer

Collapse -

NT Authentication, IIS 5 & SQL 7

by rraheb In reply to NT Authentication, IIS 5 ...

I've been through the same problem with one exception, that the platform was Win NT Server 4.0 instead of Win2000.

You're experiencing an AUTHENTICATION problem which is due to the fact that the SQL server and the IIS server are on two different NT machines.

The solution which i reached was to use the Challenge/Response authentication method for the first page of the site (which does not have the call to the database) and then once the user is allowed access to this first page you can access the SQL server through the next pages which would be using anonymous authentication.

For more information, refer to the follwing websites:

http://www.15seconds.com

Check the IIS security section.

http://www.aspin.com

Hope this helps you out,

Rafik El-Raheb.

Collapse -

NT Authentication, IIS 5 & SQL 7

by mbeall In reply to NT Authentication, IIS 5 ...

Poster rated this answer

Collapse -

NT Authentication, IIS 5 & SQL 7

by mbeall In reply to NT Authentication, IIS 5 ...

This question was closed by the author

Back to Security Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums