«

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?

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.

"middletree" <> wrote in message
news:...
> 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?
>
>
>

On Mon, 14 Feb 2005 22:49:30 -0600, "middletree"
<> wrote:

>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