Fail to connect DB in SQL Query Analyser with sa

When you registered in EM, In Properties tab,
change the Sql Server registration to "SQl Server and
Windows" from "Windows only" .
Hope this help...if not please let me know by reply.

>--Original Message--
>When I use the "connect" function in SQL Query Analyser
with "sa" account. I got error message " Not associated
with a trusted SQL Server connection". I don't know what
does it mean? pls help
>
It means that when you installed MSDE you did not specify mixed mode security. By default MSDE is installed with (only) Integrated Security. Check the setup doc for instructions about how to change the security settings.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Grey" <ericyum@.i-cable.com> wrote in message news:Om6%23Od4GEHA.4008@.TK2MSFTNGP10.phx.gbl...
When I use the "connect" function in SQL Query Analyser with "sa" account. I got error message " Not associated with a trusted SQL Server connection". I don't know what does it mean? pls help
|||I install cannot change. the error messge of my previous mail is the same.
pls help
"Rachan Terrell" <anonymous@.discussions.microsoft.com> ?
news:18f5901c41bf6$8316f0c0$a501280a@.phx.gbl ?...
> When you registered in EM, In Properties tab,
> change the Sql Server registration to "SQl Server and
> Windows" from "Windows only" .
> Hope this help...if not please let me know by reply.
>
> with "sa" account. I got error message " Not associated
> with a trusted SQL Server connection". I don't know what
> does it mean? pls help