Troubleshooting tips for SQL Error
PreviousQLM License Server - Disaster Recovery SiteNextError: ExecuteReader requires an open and available Connection.
Last updated
Last updated
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.
1. 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
2. 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
3. Verify the credentials in the web.config file
Locate the license server web.config file, typically located in c:\inetpub\wwwrooot\Qlm\QlmLicenseServer
Edit the web.config file with a text editor such as notepad
Locate the connectionstrings section
Verify that the Data Source setting points to your DB server
Verify that the name of the database is correct
Verify that the User/Pwd values to connect to the DB are correct
4. If you are upgrading from QLM v7 or older to QLM v15 or later, some tables need to be created prior to the upgrade (ServerProperties). Please contact our support team for assistance.
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>
