Troubleshooting tips for SQL Error

- Verify that SQL is configured for SQL Server authentication mode or mixed mode

- 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
• Right mouse click and select New User
• Set the user name to: qlmuser
• Set the Login name to: qlmuser
• Set the following Role Members: db_datareader, db_datawriter, db_ddladmin

If you get an error like:

Failed to validate products XML file. Error: ExecuteReader requires an open and available Connection. The connection's current state is closed.

The issue is most likely a security issue. The steps above should resolve the issue.