Not associated with a trusted SQL Server connection

[jbottero]

I've got SQL Server 2000 running on a Win2k machine.

I'd like to be using it to develop .asp web apps on via MS InterDev 6.

sa has permissions on the db in question (Northwind), and a simple attemt to connect results in this:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
/Project1/ASP Page1.asp, line 10

From this code:

<%
dim conn
dim ProvStr
dim rs
' first create a recordset object
set conn = Server.CreateObject(&quot;adodb.connection&quot
conn.Provider = &quot;sqloledb&quot;
' next set up a connection string
ProvStr = &quot;Server=ORB;Database=Northwind;UID=sa;PWD=xxx;&quot;
conn.Open ProvStr
set rs = Server.CreateObject(&quot;adodb.recordset&quot
%>

What am I doing wrong?

 

[foxdev]

Try adding this to ProvStr:

[tt]Trusted_Connection=No[/tt]
Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org