What are the steps you will take, if you are tasked with
securing an SQL Server?
- 1 Answers
- 7064 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
Differentiate between delete and truncate.
Can we write a distributed query and get some data which is located on other server and oracle database?
Explain transaction server implicit?
What are the aggregate and scalar functions?
System requirements for sql server 2005 express edition?
When do you think a developer should use sql server-based cursors?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
How to list all user names in a database?
List out different types of normalizations in sql server and explain each of them?
Explain external key management in sql server 2008
What is the use of “join” in sql server?
A trigger can reference objects outside the current database? State true or false.
What are 3 ways to get a count of the number of records in a table?
Why do we need normalization?
Why transaction is important?
