BorlandTalk.com

Indrahig · Guest

I try to connect using ADO to SQL server 2000 through my application an
I get the following message:
"Login failed for user <user_Name>. User not associated with trusted
connection"

I use Windows XP Profesional and local server database (SQL server 2000).
Any help will be appreciated..

thanks,
Indra Gunawan

--- posted by geoForum on http://delphi.newswhat.com

Jeremy Collins · Guest

Indrahig wrote:

Euan Garden · Guest

Close but not really correct, the below is a simplfiied version.

If you specify SSPI in a connection string SQL Server will assume this is a
Windows authentication based session, as such you should not pass any userid
or password info on the connection string as Windows will pass the
credentials for you.

The security mode is called Windows Authentication (NT auth in SQL 7) and it
is ALWAYS on for SQL Server and hence the default.

If you wish to use SQL Authenication, this means passing a userid and
password in the connection string and not specifying SSPI, this mode needs
to be switched on either in setup or in the properties of the server,
because Windows Mode is always on, this second option is referred to as
mixed authentication because it supports both.

To get back to the original posters problem, its likely that you are passing
a User Id and Password in the connection string but are working in Windows
Auth only, you have 2 choices, switch the server to mixed mode or don't pass
the credentials and it should use your windows credentials.

-Euan

"Jeremy Collins" <jd.collins (AT) ntlworld-not (DOT) com> wrote