connection string dring me nuts!

[middletree]

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

Dim strDBConnection
strDBConnection = _
"Provider=SQLOL EDB;" & _
"Persist Security Info=False;" & _
"Data Source=w2003\ti cketlog;" & _
"User ID=foo;" & _
"Password=f oo;" & _
"Database=f oo;"

Dim objConnection
Set objConnection = Server.CreateOb ject("ADODB.Con nection")
objConnection.O pen 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_connec tion.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 authentificatio n mode to "SQL Server and
Windows", not to "Windows only".

It is also possible that the password is wrong.

S. L.

"middletree " <mi********@HTO mail.com> wrote in message
news:uQ******** ******@tk2msftn gp13.phx.gbl...

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

Dim strDBConnection
strDBConnection = _
"Provider=SQLOL EDB;" & _
"Persist Security Info=False;" & _
"Data Source=w2003\ti cketlog;" & _
"User ID=foo;" & _
"Password=f oo;" & _
"Database=f oo;"

Dim objConnection
Set objConnection = Server.CreateOb ject("ADODB.Con nection")
objConnection.O pen 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_connec tion.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?

[Jeff Cochran]

On Mon, 14 Feb 2005 22:49:30 -0600, "middletree "
<mi********@HTO mail.com> wrote:

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

Dim strDBConnection
strDBConnectio n = _
"Provider=SQLOL EDB;" & _
"Persist Security Info=False;" & _
"Data Source=w2003\ti cketlog;" & _
"User ID=foo;" & _
"Password=f oo;" & _
"Database=f oo;"

Dim objConnection
Set objConnection = Server.CreateOb ject("ADODB.Con nection")
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_connec tion.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