"Login failed for user 'username'. The user is not associated with a trusted SQL Server connection" in install_log.err while installing Symantec Endpoint Protection Manager (SEPM) on Microsoft SQL 2005
|Article:TECH90870|||||Created: 2008-01-13|||||Updated: 2009-01-26|||||Article URL http://www.symantec.com/docs/TECH90870|
While installing SEPM on Microsoft SQL 2005 you get an Error: "Failed to connect to the database. Please make sure the database server port is not used by another application and that your password is correct.".
While installing SEPM on SQL 2005 you get an Error: "Failed to connect to the database. Please make sure the database server port is not used by another application and that your password is correct. When you check the install_log.err you see the error "Login failed for user 'username'. The user is not associated with a trusted SQL Server connection.
SQL Server Authentication is not enabled.on SQL Server 2005
Login to the SQL Server Management Studio using Windows Authentication
Right Click on the Server Name/Instance name click properties
Select Security and Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".
Under the SQL Server Management Studio expand Security and then expand Logins.
Right Click on "sa" click properties go to Status and change it to Enabled.
Again right click on Server name\Instance Name and click Restart.
It will restart the SQLSERVER service and you should be able to install SEPM.
Article URL http://www.symantec.com/docs/TECH90870