January 31, 2019 at 1:04 am
Hi,
In server already SQL Server 2017 Enterprise Core Edition is installed.
Also SSRS express edition is installed. While configguring the SSRS getting beow error.d be the cause?
Cannot create a connection to data source 'Mydatasource'. The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database" is not supported in this edition of Reporting Services.
When i want to install newly SSRS again its asking me to dopwnload from microsoft and only 3 of them available (express,evaluation and developer edition)
Anyone please suggest me what i need to do? which SSRS edition i need to install when SQL Core enterprise edition is installed?
What is the difference between enterprise and enterprise core edition?
Also i need to install power BI in same server and later i need to integrate both SSRS and POWER BI.. How to do that?
Do i need to configure SSRS and power bi seperately? or any other procedure to configure and integrate both at once?
It is little urgent.Please suggest how to proceed?
Thanks...
January 31, 2019 at 2:13 am
If you have Enterprise edition of SQL Server, you want to install SSRS Enterprise. That's part of the SQL Server installer; when installing the product you choose which services to install which includes SSRS. It doesn't have a separate installer.
Use the same installer you used to install SQL Server 2017 Enterprise, however, this time ensure you select SSRS (and don't install a second instance of SQL Server's Data Engine).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply