407-248-1481
QuoteWerks Turkey Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Request a Demo
Customer Area

QuoteWerks Knowledgebase Topic (Article ID 6031)

SQL Server Not Running in Mixed Mode

This information applies to :

Article ID
6031

Created/Updated
September 12, 2023

Category
Troubleshooting

Are you using the most current release of QuoteWerks?
Version 24.0 Build 4
Issue:

I am receiving the following error:

Error opening connection in ConnOpen()
Error (-2147467259) Login failed for user ''. Reason: Not associated with a trusted SQL Server connection., NativeError=18452

ConnectString=UserID=;Password={PasswordIsHidden};Data
Source=<"databasename".local;Provider=sqloledb;


Cause:

QuoteWerks Corporate Edition requires that the SQL Server is running in Mixed Mode. Your SQL server may be set to Windows Authentication.

Solution:

Launch SQL Server Management Studio (SSMS) and right-click on the QuoteWerks database and select Properties. On the Security Tab of the SQL Server Properties window, select the Radio Button labeled "SQL Server and Windows."


To change the authentication mode from Windows Authentication Mode (only) to Mixed Mode, use the following steps:
1. Open SQL Server Management Studio (SSMS)
2. Right-click a server name, and then click Properties.
3. Click the Security tab.
4. Under Authentication, click the SQL Server and Windows option button.
5. Restart SQL Server Service in order for the change to take effect.

New Search

  •            
©1993-2024 Aspire Technologies, Inc.
    407-248-1481 (9am-5pm ET M-F)