authentication to SQL Server 2000 from ASP

please let me know if I need to post this on another SQL forum, and I'll be glad to do so.

I'm trying to set up the equivalent of Integrated Security=SSPI for SQL Server 2000 on IIS5.0. It's my understanding the SSPI string above is for Win NT, but not for Active Dir 2000 domains.

I'm using ASP 2.0 (NOT .Net), so please apprise me to what info I'd need in the connection string.

Currently it reads like this:

Set cn = CreateObject("ADODB.Connection")
cn.CursorLocation = 3 'Client side cursor
cn.Open "Provider=SQLOLEDB;Data Source=191.181.92.73;Integrated Security=SSPI"

Any feedback is welcomed.

Thanks!

Are the WebServer and the SQL Server on the same machine ? Did you enable Windows Authentication for the Website ?

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||Any updates on that, or is the problem solved ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de