407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6347)

SQL - Changing QuoteWerks User / Password to use with SQL

This information applies to :

Article ID
6347

Created/Updated
March 9, 2012

Category
SQL


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
Issue:
When launching the rehosted Corporate Edition of QuoteWerks, the following message appears:

Error opening connection in ConnOpen();
Error(-2147217843) Login Failed for user 'sa'.

Provider Errors:
Error(-2147217843) Login Failed for user 'sa'. Native Error=18456


Cause:
The username / password combination used to connect to the SQL server is no longer valid.


Solution:
1. Launch the QuoteWerks Medic Utility located in the QuoteWerks directory called MEDIC.EXE. The Medic Utility can also be launched from the Start Menu under QuoteWerks-Tools&Information-Medic Utility.

2. Select the Utilities-System Database Setup Menu.

3. Make the appropriate SQL server changes and click the OK Button.
NOTE!!!!!: MAKE SURE THE BACKEND.INI REFLECTS THE IPADDRESS OF THE SQL SERVER (NOT THE SERVER NAME)!!!

New Search