Error while running Upgrade Advisor at Sql Server 2000

Thanks Fatherjack..Thanks David

When i was trying to Install the Upgrade Advisor at Sql Server 2000 to test the Migration to Sql Server 2008 ..... im getting below error.

This intallation package cannot be installed by the windows installer service. You must install a windows service pack that contains a newer version of the window installer services.

Please let me know how to resolve this.

Thanks Naina

asked Apr 09 '10 at 04:24 AM in Default

Naina
63 ● 12 ● 12 ● 14

(comments are locked)

3 answers:

The resolution is kind of detailed in the error:

Install a windows service pack that contains a newer version of the window installer services.

Without knowing what version of Windows you're on, it's hard to tell you which one to get - but just make sure your Windows O/S is on the latest version, or install the upgrade advisor on a machine with a newer O/S version.

answered Apr 09 '10 at 04:51 AM

Matt Whitfield ♦♦
29.2k ● 56 ● 63 ● 87

(comments are locked)

The prerequisites for the upgrade advisor are listed here : http://msdn.microsoft.com/en-us/library/ms144256.aspx. It doesnt need to be installed on a server, it can run from your own PC, so long as it can access the SQL Server over a network connection it will be OK.

This is an odd error to be getting as your previous question was about getting it to collect data from a server. For that error it must have been installed ... ? Was there a reason to move it from the computer you had it installed on?

answered Apr 09 '10 at 05:32 AM

Fatherjack ♦♦
38.8k ● 55 ● 69 ● 104