topic Re: SQL Server Needed for Report server info in Report Server

SQL Server Needed for Report server info

Anonymous — Tue, 08 Oct 2019 08:08:32 GMT

We are getting Premium capacity so want to utilise the Power BI report server license that comes with P1 to offer both a cloud and on-premise solution. I'm a bit confused as to what SQL server version I have to install to host the report server database. Surely we don't have to buy an additional license for SQL server to enable users to install report server. If this isn't the case what so I need to install before the report server install.

thanks.

Re: SQL Server Needed for Report server info

RobThrive — Tue, 08 Oct 2019 09:37:28 GMT

Anything from SQL Server 2012 should work for you.
https://docs.microsoft.com/en-gb/power-bi/report-server/system-requirements

Any SQL server should need a license. Your premium license provides you a license to Report Server, but not SQL Server as far as I know.

Re: SQL Server Needed for Report server info

Anonymous — Tue, 08 Oct 2019 09:39:09 GMT

Can we run this under a developer license (i.e. free) or do wee need to purchase something else?

Re: SQL Server Needed for Report server info

RobThrive — Tue, 08 Oct 2019 14:28:25 GMT

If it is for a development environment then yes you can se dev license. If it is in prod you'll want to license the install.

Re: SQL Server Needed for Report server info

Anonymous — Mon, 04 Nov 2019 11:04:45 GMT

I take it then we can just get away with a standard SQL server license for production. It seems a bit overkill installing an enterprise license just to host two report server databases.

Re: SQL Server Needed for Report server info

Anonymous — Fri, 08 Nov 2019 14:36:47 GMT

If we get PBI report server through either premium capacity or SA can we use SQL express to host the database?