Hi
"Not associated with a trusted SQL Server connection" means that your
credentials passed do not match those with rights in the databases.
You need an NT Domain to use trusted security (except on the local machine).
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike.DeleteThis@epprecht.net
MVP Program: <a rel="nofollow" style='text-decoration: none;' href="http://www.microsoft.com/mvp" target="_blank">http://www.microsoft.com/mvp</a>
Blog: <a rel="nofollow" style='text-decoration: none;' href="http://www.msmvps.com/epprecht/" target="_blank">http://www.msmvps.com/epprecht/</a>
"rick" wrote in message
> Needs some help, I recently recieved an evaluation copy of SQL Server2000
> and I have installed it on a WindowsXPsp2 machine. I have updated to SQL
> Server to
> service pack3 and installed .net as well. I am still having connection
> problems. I am
> trying to setup an ODBC connection from another XP and win2000 machines.
>
> Connection failed:
> SQLState: '28000'
> SQL Server Error 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'rick'. Reason: Not associated with a trusted SQL Server connection.
>
> I have already checked for Windows Authentication being enabled on the
> server.
> Of course the ODBC connection works locally.
>
> 'preciate any help
> thanks
>
>
FAQ
Search
Profile
Private Messages
Log in
