Submitted by Jordan Peacock on Tue, 2012-04-17 12:49
When you configure the ODBC data source, you get the error:
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:
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 Yes to restart Microsoft SQL Server.
Product or Component Name: