x

Microsoft Upgrade Advisor with SQL SERVER 2008 Error

Hello ,

I was tring to use Microsoft Upgrade Advisor with SQL SERVER 2008

clicked on :-

Launch Upgrade Advisor Analysis Wizard

after giving Instance name and sa Authentication its not going ahead.

Im getting below Error :-

SQL Server version: 10.00.1600 is not supported by this release of Upgrade Advisor, only SQL2000 or SQL2005 is supported.

Please let me knw how to resolve this

Thanks Naina

more ▼

asked Apr 08, 2010 at 07:16 AM in Default

Naina gravatar image

Naina
63 12 13 14

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

2 answers: sort oldest

The Upgrade Advisor checks whether an earlier version of SQL Server will upgrade successfully to 2008. You're already on 2008 so there's no need to run it.

more ▼

answered Apr 08, 2010 at 07:25 AM

David Wimbush gravatar image

David Wimbush
4.9k 28 30 33

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

As the error says, the upgrade advisor wont work on a SQL 2008 instance. You need to give it the details of either a 2000 or 2005 SQL server that you want to analyse before upgrading it to SQL 2008. It will then diagnose potential issues for you to handle before, during or after your upgrade.

more ▼

answered Apr 08, 2010 at 07:30 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.4k 75 78 108

(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:

x1834
x715
x68

asked: Apr 08, 2010 at 07:16 AM

Seen: 2566 times

Last Updated: Apr 08, 2010 at 07:40 AM