M
Middletree
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
%>
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
%>