Tuesday, March 27, 2012

Error 18452

I have a co-worker who installed SQL Server 2000 on her
machine. For some reason, when she tries to connect to
Query Analyzer using SQL Server authentication she gets
error 18452 (Login failed for user 'sa'. Reason: Not
associated with a trusted SQL Server connection.).
I don't know exactly how she installed SQL Server 2000,
but the only way for her to connect right now is by
windows authentication, which is what's recommended.
Anyways, I would like to know how can one resolve this
issue.
Thanks in advance,
Bdee
To change the Authentication mode for the server via Enterprise Manager,
Right click on the Server and choose Properties. Goto the security Tab in
the dialog and select the SQL Server and Windows radio button in the
Authentication section and click ok. You will need to restart the SQL
service for this to take effect
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"bd" <anonymous@.discussions.microsoft.com> wrote in message
news:d6d301c439f9$0a6de270$a301280a@.phx.gbl...
> I have a co-worker who installed SQL Server 2000 on her
> machine. For some reason, when she tries to connect to
> Query Analyzer using SQL Server authentication she gets
> error 18452 (Login failed for user 'sa'. Reason: Not
> associated with a trusted SQL Server connection.).
> I don't know exactly how she installed SQL Server 2000,
> but the only way for her to connect right now is by
> windows authentication, which is what's recommended.
> Anyways, I would like to know how can one resolve this
> issue.
> Thanks in advance,
> Bdee
sql

No comments:

Post a Comment