Login as sa

How do I login to Query Analyser or EM as system administrator (sa) ?
Alan wrote:
> How do I login to Query Analyser or EM as system administrator (sa) ?
Enter "sa" as the user name
Enter the sa password
Press OK.
If your server is not set up for Mixed-mode security, you may need to
enable that option to use the "sa" login.
If you've lost the "sa" password, you can log into the server using any
other administrator account and change the password for the "sa" user.
What trouble are you running into?
David Gugick
Imceda Software
www.imceda.com
|||I installed the SQL Server 2000 as Windows Authentication mode, just wonder
if there is a sa login.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Cdsx1uGFHA.4084@.TK2MSFTNGP14.phx.gbl...
> Alan wrote:
> Enter "sa" as the user name
> Enter the sa password
> Press OK.
> If your server is not set up for Mixed-mode security, you may need to
> enable that option to use the "sa" login.
> If you've lost the "sa" password, you can log into the server using any
> other administrator account and change the password for the "sa" user.
> What trouble are you running into?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||It exists but will give you an error that the connection is not trusted and
will refuse it if tried. However, give the account A VERY STRONG PASSWORD
as it is very easy to switch SQL Server's Authentication mode.
Sincerely,
Anthony Thomas

"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eRk4SKgHFHA.3624@.tk2msftngp13.phx.gbl...
I installed the SQL Server 2000 as Windows Authentication mode, just wonder
if there is a sa login.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Cdsx1uGFHA.4084@.TK2MSFTNGP14.phx.gbl...
> Alan wrote:
> Enter "sa" as the user name
> Enter the sa password
> Press OK.
> If your server is not set up for Mixed-mode security, you may need to
> enable that option to use the "sa" login.
> If you've lost the "sa" password, you can log into the server using any
> other administrator account and change the password for the "sa" user.
> What trouble are you running into?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>