Reporting Services Database

Question

Post reply

Reporting Services Database

Steve Jones - SSC Editor

SSC Guru

Points: 736211
More actions
April 19, 2009 at 9:14 am

#63628

Comments posted to this topic are about the item Reporting Services Database

Viewing 8 posts - 1 through 7 (of 7 total)

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

Pei Zhu-415513 SSCarpal Tunnel Points: 4040 More actions · Answer 1

Not sure what did you mean "what edition of database should you have".

Databases do not have edition. sql server may have edition.

SanjayAttray SSChampion Points: 13157 More actions · Answer 2

Pei Zhu (4/20/2009)
Not sure what did you mean "what edition of database should you have".
Databases do not have edition. sql server may have edition.

You are right. Databases could have versions ( like 80, 90 etc ) but not editions.

SQL DBA.

Jamie-2229 SSCrazy Eights Points: 8156 More actions · Answer 3

In SQL Server 2008, if you have a Reporting Services report server using the Express edition, what edition of database should you have?

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

When creating a report server database, be aware that not all editions of SQL Server can be used to host the database. The following table shows you which editions of the Database Engine you can use for specific editions of Reporting Services.

Jamie

Josh Turner-440822 SSCrazy Points: 2048 More actions · Answer 4

BOL lists Reporting Services as only being available on Enterprise, Standard, Workgroup, Web, and Express Advanced, not for regular Express edition. So shouldn't the You cannot have an Express edition Reporting Server option be correct?

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

Cliff Jones SSChampion Points: 10547 More actions · Answer 5

Seems to me that the answer should have been SQL Server Express with Advanced Services but I too was confused by the "edition" of the database.

Robert Frasca SSCertifiable Points: 6026 More actions · Answer 6

The answer given is incorrect. SQL Server Express does not support reporting services. SQL Server Express Advanced edition does.

"Beliefs" get in the way of learning.

Kit G SSCrazy Points: 2888 More actions · Answer 7

This question was worded improperly. Per this article which compares what SQL Express can and cannot do SQL Server Express Features, Resporting Services is not supported by SQL Server Express.

SQL Server Express with Advanced Services Features is a different application from just plain SQL Server Express. As the question stated only "Express Edition", the question needs fixing.

-- Kit