Home > Archive > microsoft.public.cert.mcdba > January 2004 > Strange account





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Strange account
=?Utf-8?B?THVpcyBSYW1vcw==?=

2004-01-13, 12:24 pm

I was removing old accounts from a SQL server, but i´ve noticed an account named 'sa' which has System Administrator rigths (me too) but i can´t delete it.

An error appears: Error 15405: Cannot use the reserved user or role named 'sa'

I can´t change this account role from the Server Roles tab.
Maybe it´s a default account, i really don´t know. If not, how can i delete it?

Luis Ramos

Ray Higdon

2004-01-13, 12:24 pm

You can never delete the SA account, it is a built-in account, if you change
to windows authentication it is not usable but you still can not delete it.
With SP3 they ask you to set a password for it even if you are windows
authentication only

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
--
"Luis Ramos" <anonymous@discussions.microsoft.com> wrote in message
news:2800883B-4513-4262-AAC2-0C9B84244673@microsoft.com...
> I was removing old accounts from a SQL server, but i´ve noticed an account

named 'sa' which has System Administrator rigths (me too) but i can´t delete
it.
>
> An error appears: Error 15405: Cannot use the reserved user or role named

'sa'
>
> I can´t change this account role from the Server Roles tab.
> Maybe it´s a default account, i really don´t know. If not, how can i

delete it?
>
> Luis Ramos
>



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net