Endpoint Protection

Bonjour

J’ai un serveur SEPM 12.1, il est configurer pour être un serveur additionnel d'un serveur principale

j'ai lancer une réparation a ce serveur Additionnel comme ce dernier ne connecte pas la base de données SQL 2005

Mais le message d'erreur suivant s'affiche à la fin de réparation

Did you open ports on the firewall?

non le parfeu n'est pas activé

And exact 12.1 version?

SEPM 12.1.671.4971

S.V.P aidez moi

So you use windows authentication correct?

If so, make sure to use the domain\username format, not just the username. Domain needs to be there as well

c'est ce que j'ai fait

Aside from incorrect format/credentials or the connection being blocked, those are usually the two main culprits

Verify the ODBC connection, when the connection is success you will be able to run the management server configuration wizard.

To verify ODBC connection to the SQL database:

1. Click Start button and select Run.
   • If the Operating System is 32 bit, enter "%systemroot%\system32\odbcad32.exe"
   
   
   • If the Operating System is 64 bit, enter "%systemroot%\syswow64\odbcad32.exe"
   
   
    
2. In the ODBC Data Source Administrator dialog box, click System DSN.


3. On the System DSN tab, double-click SymantecEndpointSecurityDSN.


4. In the Server drop-down list, verify that the correct server and instance is selected.


5. Click Next.


6. For Login ID, type sa.


7. In the Password text box, type the password for the database.


8. This password is the one that you entered for the database when you installed the management server.



 
9. Click Next and make sure that sem5 is selected for the default database.


10. Click Next.


11. Click Finish.


12. Click "Test Data Source" and look for the result that states: TESTS COMPLETED SUCCESSFULLY!
13.