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

Upgrade 3.61 to 4.0

Hello,

sorry i read a lot about update and migration but i am not sure it will help me.

Here is my constallation:

Windows Server 2003 SP2 (32Bit)
ePO 3.6.1.255 Enterprise Edition
SQL Server 8.0.2039

and i will upgrade to 4.0.

I know there is a Problem with SQL Server but can i update them seperatly to SQL 2005???

I am thinking about a clean installation but i have to many Policys and i will not import them seperatly and my Structur is now the right for our Systems.

Where can i find a HowTo or is anyone there with Hints and Tipps for me.

with best regards.
André J.
16 Replies
Dvanmeter
Level 10
Report Inappropriate Content
Message 2 of 17

RE: Upgrade 3.61 to 4.0

is your sql server remote or local?
TronixS
Level 7
Report Inappropriate Content
Message 3 of 17

RE: Upgrade 3.61 to 4.0

Hi,

the SQL and EPO on the same Server, on a seperate HD i backup the TRN Files and make a Backup from the DB.
Dvanmeter
Level 10
Report Inappropriate Content
Message 4 of 17

RE: Upgrade 3.61 to 4.0

full version of SQL or the sql that came with epo?
TronixS
Level 7
Report Inappropriate Content
Message 5 of 17

RE: Upgrade 3.61 to 4.0



It is the Full Version of MS SQL 2000. 😉

but now i am thinking, how can i find it out?!

Okay, i find it out, it is the REAL 2000 SQL from MS.
Dvanmeter
Level 10
Report Inappropriate Content
Message 6 of 17

RE: Upgrade 3.61 to 4.0

Well the full version should have costed you some money, if you dont remember paying for anything then its probably the free one. Go to add remove programs and see what you have there. Do you have a management studio for managing tables and queries, that would be a sign on the full version.
TronixS
Level 7
Report Inappropriate Content
Message 7 of 17

RE: Upgrade 3.61 to 4.0

Okay, MS SQL 2000 is Full Version and with our Enteprise Contract i can use MS SQL 2005 or Higher.
Dvanmeter
Level 10
Report Inappropriate Content
Message 8 of 17

RE: Upgrade 3.61 to 4.0

If its local free version then the upgrade should upgrade the database too. how many clients do you have in your EPO server?
TronixS
Level 7
Report Inappropriate Content
Message 9 of 17

RE: Upgrade 3.61 to 4.0



Round about 1800.

Did you mean, if i installed the SQL from epo then the Update for SQL goes automaticly if i upgrade to Version 4.0!!??
Highlighted

RE: Upgrade 3.61 to 4.0

Ok, its been a long time since I have been on EPO 3.6 so I am trying to do this out of memory. I would recommend talking to mcafee support first but here is what I remember doing. Make sure to backup the database and make a copy of the epo directory too.

1. Read through the EPO 4.0 setup guide very carefully. When I setup EPO when it first came out there was a glitch that would stop the installation if you used windows authentication to your SQL and the password you used had complex characters. This can be identified in step 2 for testing if its going to happen. Also look at what products are supported by EPO 4 and which are not. See if you are using any of them that are not. If you are then you need to see if there are newer version that you need to import and distribute in EPO after the installation, if you dont need them remove from epo prior to upgrading. Do you use Rogue sensors? The old version sensors will not work and there is not an upgrade path, so you should remove the old ones first, plan on redistributing sensors.

2. First thing I would do is to test the migration on a vmware setup. Load epo 3.6 on a vmware box, load sql on the vmware box and attach a backup of your database. Point the 3.6 server to the database and make sure you can sign in and see hosts, reports, etc. Test the upgrade to make sure all is well there and indentify any problems.

3. Upgrade to EPO 4.0. Make sure if it asks you to create an administrators account you remember it and the password. forgetting will put a show stopper on the project real quick. Perhaps using a simple password intially until you can get in after the install is succesful and change it.

4. Where are all of my events? This freaked me out when doing the upgrade. There is a task you run to import the old events into EPO 4.0. They are not in EPO 4.0 by default after the upgrade.

4. If upgrade goes well I would suggest upgrading to at least sql 2005 after the installation. (you might be able to do before the upgrade you would just need to make sure you change the database to be in compatibility mode)


Is the SQL hosting anything except the epo instance? That adds some more fun. Have you played with EPO 4.0 yet and got fimiliar with it. In the testing phase I mentioned if you can setup vmware with a copy of your database you can premake most of your reports, export them and just import them when you are ready to go live.
More McAfee Tools to Help You

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community