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

ePO 5.1.1 SQL DB Installation Path Change

I am installing ePO 5.1.1 with default SQL Express. I would like to change the destination folder of SQL Express to D drive. But even after selecting custom installation it doesn't prompt me for the SQL installation target folder. It only prompts for ePO application installation path. How can I install SQL express in D drive?

5 Replies

Re: ePO 5.1.1 SQL DB Installation Path Change

Hi,

You should install the SQL data base before the ePO installation, then when you running the ePO installation you should point to the instance before created with the SQL installation.

Best regards,

Jose Maria

avilt
Level 7
Report Inappropriate Content
Message 3 of 6

Re: ePO 5.1.1 SQL DB Installation Path Change

Can I do this with Default MS SQL Express (free MS SQL Express)  which ships with ePO?

avilt
Level 7
Report Inappropriate Content
Message 4 of 6

Re: ePO 5.1.1 SQL DB Installation Path Change

Also if I run the SQL setup prior to ePO setup, can I leave the default MSSQL instance?

Re: ePO 5.1.1 SQL DB Installation Path Change

Hi,

As far as I know you  cannot do it with the default ePO, that is why you should download the SQLServer express and install it. You can leave the default MSSQL and when the ePO installation just indicate the instance that you have created before.

Best regards

Jose

Troja
Level 14
Report Inappropriate Content
Message 6 of 6

Re: ePO 5.1.1 SQL DB Installation Path Change

Hi,

changing the database location is absolutely easy going.

1) Install an additional SQL Express instance. (we tested this with SQL 2012 express)

2) Install the SQL Express Management Tools to configure your SQL Express Installation. E.g. logins....

3) In my environment TCP was not activated. Just open the SQL configuration manager and activate TCP.

4) Stop EPO Server services

5) Copy the Database to the new location

6) Add the database to your SQL Server Instance and check the access rights.

7) Start the EPO Server management server. (Tomcat)

8) Open the DB server settings for EPO with your browser: https://myEpoServer:8443/core/config

9) Check the SQL server settings

10) Restart the EPO services

Hope this helps,

Cheers