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

Upgrading ePO 4.5 to 4.6 cannot find SQL 2005 SP3

New customer and throughly frustrated with ePO, the install alone did not follow the instructions.  I got 4.5 installed and working, I want to install 4.6 before I start creating frame packages and pushing software.

Problem is when I run the setup it fails with no SQL 2005 SP3 installed and it is installed otherwise 4.5 wouldn't run.

I've tried stopping the services and running the install same problem.

Any suggestions would be greatly appreciated.

8 Replies
ajacobs
Level 12
Report Inappropriate Content
Message 2 of 9

Re: Upgrading ePO 4.5 to 4.6 cannot find SQL 2005 SP3

Moved to our ePO area for better attention by a product expert.

kes
Level 7
Report Inappropriate Content
Message 3 of 9

Re: Upgrading ePO 4.5 to 4.6 cannot find SQL 2005 SP3

Thank you, I'd love to get past this and move on to using ePO.

kes
Level 7
Report Inappropriate Content
Message 4 of 9

Re: Upgrading ePO 4.5 to 4.6 cannot find SQL 2005 SP3

Just ran SQL2005 SP4 with services stopped and get the same error.

ePO46Fail.jpg

McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 5 of 9

Re: Upgrading ePO 4.5 to 4.6 cannot find SQL 2005 SP3

Hi...

The SQL services need to be running when you do the install (as do the ePO services if you're doing an upgrade.)

Do you get the same message if you run the install with the services started?

Also, just to clarify, are you trying to upgrade from 4.5 to 4.6, or do a clean install of 4.6?

Thanks -

Joe

kes
Level 7
Report Inappropriate Content
Message 6 of 9

Re: Upgrading ePO 4.5 to 4.6 cannot find SQL 2005 SP3

This would be an upgrade.  4.5 is working, I have done the install with services running and then tried stopping the service as mentioned in other threads.  Results are the same SQL2005 SP3 not found.  I went ahead and ran SP4 for SQL2005 and that made no difference, same error, SQL2005 SP3 or later not found.

Only reason I'm doing the upgrade is that this is our first time using the product and the install was difficult.  Once it was up and running I figure why build on it since I'm going to have to upgrade eventually anyways, do the upgrade now since I have no data to migrate yet.

kes
Level 7
Report Inappropriate Content
Message 7 of 9

Re: Upgrading ePO 4.5 to 4.6 cannot find SQL 2005 SP3

Still a problem....

No assist from McAfee...

SergeM
Level 9
Report Inappropriate Content
Message 8 of 9

Re: Upgrading ePO 4.5 to 4.6 cannot find SQL 2005 SP3

Hi,

I'm trying to understand your issue here.

  • You installed ePO 4.5 but had difficulty during the initial install.
  • ePO 4.5 works and can work with the DB.
  • You haven't started deploying any McAfee Agents on endpoint systems yet.
  • You tried to upgrade from ePO 4.5 to ePO 4.6 and now it doesn't see the SQL DB or Server any more.
  • Did the upgrade work or did it fail ?

Is that correct ?

  • Is the SQL DB (MS SQL 2005 unless I'm wrong) on the same server as the ePO server ?
  • What server OS are you using 2003 or 2008 ?
  • Could it be there's a firewall between the DB and ePO server(s) ?  (including 2008's local firewall)
  • Could you describe the difficulties you had during the initial ePO install ?
  • Can you presently connect in the ePO console ?  (I'd assume not if ePO can't access the DB)
  • Can you connect to the DB instance using MS SQL DB tools ?

I hope we can help find the issue here.

Serge

brentil
Level 12
Report Inappropriate Content
Message 9 of 9

Re: Upgrading ePO 4.5 to 4.6 cannot find SQL 2005 SP3

Check to make sure what port your SQL server is running on, if it's not the standard one you need to add ,PORT after the name.

I would use the SQL Manager tools to check to see what version the SQL server thinks it is. 

Connect to the instance of SQL Server, and then run the following query:

Select @@version


This is the list of version #s for MS-SQL 2005.

SQL Server 2005 version information

The following table lists the major releases of SQL Server 2005.

ReleaseProduct version
SQL Server 2005 Service Pack 49.00.5000.00
SQL Server 2005 Service Pack 39.00.4035
SQL Server 2005 Service Pack 29.00.3042
SQL Server 2005 Service Pack 19.00.2047
SQL Server 2005 RTM9.00.1399

You can find all of this information from thsi article; http://support.microsoft.com/kb/321185