Knowledgebase: Remote Installation Instances
TROUBLESHOOTING: Connection To SQL Failed
Posted by Brian Kleeman on 15 August 2006 02:13 PM
When attempting to access the LMS, you receive the following (or similar) error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection
Your Microsoft SQL Server installation is not set for "Mixed Mode Authentication".
Microsoft SQL Server allows you to connect to it using Windows Authentication and/or SQL Server Authentication. Windows Authentication grants users that exist on the server itself access to SQL whereas SQL Server Authentication requires you to provide a login and password for an account that has been created directly in SQL Server. Mixed Mode allows both of these authentication types. By default, SQL Server installs with only Windows Authentication enabled while Inquisiq EX attempts to connect using SQL Server Authentication.
Change SQL Server over to Mixed Mode Authentication
Set Inquisiq to use Windows Authentication