1.

What Are The Multiple Ways To Secure A Sql Server?

Answer»

There are MULTIPLE approaches with which a developer can ensure the safety and security of a SQL server. Some of them MIGHT be COMMON usage while others can be more technically oriented.

  • Administrator account on SQL server computer can be renamed.
  • Isolate the SQL server from the web server, by setting up SSL and firewalls.
  • Always control access to the data by applying roles for server, database, and application.
  • NTFS permissions can be utilized to secure physical database FILES.
  • Enable auditing with encryption, disabling the guest account.
  • NOT authentications should be preferred.
  • Utilize a STRONG System administrator password, restricting physical access to SQL server.

There are multiple approaches with which a developer can ensure the safety and security of a SQL server. Some of them might be common usage while others can be more technically oriented.


Discussion

No Comment Found

Related InterviewSolutions