Can we disable SA Account in SQL Server.

Hi,
I am running SQL Server 2000 SP3. For Security purpose i want to
disable SA Account.
But i am not sure that, we can disable SA account.
Please give me reply.
Thanks & Regards,
Sajid C.Hi
You cannot disable SA account. You can remove BUILTIN/Administrators login
to ensure that users of Windows admin group do not get autamically access
to SQL Server
<csajid@.gmail.com> wrote in message
news:1155022050.211678.192190@.b28g2000cwb.googlegroups.com...
> Hi,
> I am running SQL Server 2000 SP3. For Security purpose i want to
> disable SA Account.
> But i am not sure that, we can disable SA account.
> Please give me reply.
> Thanks & Regards,
> Sajid C.
>|||Uri Dimant wrote:
> Hi
> You cannot disable SA account. You can remove BUILTIN/Administrators login
> to ensure that users of Windows admin group do not get autamically access
> to SQL Server
>
> <csajid@.gmail.com> wrote in message
> news:1155022050.211678.192190@.b28g2000cwb.googlegroups.com...
> > Hi,
> >
> > I am running SQL Server 2000 SP3. For Security purpose i want to
> > disable SA Account.
> >
> > But i am not sure that, we can disable SA account.
> >
> > Please give me reply.
> >
> > Thanks & Regards,
> > Sajid C.
> >
> >
If you are usin SQL Server 2005 you can disable it by
alter login sa disable
even you can rename it
alter login sa with name = <new name for sa>
Regards
Amish Shah
http://shahamishm.tripod.com|||amish
>> I am running SQL Server 2000 SP3. For Security purpose i want to
> disable SA Account.
Yep, but he is using SQL Server 2000
"amish" <shahamishm@.gmail.com> wrote in message
news:1155030451.500469.238540@.m73g2000cwd.googlegroups.com...
> Uri Dimant wrote:
>> Hi
>> You cannot disable SA account. You can remove BUILTIN/Administrators
>> login
>> to ensure that users of Windows admin group do not get autamically
>> access
>> to SQL Server
>>
>> <csajid@.gmail.com> wrote in message
>> news:1155022050.211678.192190@.b28g2000cwb.googlegroups.com...
>> > Hi,
>> >
>> > I am running SQL Server 2000 SP3. For Security purpose i want to
>> > disable SA Account.
>> >
>> > But i am not sure that, we can disable SA account.
>> >
>> > Please give me reply.
>> >
>> > Thanks & Regards,
>> > Sajid C.
>> >
>> >
> If you are usin SQL Server 2005 you can disable it by
> alter login sa disable
> even you can rename it
> alter login sa with name = <new name for sa>
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>|||With SQL 2000, Give the sa account a complex and strong password, lock the
password in a safe, and don't allow anyone to use the sa account.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<csajid@.gmail.com> wrote in message
news:1155022050.211678.192190@.b28g2000cwb.googlegroups.com...
> Hi,
> I am running SQL Server 2000 SP3. For Security purpose i want to
> disable SA Account.
> But i am not sure that, we can disable SA account.
> Please give me reply.
> Thanks & Regards,
> Sajid C.
>|||Hi all,
Thanks for your Reply.
Thanks & Regards,
Sajid C.
Arnie Rowland wrote:
> With SQL 2000, Give the sa account a complex and strong password, lock the
> password in a safe, and don't allow anyone to use the sa account.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> <csajid@.gmail.com> wrote in message
> news:1155022050.211678.192190@.b28g2000cwb.googlegroups.com...
> > Hi,
> >
> > I am running SQL Server 2000 SP3. For Security purpose i want to
> > disable SA Account.
> >
> > But i am not sure that, we can disable SA account.
> >
> > Please give me reply.
> >
> > Thanks & Regards,
> > Sajid C.
> >