SQL Administrator Question:
Download Job Interview Questions and Answers PDF
Tell us what different steps will a SQL Server Developer takes to secure SQL Server?
Answer:
☛ Preferring NT authentication
☛ Using server, database and application roles to control access to the data
☛ Securing the physical database files using NTFS permissions
☛ Using an unusable 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
☛ Using server, database and application roles to control access to the data
☛ Securing the physical database files using NTFS permissions
☛ Using an unusable 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
Download SQL Administrator Interview Questions And Answers
PDF