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 current limitation of the size of SQL Azure DB?
What are the advantages of paper records?
How to achieve Paging of records in SQL SERVER?
What is the primary use of the model database?
Explain what is raid and what are different types of raid levels?
What is the full meaning of dml?
Difference between connected and disconnected database in .net with sql server?
Explain difference between cross join and full outer join?
What does executeupdate return?
What do you understand by coalesce in sql server?
Do you know what are different types of replication in sql server?
How check triggers in sql server?
How many databases instances are there in sql server 2000?
What is the function of sql server agent windows service?
What is a field name?