|
 |
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
>
|
|
 |