Upgrading SQL Server 2005 Reports to SQL Server 2008 R2.

Last Post 19 Jan 2011 07:19 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
KPSQL
New Member
New Member

--
18 Jan 2011 11:20 AM
Hi,

We are upgrading from SQL Server 2005 (SP3) to SQL Server 2008 R2.

I did the following:

  1. Ran the SQL Server Upgrade Advisor and took care of the issues.
  2. Moved the Logins from SQL Server 2005 to SQL Server 2008 Server.
  3. Backed up the databases from SQL Server 2005 and restored them to SQL Server 2008.

So far so good...

My questions:

  1. We have SQL Server 2005 (SSRS) reports on SQL Server 2005. Should I open these reports in BIDS 2005 or BIDS 2008 in order to apply them ontu the SQL Server 2008 R2 Server?
  2. We have SQL Server Integration Packages (SSIS) in SQL Server 2005. Should I open these packages in BIDS 2005 or BIDS 2008 in order to apply them ontu the SQL Server 2008 R2 Server?
  3. I understand that SQL Server 2008 R2 SSRS does not use IIS. So how does one configure IIS on SQL Server 2008?

Any help, tips or pointers appreciated.

Thanks

rm
New Member
New Member

--
19 Jan 2011 07:19 AM
Use bids2k8 if you like to deploy reports and ssisi packages to rs2k8 and ssis2k8.


Acceptable Use Policy
---