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
- 5196 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 purpose does the model database server? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
what is ora 24313?what is the procedure to exclude that error?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Why would you call update statistics? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How do you trace the traffic hitting a sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What authentication modes does sql server support? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
