ePO 5.10 change events database name

[polezhaevdmi]

The goal was: change the deployed ePO 5.10 (up13) both internal databases names (to eliminate host name from names of both databases). No migration of files or SQL server was planned, just rename the databases.

Steps taken (planned using KB52126, KB68427, KB69850):

- Stopped both 3 ePO services to release the database;

- Both databases were renamed using SQL Server Management Studio (at screenshot);

- In main database two synonyms were re-created to point to renamed events database (got from  McAfee video "McAfee Center Stage: ePO Database Maintenance Best Practices" at YouTube);

- ePO Application Server was started;

- The ePO database configuration (https://localhost:8443/core/config) was edited to reflect database name change;

- Rest of ePO services were started;

- The "Registered Servers" section was edited was edited to reflect database name change;

- ePO functionality was checked, OS restarted, ePO functionality was checked again.

Result: ePO looks almost fine now, except some dashboard queries (at screenshot).

Remaining questions: 

- Which extra steps should be performed to restore ePO functionality (if this possible)?

- Which alternative way (if any) might be used to rename both ePO databases?

P.S.> You are banning McAfee Enterprise YouTube links, LOL! 

[aguevara · Accepted solution]

The procedure to change the name of the Databases and synonyms is described on the Registered article below:

https://kc.mcafee.com/agent/index?page=content&id=KB94860

After doing this changes please ensure you see Threat Events under your ePO Threat Event Log

This is similar to what you have done already but i want to ensure you have done it with the same scripts from the article 

Regards

Alejandro

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

[polezhaevdmi]

@aguevara, congratulations, Your advice was effective!

The only difference between the KB94860 procedure and mine was the synonyms creation method. I used the interactive creation, while KB article involved scripting. I deleted my synonyms again, run the script (made from KB templates), and got the fully functional ePO.

Great thanks!

[aguevara]

Great, thanks for sharing 🙂