Installing 2008 R2

Question

Installing 2008 R2

SQL_Surfer

SSCrazy Eights

Points: 8275
More actions
November 20, 2011 at 10:05 am

#246636

We have SQL server 2008 running on our Windows 2003 R2 Enterprise x64 Edition. We have many SSIS packages running on it and some replication services (some data gets replicated from other server to this server). We would like to install 2008 R2 on it and like to know what kind of things we need to consider?
For e.g, will the SSIS packages in 2008 work in R2 without any upgrade?
What would be the best strategy that I need to follow. I am kind of new to this game and detail instruction would be appreciated including backup of user/system databases and all.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

jnuqui Default port Points: 1475 More actions · Answer 1

as per your story.. your not migrating from an TOO earlier version of SQL server(eg. 07, 2000, 2005) so there will be not so much problem about this.

BUT! if your using SQL server 2008 evaluation edition, we had an error before regarding versions when restoring our backups from evaluation one to a standard one so this will be an issue.

here's a link for you to identify whats new in R2 if your upgrading from a standard one.

http://msdn.microsoft.com/en-us/library/bb500435(SQL.105).aspx

cheers! 😀

===============================================================

"lets do amazing" our company motto..

Devendrakumar Shirbad SSC-Forever Points: 42493 More actions · Answer 2

Planning a SQL Server Installation

http://msdn.microsoft.com/en-us/library/bb500442.aspx

How to: Install SQL Server 2008 R2 (Setup)

http://msdn.microsoft.com/en-us/library/ms143219.aspx

How to: Upgrade to SQL Server 2008 R2 (Setup)

http://msdn.microsoft.com/en-us/library/ms144267.aspx

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 3

The "what's new" page for SSIS in 2008R2: http://msdn.microsoft.com/en-us/library/bb522534.aspx

Only the ADO.NET destination has changed, so I don't really expect problems when upgrading from 2008 to R2 for SSIS.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQL_Surfer SSCrazy Eights Points: 8275 More actions · Answer 4

I decided to first install R2 on test instead of aiming directly at production. Test server is bit different. Its running SQL SERVER 2008 SP2 on Windows 7 SP 1. I am trying to install the developer edition of R2 on it. But when I click on setup100.exe

I have attached the error I am getting. What is the exe do I need to run? I was looking for setup.exe but I couldn't find it. I am trying to install x64 version.

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 5

I have setup.exe on my CDROM of SQL Server 2008R2. Don't go in the x64 or x86 folders, just stay at the root folder.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQL_Surfer SSCrazy Eights Points: 8275 More actions · Answer 6

Thanks. Once I install R2, do I need to upgrade my BIDS too? Or the older BIDS work? I have VS2008.

Possinator Hall of Fame Points: 3402 More actions · Answer 7

just to consider - you won't be able to open reports created in old bids with 2008 r2 bids. different namespace.

[font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]

SQL_Surfer SSCrazy Eights Points: 8275 More actions · Answer 8

We don't use Reporting Services. Just SSIS. My question is, when I migrate to R2, will the BIDS R2 automatically gets migrated as well? Or do I need to migrate BIDS seperately?

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 9

For SSIS, there isn't really a change between 2008 and 2008R2 (just a small one in ADO.NET connection manager if I'm not mistaken). So if select BIDS during the install of R2, it will "upgrade" nicely. (but you practically won't see any difference)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQL_Surfer SSCrazy Eights Points: 8275 More actions · Answer 10

I am in the middle of upgrading 2008 to R2. And I am gettting the following error message.

Use the Reporting Services Configuration tool to configure the database source name(DSN) and connect to the database

We don't use Reporting Services but I do see ReportServer database. Any idea how to bypass this message and proceed to Upgrade?

Thanks

Devendrakumar Shirbad SSC-Forever Points: 42493 More actions · Answer 11

SQL_Surfer (12/10/2011)
I am in the middle of upgrading 2008 to R2. And I am gettting the following error message.
Use the Reporting Services Configuration tool to configure the database source name(DSN) and connect to the database
We don't use Reporting Services but I do see ReportServer database. Any idea how to bypass this message and proceed to Upgrade?
Thanks

Please follow the link.

Upgrading from SQL server 2005 to 2008 and get an error message

http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/dd5b9ca6-6c8a-44a7-a86b-43e77e6dd059

SQL_Surfer SSCrazy Eights Points: 8275 More actions · Answer 12

Yeah. Uninstalling Reporting services helped. Thanks!