SQL Server Error 18452 Not associated with a trusted SQL server connection


When you configure the ODBC data source, you get 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


You didn't choose Mixed Mode Authentication during installation. To set up mixed mode authentication:
  1. Go to Start > Programs > Microsoft SQL Server > Enterprise Manager.
  2. Expand the tree until your server displays.
  3. Right-click your server name.

    SQL Server Properties (Configure) displays.

  4. Choose the Security tab.
  5. In Authentication, choose SQL Server and Windows.
  6. Click OK.
  7. Click Yes to restart Microsoft SQL Server.
Product or Component Name: 
Sort Code: 

Contact Technical Support

Are you an existing RJS customer needing technical help?


Call Us: 1 (888) 757-7638
Hours: Mon-Fri 8am to 5pm CST