Right-click on the server in Enterprise Manager and select Edit SQL
Server Registration, then select Windows Authentication and it will let
you connect via EM.

From QA you can change the authentication mode by changing the registry,
like this:

For default instance:

xp_regwrite
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\MSSQLServer','Login
Mode','REG_DWORD', 2

For <XX> instance:

xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft SQL
Server\<XX>\MSSQLServer','LoginMode','REG_DWORD', 2


A value of 2 is for Windows and SQL, a value of 1 is only for Windows
Authentication. You must restart SQL Server to put this change into
effect.


-----Original Message-----
From: Femi George [ MTN - UBA ]
[mailto:mssqldba-ezmlmshield-x99688481.[Email address protected]
Sent: Martes, 30 de Noviembre de 2004 09:32 a.m.
To: LazyDBA Discussion
Subject: Changing authentication mode via query analyzer


Hello,
How can i change the authentication mode via Query Analyzer?.
right now it is set to windows authentication and i want it to be sql
server and windows authentication .
i use sql server 2000 and i could only connect via my windows login. i
am an administrator on my PC.
When i try and expland my server in enterprise manager, i get the
following error;

Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.

Thanks
Femi George
Enterprise Data Warehousing [MTN-AGIP]
[Email address protected]
08032090305



NOTE: This e-mail message is subject to the MTN Nigeria disclaimer see
http://www.mtnonline.com/contact/disclaimer.asp


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




MS Sql Server LazyDBA home page