Troubleshooting tips for SQL Error

Authentication Mode

Verify that SQL Server is configured for "SQL Server and Windows authentication mode". This is done by viewing the properties at the SQL Server level and selecting the Security Node.

Security

Verify that the user configured to access your database as specified in the web.config is configured at 2 levels:

• At the SQL Server / Security / Logins level
• At the Database / Security / Users level

Verify that the user at the Database level has the appropriate privileges. To do so:

• Start SQL Server Management Studio
• Locate your Database and expand the node
• Locate the Security node and expand it
• Locate the Users node and expand it
• To create a new user (skip this step if the qlmuser is already created): 
  • Right mouse click and select New User
  • Set the user name to: qlmuser
  • Set the Login name to: qlmuser
• Set the following Membership: db_datareader, db_datawriter, db_ddladmin

 SSL / TLS 

If you get the error: [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error, this means that you are using an older version of the OLE  DB Driver for SQL which does not support TLS 1.2. You must :

1. Install the latest Microsoft OLE DB Driver 18 for SQL Server from: 
https://www.microsoft.com/en-us/download/details.aspx?id=56730

2. Update the connectionStrings in the web.config as shown below (change the values of Server, Database, User and Password as needed)

<connectionStrings>
  <add name="QlmWebService.Properties.Settings.qlmConnectionString"
      connectionString="Provider=msoledbsql;Server=localhost;Database=qlmdemo;User Id=qlmdemo;Password=qlmweb30;"
  />
  <add name="QlmSvcLib.Properties.Settings.qlmConnectionString"
    connectionString="Provider=msoledbsql;Server=localhost;Database=qlmdemo;User Id=qlmdemo;Password=qlmweb30;"
    />
  <add name="aspConnectionString" connectionString="Data Source=localhost;Initial Catalog=qlmdemo;User Id=qlmdemo;Password=qlmweb30;"
    providerName="System.Data.SqlClient" />
 </connectionStrings>