Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?



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

Why would you call update statistics? : sql server DBA

0 Answers  


What does coalescing a tablespace do?

1 Answers  


What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  


Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  


If we issue alter database begin backup. What happens to database?

2 Answers  


orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,


What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  


How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,


What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  


What is the default port no on which sql server listens? : sql server DBA

0 Answers  


What is fill factor? : sql server DBA

0 Answers  


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


Categories