Wrox Home  
Search P2P Archive for: Go

  Return to Index  

activex_data_objects thread: Using ADO Connection Object


Message #1 by "Mary S. Martin" <msmartin@g...> on Tue, 16 Apr 2002 22:20:12
Hello all:
I'm trying to connect to a SQL 2000 Server and am receiving the following 
error message:

Login failed for user 'email'.  Reason: Not associated with a trusted SQL 
Server Connection.

What does this mean and how do I fix it.  The database I'm trying to 
connect to has a user set up called email, is there something in the 
permissions I forgot to set?

Thank you,
Mary S. Martin
Golden Starr Enterprises
Message #2 by "Tomm Matthis" <matthis@b...> on Wed, 17 Apr 2002 07:32:40 -0400
It sounds as if the SQL server is using Windows logins only to SQL server and
not SQL server logins only. You can change this model from the Enterprise
Manager.

-- Tomm

> -----Original Message-----
> From: Mary S. Martin [mailto:msmartin@g...]
> Sent: Tuesday, April 16, 2002 10:20 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] Using ADO Connection Object
>
>
> Hello all:
> I'm trying to connect to a SQL 2000 Server and am receiving the following
> error message:
>
> Login failed for user 'email'.  Reason: Not associated with a trusted SQL
> Server Connection.
>
> What does this mean and how do I fix it.  The database I'm trying to
> connect to has a user set up called email, is there something in the
> permissions I forgot to set?
>
> Thank you,
> Mary S. Martin
> Golden Starr Enterprises
>


  Return to Index