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
- 5292 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
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you initialize log miner?
What are the operating modes in which database mirroring runs? : sql server DBA
Why would you use sql agent? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
how can you process messages in order asynchronously?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Query processing is slow(eg select query)how will u solve that
what are the performance views in an oracle rac environment?
What purpose does the model database server? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
