Unexpected Server error after install of Endpoint Protection Manager on a new server with SQL Express Database

Products

• Endpoint Protection

Issue/Introduction

After installing SEPM with SQL Express Database, when attempting to login you receive the error: Unexpected Server Error. The console does not load at all.

In the scm-server-0.log file, you see the following error:

java.sql.SQLException: Cannot create PoolableConnectionFactory (Login failed for user 'DBA'. ClientConnectionId:xxxx)

If you attempt to run the Management and Configuration Wizard, at the SQL Server selection point, you see this message: The Symantec endpoint protection manager detected that the database password was changed on an external database tool.

Error running Database Restore: Symantec Endpoint Protection Manager database credentials are not valid

Environment

Release : 14.3 RU6

Cause

The DBA account created during the install is set to disabled for login.

Resolution

To resolve the issue, follow these steps: 

1. Install SQL Server Management Studio from Microsoft (free download/install).
2. Launch the SSMS.
3. Connect to the SQL Express instance. The SSMS tool will see it installed. Windows integrated should work.
4. Browse under Security > Logins and double-click on the DBA user in the list (alternatively right-click on DBA and select Properties).
5. To verify the issue: Click on Status and see if the option "Disable SQL Server Authentication Login" is checked. If it is checked, then continue below.
6. Click on General.
7. Where the password is shown, type in a new password. This password must contain both upper and lower case letters, a number, and a special character. The password you set in this step is not important as you will be changing it back to the default one.
8. Supply the same password under Verify password.
9. Click OK to change the password.
10. Double-click on DBA (or right-click and select Properties) and click on the Status option.
11. Uncheck the option "Disable SQL Server Authentication Login".
12. Click back on General.
13. Change the password to the password set as the Admin user for console login set during the installation of the SEPM server.
14. Click OK.

The issue should be resolved.