What are the steps you will take, if you are tasked with
securing an SQL Server?



What are the steps you will take, if you are tasked with securing an SQL Server? ..

Answer / swapna

Preferring NT authentication, using server, databse and
application roles to control access to the data, securing
the physical database files using NTFS permissions, using
an unguessable SA password, restricting physical access to
the SQL Server, renaming the Administrator account on the
SQL Server computer, disabling the Guest account, enabling
auditing, using multiprotocol encryption, setting up SSL,
setting up firewalls, isolating SQL Server from the web
server etc.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is data source object?

0 Answers  


SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,


What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  


How to make a column nullable?

0 Answers  


What is dirty read?

0 Answers  






how to implement locking in sql server

3 Answers   Satyam,


How to update muliple row in single query?

0 Answers   MCN Solutions,


Tell me about builtinadministrator?

0 Answers  


What are the types of database recovery models?

0 Answers   HCL,


What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,


How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,


How to receive output values from stored procedures?

0 Answers  


Categories