407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6031)

SQL Server Not Running in Mixed Mode

This information applies to :

Article ID
6031

Created/Updated
November 25, 2008

Category
Troubleshooting


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
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 the SQL Enterprise Manager 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 NT Authentication Mode (only) to Mixed Mode, use the following steps:
1. Open the Enterprise Manager.
2. Expand a Server group.
3. Right-click a server name, and then click Properties.
4. Click the Security tab.
5. Under Authentication, click the SQL Server and Windows option button.
6. Restart SQL Server in order for the change to take effect.

With MSDE, the setting you'll likely need to use is "SQL and WinNT Authentication", rather than just "SQL Authentication".

More information can be found via the Microsoft Help and Support Knowledge Base or http://support.microsoft.com/kb/269587

New Search