Stephan, could your SQL Server be configured for Windows authentication only?
You or your db admin had an option on installing SQL Server to specify that connections to it would be authenticated by a Windows account, a SQL Server account (like the one you're using) or mixed (either of those two). If it's set to Windows authentication only, then it would be trying to let your user account connect to the db, for which you appear not to be authorized (maybe a file permissions problem?) HTH -----Original Message----- From: Stephan [mailto:steph333@;swbell.net] Sent: Wednesday, October 16, 2002 5:45 PM To: ActiveServerPages Subject: Connection Problem Why is this application trying connect to IUSR_STEPHAN account for authenication when I am passing the connection string? When I run query analyzer I am able to connect to the database. The Password has been removed for obvious purposes. <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <% strConn = "Driver={SQL Server}; Server=stephan\local; Database=Offender; UID =Offender_User; PWD=Password goes hear not part of the error;" Set conPubs = Server.CreateObject("ADODB.Connection") conPubs.ConnectionString = strConn conPubs.Mode = adModeReadWrite conPubs.CursorLocation = adUseClient conPubs.IsolationLevel = adXactBrowse conPubs.Open response.write "connected" conPubs.close %> </body> </html> This the Error I get: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'STEPHAN\IUSR_STEPHAN'. /SexOffender/connection2.asp, line 17 Thanks, Stephan --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
