What are the steps you will take, if you are tasked with
securing an SQL Server?



What are the steps you will take, if you are tasked with securing an SQL Server?..

Answer / 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

More DB Administration Interview Questions

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,


Can you redefine a table online?

0 Answers   Oracle,


what is asm?

0 Answers   Oracle,


who owns the operating system files created by the utl_file package?

0 Answers   Oracle,


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,






What is dcl? : sql server DBA

0 Answers  


Name three advisory statistics you can collect.

1 Answers  


How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  


Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  


If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  


Categories