Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Isse with SQL server 2005 Upgrade Advisor Expand / Collapse
Author
Message
Posted Monday, July 20, 2009 5:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 2, 2014 2:41 AM
Points: 72, Visits: 264
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
Posted Tuesday, July 21, 2009 5:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 2, 2014 2:41 AM
Points: 72, Visits: 264
Hellooooo...

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

Thanks,

Arshad
Post #756464
Posted Tuesday, July 21, 2009 7:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, July 21, 2009 8:16 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 2, 2014 2:41 AM
Points: 72, Visits: 264
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 (11 views, 1.35 MB)
Post #756613
Posted Tuesday, July 21, 2009 6:11 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, July 21, 2009 6:45 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 2, 2014 2:41 AM
Points: 72, Visits: 264
Thanks for info. but i can't find upgrade analyser on microsoft site. could you please provide any links

Thanks
Post #757101
Posted Wednesday, July 22, 2009 5:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Wednesday, July 22, 2009 5:58 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 2, 2014 2:41 AM
Points: 72, Visits: 264
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....

Any idea whats going on here?

Thanks
Post #757326
Posted Wednesday, July 22, 2009 6:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Wednesday, July 22, 2009 6:13 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 2, 2014 2:41 AM
Points: 72, Visits: 264
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 »

Add to briefcase 12»»

Permissions Expand / Collapse