Problem:

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

Solution:

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.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016