Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KPSQLServerCentralcom
Starting Member
2 Posts |
 Posted - 2011-01-18 : 14:37:12
|
| 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 |
|
|
|
|
|
Moving SQL Server 2005 SSRS and SSIS to SQL Server