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 page-level compression?
What are the advantages of sql azure?
Explain contrast amongst grouped and non-bunched records?
Why do we use stored procedures in sql server?
How do I connect to sql server database?
How do we know if any query is retrieving a large amount of data or very little data?
What is lock escalation? : sql server database administration
What is trace flag in sql server?
What are database states in ms sql server?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is the difference between stored procedure and user defined functions?
How to get the number of affected rows?
What do you mean by an execution plan? Why is it used? How would you view it?