This content has been marked as final. Show 6 replies
to do this:
stop mcafee services on ePO app
copy epo DB (mdf and ldf) files to your new SQL destination
on new SQL create user for EPO (I use local SQL account with password that include only numbers and letters - some bug on Mcafee side, dont remember why), attach those files, assign DBO permissions to this user.
on your ePO app server:
Go to this URL in ePolicy Orchestrator: http://server/core/config
In the Configure Database Settings page, scroll down and change the credentials as
Click OK when done.
Restart the system to apply the changes.
if everything working fine you will able to remove SQL from same server
After trying your suggestion, it seems that the Mcafee epolicy orchestrator services depends on the SQL Server instance.
so removing sql will screw up the epo installation (i had a backup happy ) and trying to stop it manually will also stop the 3 mcafee services.
checking the core/config - it looks correct. any suggestions?
I install EPO 4.5 - Application and SQL DB on same Maschine.
i want to move the database to a remote SQL Server.
i make a backup und restore the db on the remote SQL Server.
local SQL user has DBO rights für the epo DB
i restart the epo server and make the change for the new SQL server, Test for connection was fine.
restart the server and no epo login possible.
here a log error entry:
Description = [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
but with SQL Management Studio using the same DB User, i have access to the EPO_DB...
anyone a idea?
see this kb article ( 4.5 goes like 4.0 but may be some key name changes so check first)
step 4 & 5 are what was missing for the last poster on this thread
according Step 5 from https://kc.mcafee.com/corporate/index?page=content&id=KB58843&actp=search&search id=1252059113198
Which SQL Procedure i have to change in EPO 4.5.
i can´t find SQL-JOBS.sql in the epo 4.5 directory