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
- 5301 Views
- STC, I also Faced
- E-Mail Answers
Answer Posted / sandeep
Again this is another open ended question. Here are some
things you could talk about: 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.
Read the white paper on SQL Server security from Microsoft
website. Also check out My SQL Server security best practices
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Where do you find the default index fill factor and how to change it? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How do you open a cluster administrator? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
what are the performance views in an oracle rac environment?
how can you get actual data change values from previous transactions in oracle?
Where would you look for errors from the database engine?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the recovery models for a database? : sql server DBA
how can you enable flashback feature?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what are the differences of where and if in SAS?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
