Wednesday, March 28, 2012

install of sql 2005 RS on SQL 2000 machine

Hi,
This should be a quick for you. I am wanting to install SQL 2005 on the same
W2003 Server as SQL 2000. Your newsgroups to date show that this is possible
and that SQL 2005 should be set up as a Named Instance.
My quesion relates to the install of RS2005. When SQL 2005 is setup and I
now want to install RS2005 does it install as an Upgrade option for RS2000? I
do not wish to keep RS2000 so an upgrade is preferable. Or is RS2000 left
alone and must be unistalled separately.
Any experiences would be appreciated.
Thanks.
--
Regards,
AlanHi Alan,
Thank you for your posting!
According to the SQL Books online, if you still want to use your SQL 2000
and run it as the default instance, you need to migrate Reporting Services
2000 to Reporting Services 2005. You could not upgrade Reporting Services
2000 directly because this will upgrade the Reporting Services Database and
will force you to upgrade your SQL 2000 instance to SQL 2005.
Here is an article for your reference:
Migrating Reporting Services
http://msdn2.microsoft.com/en-us/library/ms143724(d=ide).aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Perfect... as usual.
The web link you provided was exactly the info I was chasing.
Thanks.
--
Regards,
Alan
"Wei Lu" wrote:
> Hi Alan,
> Thank you for your posting!
> According to the SQL Books online, if you still want to use your SQL 2000
> and run it as the default instance, you need to migrate Reporting Services
> 2000 to Reporting Services 2005. You could not upgrade Reporting Services
> 2000 directly because this will upgrade the Reporting Services Database and
> will force you to upgrade your SQL 2000 instance to SQL 2005.
> Here is an article for your reference:
> Migrating Reporting Services
> http://msdn2.microsoft.com/en-us/library/ms143724(d=ide).aspx
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Alan,
Thank you for the reply and glad to know that the information is helpful!
If you have any further assistance, please feel free to let me know!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment