Attempting To Connect To SQLServer 2k

This is the code I'm using on the web page located on the server:





Dim strConn as String


Dim conn as SQLConnection


strConn="server=localhost;Trusted_Connection=Yes;database=CIS"





conn=New SQLConnection(strConn)


conn.Open()





and the error messgae I receive is: Login failed for user 'MSP00427ASPNET'.





msp00427 is the name of the server


= = = = = = = = =





I have an MSAccess application that accesses the same database as follows with no trouble.





glblConnectString = "Driver=SQL Server;Server=msp00427;Database=CIS;Trusted_Connection=Yes"





Set cnn = New ADODB.Connection


cnn.Open glblConnectString


Set cmd = New ADODB.Command


cmd.ActiveConnection = cnn


cmd.CommandText = "Scorecard_Delete_ATLASDataDump"


cmd.CommandType = adCmdStoredProc


cmd.Execute





This is run on my PC and I have sa capabilities on the server.





The .NET framework is installed.





Any ideas why the data access on the web page fails?