Connecting to SQL server via VBS and ASP

[bitwise]

I have written a VB app that connects to an SQL Server using WinNT authentication with a connection string that looks like this:

DBCONN.ConnectionString = "Provider=SQLOLEDB.1;Data Source=MyServer;Integrated Security=SSPI;Initial Catalog=TestDB;"

Works fine. It uses my windows login and I can get data from the database. Anyway, when I try to connect with the same connection string in an ASP page I get the error:

"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'"

Does ASP not know how to grab the windows login to authenticate me or is ASP just different in another way somehow?

bitwise

 

[link9]

Here is a FAQ from the ASP forum on how to get the NT logon info from the browser:

faq333-144


Paul Prewett