What are the steps you will take, if you are tasked with
securing an SQL Server?
Answer Posted / 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 View All Answers
What is the purpose of the model database?
Explain relational data?
What is sql server agent and what are the two modes of authentication in sql server?
What is the difference between online clustering and Offline clustering?
Do you know what are the properties of the relational tables?
Explain what are commit and rollback in sql?
What is a sql join?
How to set database to be read_only in ms sql server?
What is difference between standardization and normalization?
How to insert data with null values?
What are number line correlation administrators will use while working with a subquery?
What is sql server profiler?
Is it possible to replicate data from sql server to oracle? : sql server replication
How to recreate an existing index in ms sql server?
What are the characteristics of modern DBMS?