I try to connect to an SQL server (7.0) database from an IIS application that I am developing using VBSCRIPT (ASP). The database server and the web server reside on different machines. I use the following code:
set CONN = server.CreateObject("adodb.connection")CONN.ConnectionString = "provider=SQLOLEDB;server=MYSRV;uid=MYUSR;pwd=MYPWD;database=MYDB"
I get the following error:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'MYUSR'. Reason: Not associated with a trusted SQL Server connection.
What is a trusted SQL Server connection? How do I create one?