SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Isse with SQL server 2005 Upgrade Advisor


Isse with SQL server 2005 Upgrade Advisor

Author
Message
SteadfastDBA
SteadfastDBA
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 312
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
SteadfastDBA
SteadfastDBA
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 312
Hellooooo...

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

Thanks,

Arshad
David Sorauer
David Sorauer
SSC Veteran
SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)

Group: General Forum Members
Points: 292 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).
SteadfastDBA
SteadfastDBA
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 312
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
Attachments
error.bmp (22 views, 1.00 MB)
David Sorauer
David Sorauer
SSC Veteran
SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)

Group: General Forum Members
Points: 292 Visits: 553
You are running the wrong tool Smile

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).
SteadfastDBA
SteadfastDBA
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 312
Thanks for info. but i can't find upgrade analyser on microsoft site. could you please provide any links

Thanks
David Sorauer
David Sorauer
SSC Veteran
SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)

Group: General Forum Members
Points: 292 Visits: 553
You had the name right, wrong tool Smile

http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en
SteadfastDBA
SteadfastDBA
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 312
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
David Sorauer
David Sorauer
SSC Veteran
SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)

Group: General Forum Members
Points: 292 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).
SteadfastDBA
SteadfastDBA
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 312
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search