Error not associated with a trusted SQL server connection - Support

Error not associated with a trusted SQL server connection

From Support

Jump to: navigation, search
If you have a question or seek clarification, please call Technical Support.
[edit]

Problem:

While configuring the ODBC data source (step 2 on page 12 of the ACS Administrator Guide) I'm getting the error Connection failed: 

SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'gbadmin'. Reason: Not associated with a  trusted SQL Server connection
[edit]

Solution:

It's possible you didn't specify "Mixed Mode authentication" during the install.

  • Open The SQL Server Enterprise Manager Start menu > Programs > Microsoft SQL Server > Enterprise Manager)
  • Expand the tree-control until you can your server
  • Right click on the server name and "SQL Server Properties (Configure)" window will open
  • Select the Security tab
  • For "Authentication", select "SQL Server and Windows"


Click "OK" to close the window and then "Yes" to restart SQL Server

Retrieved from "http://wiki.rjssoftware.com/wiki/index.php/Error_not_associated_with_a_trusted_SQL_server_connection"
Personal tools