?
Solved

Disabling SQL 2000 SA account

Posted on 2005-05-12
7
Medium Priority
?
302 Views
Last Modified: 2008-02-20
I have inherited an archaic program that runs on sql 2000 which is directly connected to the internet.  Basically 1433 needs to be open and the box sits on my dmz, so 1433 is exposed to all.  I have closed all other inbound and outbound ports fro this box through my firewall.  I would like to disable the sa account totally.  Is this possible, and if so, what is the best practice to accomplish this?

thanks,
0
Comment
Question by:rptsysadmin
  • 3
4 Comments
 
LVL 7

Accepted Solution

by:
ABaruh earned 1000 total points
ID: 13991185
Have you thought about making the security to Windows Authentication only?  (Not Mixed-Mode)

To remove the sa account you would have to change the database owner for all of the databases where sa was the owner.  Remove SA from the System Administrators role and it might be a good idea to remove Builtin\Administrators from the System Administrator role as well.

Of course, before you do all this you want to ensure that you have an account that has SysAdmin privileges and that you can login under that account.

You also may need to modify any jobs that may use SA as the "Run Under" account and also that have SA set as the owner.
0
 

Author Comment

by:rptsysadmin
ID: 13991231
Yes,  i have thought about changing to windows authentication.  Would that be done ONLY through the registry under loginmode key?  or is there another way to do that?

i would rather use windows authentication only and not have to worry about removing the sa.
0
 
LVL 7

Expert Comment

by:ABaruh
ID: 14133714
You go into Properties for the SQL Server (in Enterprise Manager) and change the login mode in the Security tab.
0
 
LVL 7

Expert Comment

by:ABaruh
ID: 14302748
I provided a solution, and went further by recommending Windows Authentication
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question