Question

I'm having trouble connectiong to my SQL Server database and get the following error:

Error Message

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

Answer 1

Solution

You probably 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