|
I have setup the application(s) to use a Microsoft SQL Server 2005 database. I know the software is supposed to be compatable with Microsoft SQL Server 2005 databases, so I figure I must have not setup something correctly, as it does not seem to be working. I am seeing the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'username'.
The user is not associated with a trusted SQL Server connection.
|
|
|
This error occurs when you have setup the Microsoft SQL Server in Trusted Mode authentication and you are trying to use a SQL Login account to access the database. When installing SQL Server, you want to select Mixed Mode or "SQL Server and Windows Authentication". If you have already installed your SQL Server in Windows Authentication mode, you can change this setting without having to re-install SQL Server. To do so, look at the Properties of the SQL Server in Microsoft SQL Server Management Studio and on the Security page, change the Server Authentication to mixed mode. Complete step by step details can be found in the following article on the Microsoft web site.
How to: Change Server Authentication Mode
|
