Isse with SQL server 2005 Upgrade Advisor

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Isse with SQL server 2005 Upgrade Advisor

11 posts, Page 1 of 2

1 2 »»

Isse with SQL server 2005 Upgrade Advisor

Rate Topic

Display Mode

Topic Options

Author

Message

SteadfastDBA

Posted Monday, July 20, 2009 5:33 AM

Valued Member

Group: General Forum Members
Last Login: Saturday, May 18, 2013 5:35 PM
Points: 71, Visits: 238

Hi,

I am having problem in running the sql server 2005 upgrade advisor wizard.

I keep getting a message as "export server must be running Microsoft SQL Server 6.5"

But the strange thing is i am running 2005 upgrade advisor then why it is asking me 6.5?

I have a SQL server 2000 standard edition and SQL server 2005 Developer edition running on this machine.

I just want to run this to see what suggestions the upgrade advisor comes up on my 2000 databases for moving to 2005 environment.

Any help will be greatly appretiated.

Thanks

Arshad

Post #755668

SteadfastDBA

Posted Tuesday, July 21, 2009 5:06 AM

Valued Member

Group: General Forum Members
Last Login: Saturday, May 18, 2013 5:35 PM
Points: 71, Visits: 238

Hellooooo...

Does anyone know anything about it? Has anyone experienced this before??

Thanks,

Arshad

Post #756464

David Sorauer

Posted Tuesday, July 21, 2009 7:54 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 11:27 PM
Points: 170, Visits: 553

You sure it's pointing at the correct instance?

You could try the SQL 2008 advisor (as it will identify the same issues as SQL 2005 advisor).

Post #756590

SteadfastDBA

Posted Tuesday, July 21, 2009 8:16 AM

Valued Member

Group: General Forum Members
Last Login: Saturday, May 18, 2013 5:35 PM
Points: 71, Visits: 238

Thanks for the reply.

What do you mean the correct instance?

When i run the updrade adviser it tells me the following...

I have attached the screen shot of the error message i am getting. Please see the attachment...

For your info, i am running the upgrade advisor from a machine which has got 2000 and 2005 instances installed.

Thanks.

A

Post Attachments

error.bmp (10 views, 1.35 MB)

Post #756613

David Sorauer

Posted Tuesday, July 21, 2009 6:11 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 11:27 PM
Points: 170, Visits: 553

You are running the wrong tool :)

That is the upgrade wizard rather than upgrade analyzer. If I remember correctly, designed to upgrade from 6.5 or 7 to SQL 2000.

You must download the analyzer from microsoft website (it's not included in SQL 2000 installation).

Post #757088

SteadfastDBA

Posted Tuesday, July 21, 2009 6:45 PM

Valued Member

Group: General Forum Members
Last Login: Saturday, May 18, 2013 5:35 PM
Points: 71, Visits: 238

Thanks for info. but i can't find upgrade analyser on microsoft site. could you please provide any links

Thanks

Post #757101

David Sorauer

Posted Wednesday, July 22, 2009 5:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 11:27 PM
Points: 170, Visits: 553

You had the name right, wrong tool :)

http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

Post #757311

SteadfastDBA

Posted Wednesday, July 22, 2009 5:58 AM

Valued Member

Group: General Forum Members
Last Login: Saturday, May 18, 2013 5:35 PM
Points: 71, Visits: 238

Hi David,

Thanks for the link but surprisingly, i have downloaded the setup file earlier from the same place. It does say the SQL server 2005 upgrade advisor tool but when i download and run it comes up with the same error message.... Sad

Any idea whats going on here?

Thanks

Post #757326

David Sorauer

Posted Wednesday, July 22, 2009 6:05 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 11:27 PM
Points: 170, Visits: 553

It looks like it is running the wrong application. I'm not sure why.

I would try and install on a workstation (just ensure you have admin rights on the destination server) and run the scan remotely (or you can run the scan from another server).

Post #757334

SteadfastDBA

Posted Wednesday, July 22, 2009 6:13 AM

Valued Member

Group: General Forum Members
Last Login: Saturday, May 18, 2013 5:35 PM
Points: 71, Visits: 238

Thanks for the reply. I do have the administrative rights on the box i am running this tool. I have also tried on the other machines as well but no joy.

Please let me know wether it does the same when you run it on your machine.

Thanks

Post #757343

« Prev Topic | Next Topic »

11 posts, Page 1 of 2

1 2 »»

Permissions