Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps you will take, if you are tasked with
securing an SQL Server?
- 1 Answers
- 7758 Views
- HCL, I also Faced
- E-Mail Answers
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
List the different index configurations possible for a table?
What is difference between getdate and sysdatetime in sql server 2008?
What is a View ? Can we insert, Update and delete a view?
Define constraints and give an example of their use?
What is right outer join in sql server joins?
Can truncate be rolled back?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What are the advantages of using cte?
What is difference between delete & truncate commands?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What is a partition function in sql server?
How to optimize stored procedures in sql server?
What are different type of Collation Sensitivity?
What is a collation?
Explain what is lock escalation and what is its purpose?
