I'm moving an intranet app from one machine to another. Both are Win2000
Server, with SQL Server 2000. I'm trying to keep them the same in every
possible way. However, when I try to connect to the site through the
browser, I get the following:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'xxx'. Reason: Not associated with a trusted SQL
Server connection.
/includes/database_connection.inc, line 13
Obviously, I replaced the user name with 'xxx' in the above example.
I have remote sessions with both machines (the one that works and the one
that doesn't) and I am comparing every SQL Server setting, IIS setting,
etc., and cannot see the difference.
Here's the include file that is referenced above ( replaced the actual names
with xxxx's):
<%
Dim strDBConnection
strDBConnection = _
"Provider=SQLOLEDB;" & _
"Persist Security Info=False;" & _
"Data Source=xxxmachinenamexxx;" & _
"User ID=xxx;" & _
"Password=xxx;" & _
"Database=xxxx;"
Dim objConnection
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open strDBConnection
%>
-------------
I went to ASPFAQ.com and found
http://databases.aspfaq.com/database...look-like.html
but I guess I don't understand it enough to use the info and advice it
provides.