When you choose the menu option 'File', then 'connect' in QA, the dialog
box gives you the choice.

> -----Original Message-----
> From: Femi George [ MTN - UBA ]
> [mailto:mssqldba-ezmlmshield-x99688481.[Email address protected]
> Sent: 30 November 2004 15:32
> 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
>
>
>

MS Sql Server LazyDBA home page