"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 |
Problem
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.".
Symptoms
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.
Cause
SQL Server Authentication is not enabled.on SQL Server 2005
Solution
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)".
Click OK
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.
Click OK
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.
References
http://support.microsoft.com/kb/555332
|
|
Legacy ID
2008111401380948
Article URL http://www.symantec.com/docs/TECH90870
Terms of use for this information are found in Legal Notices
Thank you.