Notes on configuring SQL Server before connecting to it - salehram/mikrotik-proxy-logger GitHub Wiki

  • SQL server must be installed in mixed authentication mode, as the application will need a user name and password to connect to the server.
  • A database must be created on the SQL server before configuring the application to connect to it, it is recommended to use a short name.
  • It is recommended to use a user different than ‘sa’, so a new user need to be created, with the roles ‘db_owner’ on the selected database.
  • If you are using an express instance of SQL server, then you should write “sqlexpress” as instance name in the configuration window.
  • If you were using a standard or higher instance of the SQL server, the default instance is “MSSQLSERVER”.