Reporting Services Database

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

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

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

  • 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.

  • 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

  • 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

  • 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.

  • 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.

  • 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

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

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