Remote Connection to SQL Database

9 November, 2017
Technical tips

Sometimes you need to have a remote connection to SQL Database. It means that you will be configuring the login and password for a remote connection to a database. While configuring it, you will see these two little checkboxes:

Remote Connection to SQL Database

Please note that leaving them checked will lead to the following situation: when the password validation period expires, SmartPTT will no longer be able to connect to the database. SmartPTT will shut down, because it is not possible to write anything on the database, and, as our Dispatcher is based on the database work, it cannot even start without a database connection. It means that you will have to go and manually reset the password to a new one and reconfigure it in all dispatchers and servers, which use it.

Below there is the Password policy for SQL:

  1. At least 8 characters long;
  2. Does not contain name of PC user;
  3. The password must contain characters from three of the following four categories:
  • Latin uppercase letters (A through Z)
  • Latin lowercase letters (a through z)
  • Base 10 digits (0 through 9)
  • Non-alphanumeric characters such as: exclamation point (!), dollar sign ($), number sign (#), or percent (%).

Thus, it is pretty hard to figure out an easy-to-remember and at the same time complex enough password:

ThisIsNotComplexEnough

this_one_is_also_too_simple

This1isGoodApparently

So, if you are sure about the safety of your IT system, you can uncheck these checkboxes and forget about them. Otherwise, you should manually change all passwords in the system every three months, following the rules above.