SQL Server 2008 R2 SP3

Question

We are trying to alleviate an issue we're having with Reporting Services and printing. Apparently this issue has been resolved in CU2 for SP2.

We decided to just instead to ugrade to SP3 - but when searching for SP3 for R2, I'm only coming up with SP3 for SQL Server 2008 - there is no designation for R2.

Is the current SP3 also applicable to R2?

Thanks!

---

A. M. Robinson

Answer 1

SQL 2008 R2 has the following service packs and cumulative updates available:

RTM - CU #13

SP1 - CU #6

you need to use the right CU matching your service pack level

Answer 2

We are currently on SP2 for SQL Server 2008 R2...

---

A. M. Robinson

Answer 3

Hi,

Please check the following link and you will get answer for all SP and CU ,which are already released.

http://sqlserverbuilds.blogspot.in/

---

Please click "Propose As Answer" if a post solves your problem. OR "Vote As Helpful" if a post has been useful to you. Thanks, Debasish Mohanty Blog:http://sqlcodebank.blogspot.com

Answer 4

Hi,

There is no SQL 2008 R2 SP2. The latest and greatest is SP1 CU6

http://support.microsoft.com/kb/2567616

Please execute below code to check the SQL version on your server just to identify your server

select @@servername

---

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 5

Don't you mean select @@version? Your query just tells me what the name of my server is

---

A. M. Robinson

Answer 6

We are currently experiencing the issue outlined in this post:

MSDN Issue

This issue is supposedly in SQL Server 2008 SP2, but we're seeing it in SQL Server 2008 R2 SP1.

Has anyone seen this issue? IF not, since the remedy in this issue explicitly talks about SQL Server 2008 and not R2, how do I go about gettign this issure resolved? Would CU6 address this??









---

A. M. Robinson

Answer 7

my bad. it is 

select @@version

---

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 8

Hi Ansonee,

Please run select @@version to verify the version of your instance first as Javier Villegas mentioned.

>> SQL Server 2008 SP2, but we're seeing it in SQL Server 2008 R2 SP1

As you mentioned, you are running SQL Server R2 SP1, if you want to install a hotfix the least one is Cumulative update package 6 for SQL Server 2008 R2 Service Pack 1, you can download from here.

According to the link you provided, seems this issue is related to Report Services so please link to Report service forum for further help. 

---

Regards,
Amber zhang
TechNet Subscriber Support

If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Answer 9

Yes...this link is related to Reorting Services...but the resolution outlined in the Reorting Services forum has to do with the version of SQL Server and updates / Service Packs.

The thread in the Reporting Servoces forum has gone dead...and it also only addresses SQL Server 2008 RTM - not R2.

I'm hoing someone in this forum is familiar with this issue and what the resolution is/was...

---

A. M. Robinson

Answer 10

why not just install latest SP and CU and see if the problem still exists?

(the other way is to read through release notes of SP and CU to see if the bug is fixed but the first way is definitively easier).

install SP1 & CU6 if you're using SQL Server 2008 R2

install SP3 & CU4 if you're using SQL Server 2008

Answer 11

I have installed the latest CU and yes the problem still exists...

---

A. M. Robinson

Answer 12

...and while just installing whatever the latest CU or SP is would be easier, our shop has a poicy that any patch/service pack/CU needs to be proven free of any issues/bugs. We have installed SP's just because they were the latest and ended u introducing issues that were not there before.

We want to "vet" any patch/service pack before just sticking it onto a box...

---

A. M. Robinson

Answer 13

Question answered. See below link:

Credentials When Trying to Print From Report Manager

---

A. M. Robinson

Answer 14

I download SP2 for SQL 2008 R2 from the following link

http://www.microsoft.com/en-us/download/details.aspx?id=29848

after installingtheSP,and run

select @@version

---

the result is

Microsoft SQL Server 2008 R2 (SP2) - 10.50.3720.0 (X64)  

Julio Garrido A.

Answer 15

The post by ansonee is not an actual fix, so I don't know why it's marked as an answer.  What I and everyone else on this board are simply trying to do is allow clients to install the ActiveX control to allow printing from SSRS without UAC popping up and requesting admin credentials.