ASP can not open the connection of SQL Server
Posted on 1998-11-13
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!