SSRS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Strategies » SSRS

SSRS

Rate Topic

Display Mode

Topic Options

Author

Message

ravisamigo

Posted Thursday, March 29, 2012 11:33 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:11 PM
Points: 250, Visits: 706

Dear All,

I have few queries on SSRS.

Does SQLServer2008 R2 developer edition Supports the SSRS?

Can we update SQLServer 2005 Reporting Services to SQL 2008?

It's quite urgent.

Please advise me.

Thanks and Regards,
Ravichandra.

Post #1275525

Henrico Bekker

Posted Thursday, March 29, 2012 11:40 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

Does SQLServer2008 R2 Supports the SSRS?

Can we update SQLServer 2005 Reporting Services to SQL 2008?

1. Yes
2. Yes - Links below on help

http://technet.microsoft.com/en-us/library/ms143724.aspx
http://technet.microsoft.com/en-us/library/ms143747(v=sql.105).aspx
http://www.sqlservercentral.com/Forums/Topic708977-147-2.aspx#bm1173228

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #1275526

ravisamigo

Posted Thursday, March 29, 2012 11:50 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:11 PM
Points: 250, Visits: 706

Thanks Henrico.

My query is, Does SQLServer 2008 R2 Developer edition Supports the SSRS?

Post #1275529

Henrico Bekker

Posted Friday, March 30, 2012 12:01 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

Does SQLServer 2008 R2 Developer edition Supports the SSRS?

Yes it does.

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #1275532

ravisamigo

Posted Friday, March 30, 2012 1:08 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:11 PM
Points: 250, Visits: 706

Thanks Henrico for your information.

Please advise me on the below.

Can we apply one licence key for more than one SQLServer2008 R2 developer installation?

or

Can we apply one licence key for only one SQLServer2008 R2 developer installation?

Post #1275549

Henrico Bekker

Posted Friday, March 30, 2012 1:14 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

Can we apply one licence key for more than one SQLServer2008 R2 developer installation?

or

Can we apply one licence key for only one SQLServer2008 R2 developer installation?

I am not a licensing expert, but as far as I know, you use one license per installation, meaning if you install the DEV Suite on a server, one license key will suffice.

I would advise you to get a second opinion on the actual cost per server install, with regards to cost per CPU, EA agreements etc..

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #1275554

anthony.green

Posted Friday, March 30, 2012 1:15 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

ravisamigo (3/30/2012)

Developer edition is on a per user basis so you need to ensure that you have enough licences for your users or have volume licensing or each user has an MSDN license.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1275556

ravisamigo

Posted Friday, March 30, 2012 1:59 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:11 PM
Points: 250, Visits: 706

Thanks Henrico for your help.

How to take the backup of SQLServer2005 SSRS before upgrading to SQLServer 2008 R2?

What are all the things needs to be take backup apart from the encryption keys,ReportServer,ReportServerTempdb?

It would be grateful if you advice me on this.

Thanks.

Post #1275582

Henrico Bekker

Posted Friday, March 30, 2012 2:12 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

If you read the documentation on the link I sent, you will see the upgrade procedure and possible issues you might encounter, and how to avoid them.

I dont want to post a step by step, as it might not be applicable to your setup.

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #1275586

« Prev Topic | Next Topic »

Permissions