September 21, 2007 at 12:21 am
Hi All,
I have been configuring reporting services in Microsoft SQL Server 2005 Express Edition. I m not able to create a database
i m using following
Server name : (LOCAL)\SQLEXPRESS here the connection work fine.
Database Name : here when click on new button its pops up new window where i have taken default Database Name : ReportServer
after all in main panel when i click on apply button its showing me in Task Status
Number of errors:0
Verifying Database Edition
The feature:"using other editions of sql server for report data sources and/or the report server database" is not
supported in this edition of Reporting services
and when i try to open the report in browser
it shows me
Error
The report server cannot open a connection to the report server database.
A connection to the database is required for all requests and processing.
(rsReportServerDatabaseUnavailable) Get Online Help Login failed for user 'LOHITH_BN\ASPNET'.
Home
Can anybody help on this please
September 21, 2007 at 2:10 am
From BOL:
The following list highlights the major SQL Server 2005 components that are not supported in SQL Server Express:
Markus
[font="Verdana"]Markus Bohse[/font]
September 21, 2007 at 2:18 am
Hi Markus,
Thank you very much for your quick reply. Can you please send me any link to know about on same.
Lohith
September 21, 2007 at 2:38 am
As I wrote before it's in BOL. Just look for SQL express features.
Markus
[font="Verdana"]Markus Bohse[/font]
September 21, 2007 at 8:55 am
Actually there is a version of Express with Reporting services but it require a separate component called the ToolKit. The Fulltext feature was also added reluctantly after developers added it by code but it does not work in user instance and in server instance you have to go into configuration manager to enable it. The Express Advanced require uninstall of standard Express but it comes with all features on the relational end except the agent and the toolkit gives you reporting services. Try the link below for details. Hope this helps.
http://msdn2.microsoft.com/en-us/express/bb410792.aspx
Kind regards,
Gift Peddie
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply