Link to home
Start Free TrialLog in
Avatar of lijin1
lijin1

asked on

ASP can not open the connection of SQL Server

I use "...Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=cargo;UID=cargo;PWD=cargo;;" ..." in my ASP file,it work well in my PWS of WIN95.But when I run this ASP in IIS3.0 in NT,error occur,"Microsoft OLE DB Provider for ODBC Drivers error'80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: _ Reason: Not defined as a valid user of a trusted SQL Server connection"
What's the reason?Thank you very much!
ASKER CERTIFIED SOLUTION
Avatar of rajgn
rajgn

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lijin1
lijin1

ASKER

Thank you rajgn! but if the answer would have more detail is better.