I created a simple ADO connection:

Dim Conn, ConnStr, strSQLEx

Set Conn = Server.CreateObject("ADODB.Connection")

ConnStr = "DSN=CTS;UID=sa;pwd=fugazi;"
Conn.ConnectionString = ConnStr
Conn.Open

I'm getting the following error....

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'FUGAZI-WIN2K\IUSR_FUGAZI-WIN2K'.
/lessons/CreateID.asp, line 24


Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)

Page:
POST 0 bytes to /lessons/CreateID.asp

POST Data:

Any ideals why it's trying to login to the SQL Server with the internet account.

thanks