When trying to connect to a local MS SQL Server I get an error message that says:
“Problem: Login failed for user ‘Username’. Reason: Not associated with a trusted SQL Server connection.”
What’s going on?
I’ve been meaning to post on this one. This happens with many different versions of MS SQL Server when you want to authenticate with a user name and password that doesn’t use Windows Authentication. This is a typical option since you often want to specify a limited user to run SQL queries from the FactorySQL service prior to logging on to the computer.
Go to the enterprise manager or SQL Server Management Studio for SQL Server 2005. Select the SQL server, right click and click properties. Select the security tab or pane, under Server Authentication select SQL Server and Windows Authentication Mode
You will probably want to reboot the computer. edit - you can just restart the service