Custom SQL Server Configuration

The default installation configures the services to utilize the default G-Core SQL Server Instance. If using an external or other SQL Server you need to configure the Connection String manually in both the Proxy\appSettings.json and web\appSettings.json files.

  "ConnectionStrings": {
    "MSSQLConnection": "Data Source =.\\GCORESQL; Initial Catalog = GHealth; Integrated Security = True; Encrypt = false"
  },

Replace the MSSQLConnection value with your custom string. Save your changes in each file and restart both the GHealth.ProxyService and GHealth.WebService respectively.

E.g.

"ConnectionStrings": {
    "MSSQLConnection": "Server=tcp:sqldb.myorganisation.com,1433;Initial Catalog=GHealth;Persist Security Info=False;User ID={your_sql_username};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
  },