What are the steps you will take, if you are tasked with
securing an SQL Server?
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
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
how can you connect from 10g user to 11g user??
what is the diffrence between core dba and apps dba?
Query processing is slow(eg select query)how will u solve that
how to restore files with rman?
Explain materialized views and how they are used.
Explain about your sql server dba experience? : sql server DBA
which background process invoke at the time of upgradation tell me???
what are the performance views in an oracle rac environment?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is grd?
when does an alert gets signaled?