Configure Settings via Connection String

  1. Turn on the "Use Connection String" switch and enter the "Connection String" information of the database you want to connect to on the screen that appears.
  2. For Connection String information, enter information in the format "Server= ;Database= ;User Id= ;Password= ;".
  3. MSSQL Server must be open to the internet to provide a connection to an MSSQL database that you are working locally.
  4. After entering the information, test whether the MSSQL connection is working or not via the "Test" button above. If the MSSQL connection is working, create the Datasources connection by clicking the "CREATE" button.

Example MSSQL Data Source


"Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"
This connection will work smoothly when the user information is entered correctly in the "myServerAddress", "myDataBase", "myUsername", "myPassword" fields.