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
- 7858 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
Explain about nested stored procedure?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What do you understand by the denormalisation?
How many databases instances are there in sql server 2000?
How can we migrate from SQL server to SQL Azure?
how you can configure a running aggregate in SSRS?
What is tablix?
What is an example of a foreign key?
What do we have to check in database testing?
What is a database table?
What is simple indexing method?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
How to delete duplicate rows?
What guidelines should be followed to help minimize deadlocks?
How to loop through returning rows?
