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:
- Go to Start > Programs > Microsoft SQL Server > Enterprise Manager.
- Expand the tree until your server displays.
- Right-click your server name.
SQL Server Properties (Configure) displays.
- Choose the Security tab.
- In Authentication, choose SQL Server and Windows.
- Click OK.
- Click Yes to restart Microsoft SQL Server.
Last Modified On:
No, open a new Support Case