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:
[vbcol=seagreen]
> 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...
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
> 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:
>
> 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:[vbcol=seagreen]
> 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...
Showing posts with label purpose. Show all posts
Showing posts with label purpose. Show all posts
Tuesday, March 27, 2012
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.
> >
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.
> >
can we delete NT AUTHORITY\SYSTEM in sql server 2005?
Hi Folks,
In our sql server 2005 cluster server, we have a loginuser called
NT AUTHORITY\SYSTEM with sysadmin server role.
What is the purpose of that account?
Can we delete that login?
If we delete that will there be any problems?
We are using separate domain accounts for all sql services.
Please help.
Thank you
--KumarKumar,
Visit following link:
http://support.microsoft.com/kb/263712
NT AUTHORITY\SYSTEM restricts NT ADMIN and help to execute FullText as
FullText need builtin\administrators or NT AUTHORITY\SYSTEM.
Hope this will help.
"Kumar" wrote:
> Hi Folks,
> In our sql server 2005 cluster server, we have a loginuser called
> NT AUTHORITY\SYSTEM with sysadmin server role.
> What is the purpose of that account?
> Can we delete that login?
> If we delete that will there be any problems?
> We are using separate domain accounts for all sql services.
> Please help.
> Thank you
> --Kumarsql
In our sql server 2005 cluster server, we have a loginuser called
NT AUTHORITY\SYSTEM with sysadmin server role.
What is the purpose of that account?
Can we delete that login?
If we delete that will there be any problems?
We are using separate domain accounts for all sql services.
Please help.
Thank you
--KumarKumar,
Visit following link:
http://support.microsoft.com/kb/263712
NT AUTHORITY\SYSTEM restricts NT ADMIN and help to execute FullText as
FullText need builtin\administrators or NT AUTHORITY\SYSTEM.
Hope this will help.
"Kumar" wrote:
> Hi Folks,
> In our sql server 2005 cluster server, we have a loginuser called
> NT AUTHORITY\SYSTEM with sysadmin server role.
> What is the purpose of that account?
> Can we delete that login?
> If we delete that will there be any problems?
> We are using separate domain accounts for all sql services.
> Please help.
> Thank you
> --Kumarsql
Sunday, February 12, 2012
Can not start server after setting open objects to 2147483647
SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
TammyTry starting the server using the -f option, then change this value back to 0.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I can
> not start the server any more, nor can I set open objects to a smaller value.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:
> Try starting the server using the -f option, then change this value back to 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> > SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> >
> > I set open objects to 2147483647 for research purpose. After I did it, I can
> > not start the server any more, nor can I set open objects to a smaller value.
> > The error message I got was:
> > [Shared Memory]SQL Server does not exist or access denied.
> > [Shared Memory]ConnectionOpen (Connect()).
> >
> > What should I do to be able to start the server again?
> >
> > Thank you,
> > Tammy
>
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
TammyTry starting the server using the -f option, then change this value back to 0.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I can
> not start the server any more, nor can I set open objects to a smaller value.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:
> Try starting the server using the -f option, then change this value back to 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> > SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> >
> > I set open objects to 2147483647 for research purpose. After I did it, I can
> > not start the server any more, nor can I set open objects to a smaller value.
> > The error message I got was:
> > [Shared Memory]SQL Server does not exist or access denied.
> > [Shared Memory]ConnectionOpen (Connect()).
> >
> > What should I do to be able to start the server again?
> >
> > Thank you,
> > Tammy
>
Can not start server after setting open objects to 2147483647
SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
Tammy
Try starting the server using the -f option, then change this value back to 0.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I can
> not start the server any more, nor can I set open objects to a smaller value.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy
|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:
> Try starting the server using the -f option, then change this value back to 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
>
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
Tammy
Try starting the server using the -f option, then change this value back to 0.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I can
> not start the server any more, nor can I set open objects to a smaller value.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy
|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:
> Try starting the server using the -f option, then change this value back to 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
>
Can not start server after setting open objects to 2147483647
SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value
.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
TammyTry starting the server using the -f option, then change this value back to
0.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I c
an
> not start the server any more, nor can I set open objects to a smaller val
ue.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:
> Try starting the server using the -f option, then change this value back t
o 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
>
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value
.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
TammyTry starting the server using the -f option, then change this value back to
0.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I c
an
> not start the server any more, nor can I set open objects to a smaller val
ue.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:
> Try starting the server using the -f option, then change this value back t
o 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
>
Subscribe to:
Posts (Atom)