What are the steps you will take, if you are tasked with
securing an SQL Server?
Answer / 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 |
What is data source object?
SQL Server Performance Tuning for Stored Procedures & reducing debugging time?
1 Answers CarrizalSoft Technologies,
What are the different Authentication modes in SQL Server and how can you change authentication mode?
How to make a column nullable?
What is dirty read?
how to implement locking in sql server
How to update muliple row in single query?
Tell me about builtinadministrator?
What are the types of database recovery models?
What do you mean by 'normalization'?
0 Answers Ernst Young, Thomson Reuters,
How To delete duplicate record from a particular table?
How to receive output values from stored procedures?