connection string dring me nuts!

[middletree]

First, here's my code(replaced some info with "foo":

Dim strDBConnection
strDBConnection = _
"Provider=SQLOLEDB;" & _
"Persist Security Info=False;" & _
"Data Source=w2003\ticketlog;" & _
"User ID=foo;" & _
"Password=foo;" & _
"Database=foo;"

Dim objConnection
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open strDBConnection
=======================================================================

I hve code very similar to this which works perfectly, but when running this
on this new machine I built, it doesn't work. I get the following error:

Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'foo'. Reason: Not associated with a trusted SQL
Server connection.
/includes/database_connection.inc, line 13

=====================================

Looking at the error description, it seems as though I need to add that
user. I have, of course, added that user to the machine, and also to the SQL
Server database. Not sure what to do with this.

I should add that ASP itself seems to be working. I did a response.write of
the current time to verify this.

Anyone got an idea where to look for answers?

 

[Sylvain Lafontaine]

You must set the SQL-Server authentification mode to "SQL Server and
Windows", not to "Windows only".

It is also possible that the password is wrong.

S. L.

 

[Jeff Cochran]

First, here's my code(replaced some info with "foo":

Dim strDBConnection
strDBConnection = _
"Provider=SQLOLEDB;" & _
"Persist Security Info=False;" & _
"Data Source=w2003\ticketlog;" & _
"User ID=foo;" & _
"Password=foo;" & _
"Database=foo;"

Dim objConnection
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open strDBConnection
=======================================================================

I hve code very similar to this which works perfectly, but when running this
on this new machine I built, it doesn't work. I get the following error:

Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'foo'. Reason: Not associated with a trusted SQL
Server connection.
/includes/database_connection.inc, line 13

=====================================

Looking at the error description, it seems as though I need to add that
user. I have, of course, added that user to the machine, and also to the SQL
Server database. Not sure what to do with this.

I should add that ASP itself seems to be working. I did a response.write of
the current time to verify this.

Anyone got an idea where to look for answers?

Start with the FAQ:

Why do I get database-related 80004005 errors?
http://www.aspfaq.com/show.asp?id=2009

Note the references to these:

http://www.aspfaq.com/show.asp?id=2138
http://www.aspfaq.com/show.asp?id=2126
http://support.microsoft.com/default.aspx/kb/306586

Jeff