April 19, 2009 at 9:14 am
Comments posted to this topic are about the item Reporting Services Database
April 20, 2009 at 8:53 am
Not sure what did you mean "what edition of database should you have".
Databases do not have edition. sql server may have edition.
April 20, 2009 at 9:02 am
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.
April 20, 2009 at 9:17 am
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
April 20, 2009 at 9:38 am
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?
April 20, 2009 at 10:03 am
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.
April 21, 2009 at 6:43 am
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.
April 21, 2009 at 9:55 am
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