x

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

more ▼

asked Apr 09, 2010 at 04:24 AM in Default

Naina gravatar image

Naina
63 13 13 14

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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.

more ▼

answered Apr 09, 2010 at 04:51 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

(comments are locked)
10|1200 characters needed characters left

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?

more ▼

answered Apr 09, 2010 at 05:32 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.7k 75 79 108

(comments are locked)
10|1200 characters needed characters left

Thanks Matt and Thanks Fatherjack.

im looking into prerequisites for Upgrade Advisor.

Thanks Naina

more ▼

answered Apr 09, 2010 at 08:47 AM

Naina gravatar image

Naina
63 13 13 14

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1840
x68

asked: Apr 09, 2010 at 04:24 AM

Seen: 2117 times

Last Updated: Apr 09, 2010 at 06:21 AM