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
- 7945 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
What is log in sql server?
How to skip remaining statements in a loop block using continue statements?
What is precedence constraint?
How to delete existing rows in a table?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What is implicit mode in sql server?
What is difference between global temporary tables and local temporary tables?
What can be used instead of trigger?
What is 4nf in normalization form?
Can we join two tables without primary key?
Explain important index characteristics?
Write a SQL command to insert and update only a particular field?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is database isolation in sql server? : sql server database administration
Explain table valued parameters in sql server? Why tvp used?
