cancel
Showing results for 
Search instead for 
Did you mean: 
epouch
Level 7
Report Inappropriate Content
Message 1 of 15

Create database for ePO PRIOR to setting up ePO?

Customer has Pro-Services coming onsite.  Prior to them arriving they are trying to ensure all the required access / port / firewall rules and accounts are all created. Is it possible to set up the DB without setting up ePO???

14 Replies
mmcgary
Level 12
Report Inappropriate Content
Message 2 of 15

Re: Create database for ePO PRIOR to setting up ePO?

No. You can setup SQL and its associated port, instance, firewall rules, and access accounts but no you can't create an EPO database for installing EPO.

epouch
Level 7
Report Inappropriate Content
Message 3 of 15

Re: Create database for ePO PRIOR to setting up ePO?

So there's no way to create a sql DB and then during ePO setup point it to that DB?


Customer wants to make sure all permissions and port communications for the DMZ server and access for the DMZ accounts are present and correct prior to McAfee being on site.

Apparently a competitor, has the option of setting up a DB ahead of time and just pointing their product to it.

I am hoping McAfee SQL support can give me a similar process that we can do prior to running the installation of ePO and we can simply point the installer to the pre-created empty Database.

mmcgary
Level 12
Report Inappropriate Content
Message 4 of 15

Re: Create database for ePO PRIOR to setting up ePO?

The EPO database is created by the application installer and is tied to the EPO file system associated with it. There would be no need to create a database first as long as whoever installs SQL knows what they're doing.  Just follow our KB for Ports-required and SQL-permissions-required and you should be fine.

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

McAfee KnowledgeBase - Ports needed by ePO 4.x and ePO 5.x for communication through a firewall

mekafir
Level 7
Report Inappropriate Content
Message 5 of 15

Re: Create database for ePO PRIOR to setting up ePO?

can you please also share the article in migrating the SQL database from the Express Edition to another SQL Server box ?

mmcgary
Level 12
Report Inappropriate Content
Message 6 of 15

Re: Create database for ePO PRIOR to setting up ePO?

mekafir
Level 7
Report Inappropriate Content
Message 7 of 15

Re: Create database for ePO PRIOR to setting up ePO?

Thanks

andrep1
Level 14
Report Inappropriate Content
Message 8 of 15

Re: Create database for ePO PRIOR to setting up ePO?

The only way you can point to an existing database is when you are trying to do an install from the backup located in the DB files or doing a crash recovery the old fashion way. The DB creation is fast when doing the install. Even if you just created the container DB, there many tables, index, stored procedures and those are tightly linked to the install.

mekafir
Level 7
Report Inappropriate Content
Message 9 of 15

Re: Create database for ePO PRIOR to setting up ePO?

, So in this case, there is no way to migrate or change the database from one location to another one after it is running in production ?

andrep1
Level 14
Report Inappropriate Content
Message 10 of 15

Re: Create database for ePO PRIOR to setting up ePO?

Structure and content are created by the product and are tightly integrated. But you can move an epo database with its application server, if IP or name change you follow the crash recovery process.

For your specific issue, I gather from what you are saying to get everything ready, if you have both the db server and the app server up, you can create a database on the sql server and see if it is accessible by the app server. That should be enough to test your connectivity issue (create a .udl file and fill the blanks)

Refer to the following for the permissions required by the ePO SQL account:

McAfee KnowledgeBase - SQL permissions required to install and use ePolicy Orchestrator