Entreprise Manager error message: "[Microsoft][ODBC SQL ServerDriver][SQL Server]Login failed for user '#####'. The user is not associatedwith a trusted SQL Server connection.(28000,18452)"

permalink · #1 (**permalink**) 03-01-2008, 03:46 PM

Can anyone give a quick description of the meaning of this message and
what needs to be done to get a connection.

I'm running DBArtisan with SQLServer 2000 client SP4 installed.

I also get the same message with MS Enterprise Manager so this is
coming out of the actual ODBC connection attempt.

Thanks in advance!

permalink · #2 (**permalink**) 03-01-2008, 03:46 PM

In the future, please do not put part of your message in the subject line.
Makes it harder to read.

In any case, you're trying to do integrated login and don't have that login
set up in the DB.

You need to add that login, or change to a SQL Login.

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

"byrocat" <strikemaster2000@yahoo.ca> wrote in message
news:a1fc2ee7-94f6-40e2-9da9-6358130e11f4@e67g2000hsc.googlegroups.com...
> Can anyone give a quick description of the meaning of this message and
> what needs to be done to get a connection.
>
> I'm running DBArtisan with SQLServer 2000 client SP4 installed.
>
> I also get the same message with MS Enterprise Manager so this is
> coming out of the actual ODBC connection attempt.
>
> Thanks in advance!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode