Can we download SSRS 2017 to use with SQL Server 2016? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30UTC (7:30pm US/Eastern)SSRS 2016 on SQL Server 2014How to install downgrade of SQL Standard 2016 to Standard 2014SSRS reports broke after upgrading from 2014 to 2016SSRS 2016 Connect to SQL Server with Force Encryption EnabledSSRS 2016 Generates SQL Server log entry dailyHow to uninstall SQL Server 2014 Standard Edition without install media?SSRS 2017 reports having issues with IE 11?SQL Server Reporting Services 2017: Install Cumulative UpdateSQL Server Reporting Services 2017: Multiple InstancesSSRS 2016 on SQL Server 2014Upgrade SQL Server 2014 AG to SQL Server 2017 AG
AppleTVs create a chatty alternate WiFi network
C's equality operator on converted pointers
Most bit efficient text communication method?
What makes a man succeed?
Flash light on something
macOS: Name for app shortcut screen found by pinching with thumb and three fingers
What is an "asse" in Elizabethan English?
What does this say in Elvish?
Sliceness of knots
Antipodal Land Area Calculation
How do living politicians protect their readily obtainable signatures from misuse?
Where is the Data Import Wizard Error Log
What is the difference between a "ranged attack" and a "ranged weapon attack"?
How could we fake a moon landing now?
Why can't I install Tomboy in Ubuntu Mate 19.04?
How can I prevent/balance waiting and turtling as a response to cooldown mechanics
In musical terms, what properties are varied by the human voice to produce different words / syllables?
How often does castling occur in grandmaster games?
How to write capital alpha?
What does it mean that physics no longer uses mechanical models to describe phenomena?
Do I really need to have a message in a novel to appeal to readers?
Is multiple magic items in one inherently imbalanced?
Intuitive explanation of the rank-nullity theorem
Co-worker has annoying ringtone
Can we download SSRS 2017 to use with SQL Server 2016?
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30UTC (7:30pm US/Eastern)SSRS 2016 on SQL Server 2014How to install downgrade of SQL Standard 2016 to Standard 2014SSRS reports broke after upgrading from 2014 to 2016SSRS 2016 Connect to SQL Server with Force Encryption EnabledSSRS 2016 Generates SQL Server log entry dailyHow to uninstall SQL Server 2014 Standard Edition without install media?SSRS 2017 reports having issues with IE 11?SQL Server Reporting Services 2017: Install Cumulative UpdateSQL Server Reporting Services 2017: Multiple InstancesSSRS 2016 on SQL Server 2014Upgrade SQL Server 2014 AG to SQL Server 2017 AG
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
We are using our organization's SQL Server 2014 SP3 servers. (They also have 2016 SQL Servers, but we elected to skip 2016 and just move to the next SQL servers when they get installed.)
We have a need for the REST API access in SSRS 2017, so we would like to upgrade our current SSRS server to SSRS 2017.
The Windows server admin just set up a new/test SSRS server for us, but he used SSRS 2016, because that is the latest media that the organization has, and they are of the impression that we can only install SSRS for the SQL server version that we're using.
Am I correct in thinking that it should be possible for us to download (for free) and install SSRS 2017 and then point it to the existing 2016 SQL servers? Or do we need to purchase a license for SQL Server 2017 to be able to use SSRS 2017?
(This seems similar to existing question SSRS 2016 on SQL Server 2014, but that question and answer seem to focus on SQL Server Express, which is not our situation.)
sql-server sql-server-2016 ssrs upgrade ssrs-2017
asked Apr 15 at 12:37
MDDMDD
283
New contributor
MDD is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
We are using our organization's SQL Server 2014 SP3 servers. (They also have 2016 SQL Servers, but we elected to skip 2016 and just move to the next SQL servers when they get installed.)
We have a need for the REST API access in SSRS 2017, so we would like to upgrade our current SSRS server to SSRS 2017.
The Windows server admin just set up a new/test SSRS server for us, but he used SSRS 2016, because that is the latest media that the organization has, and they are of the impression that we can only install SSRS for the SQL server version that we're using.
Am I correct in thinking that it should be possible for us to download (for free) and install SSRS 2017 and then point it to the existing 2016 SQL servers? Or do we need to purchase a license for SQL Server 2017 to be able to use SSRS 2017?
(This seems similar to existing question SSRS 2016 on SQL Server 2014, but that question and answer seem to focus on SQL Server Express, which is not our situation.)
sql-server sql-server-2016 ssrs upgrade ssrs-2017
asked Apr 15 at 12:37
MDDMDD
283
New contributor
MDD is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1) talk to your Microsoft Licensing person to get an accurate answer about any licensing requirements you have. 2) SSRS is bundled with SQL Server, so if you have a license to that version of SQL Server then you can use that version of SSRS. 3) Typically you can downgrade your SQL without issues (i.e. you have license for 2017, but you can use that license on any lower version of SQL you want to use (YMMV, see point 1). 4) I think the SSRS service may need a matching SQL engine to host it's reportserver database, but your reports can of course point to anything you have drivers for.
– Jonathan Fite
Apr 15 at 14:09
add a comment |
We are using our organization's SQL Server 2014 SP3 servers. (They also have 2016 SQL Servers, but we elected to skip 2016 and just move to the next SQL servers when they get installed.)
We have a need for the REST API access in SSRS 2017, so we would like to upgrade our current SSRS server to SSRS 2017.
The Windows server admin just set up a new/test SSRS server for us, but he used SSRS 2016, because that is the latest media that the organization has, and they are of the impression that we can only install SSRS for the SQL server version that we're using.
Am I correct in thinking that it should be possible for us to download (for free) and install SSRS 2017 and then point it to the existing 2016 SQL servers? Or do we need to purchase a license for SQL Server 2017 to be able to use SSRS 2017?
(This seems similar to existing question SSRS 2016 on SQL Server 2014, but that question and answer seem to focus on SQL Server Express, which is not our situation.)
sql-server sql-server-2016 ssrs upgrade ssrs-2017
asked Apr 15 at 12:37
MDDMDD
283
New contributor
MDD is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
We are using our organization's SQL Server 2014 SP3 servers. (They also have 2016 SQL Servers, but we elected to skip 2016 and just move to the next SQL servers when they get installed.)
We have a need for the REST API access in SSRS 2017, so we would like to upgrade our current SSRS server to SSRS 2017.
The Windows server admin just set up a new/test SSRS server for us, but he used SSRS 2016, because that is the latest media that the organization has, and they are of the impression that we can only install SSRS for the SQL server version that we're using.
Am I correct in thinking that it should be possible for us to download (for free) and install SSRS 2017 and then point it to the existing 2016 SQL servers? Or do we need to purchase a license for SQL Server 2017 to be able to use SSRS 2017?
(This seems similar to existing question SSRS 2016 on SQL Server 2014, but that question and answer seem to focus on SQL Server Express, which is not our situation.)
sql-server sql-server-2016 ssrs upgrade ssrs-2017
sql-server sql-server-2016 ssrs upgrade ssrs-2017
asked Apr 15 at 12:37
MDDMDD
283
New contributor
MDD is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Apr 15 at 12:37
MDDMDD
283
New contributor
MDD is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Apr 15 at 13:06
MDD
asked Apr 15 at 12:37
MDDMDD
283
New contributor
MDD is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Apr 15 at 12:37
MDDMDD
283
asked Apr 15 at 12:37
MDDMDD
283
283
New contributor
MDD is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
MDD is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
MDD is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1) talk to your Microsoft Licensing person to get an accurate answer about any licensing requirements you have. 2) SSRS is bundled with SQL Server, so if you have a license to that version of SQL Server then you can use that version of SSRS. 3) Typically you can downgrade your SQL without issues (i.e. you have license for 2017, but you can use that license on any lower version of SQL you want to use (YMMV, see point 1). 4) I think the SSRS service may need a matching SQL engine to host it's reportserver database, but your reports can of course point to anything you have drivers for.
– Jonathan Fite
Apr 15 at 14:09
add a comment |
1) talk to your Microsoft Licensing person to get an accurate answer about any licensing requirements you have. 2) SSRS is bundled with SQL Server, so if you have a license to that version of SQL Server then you can use that version of SSRS. 3) Typically you can downgrade your SQL without issues (i.e. you have license for 2017, but you can use that license on any lower version of SQL you want to use (YMMV, see point 1). 4) I think the SSRS service may need a matching SQL engine to host it's reportserver database, but your reports can of course point to anything you have drivers for.
– Jonathan Fite
Apr 15 at 14:09
1) talk to your Microsoft Licensing person to get an accurate answer about any licensing requirements you have. 2) SSRS is bundled with SQL Server, so if you have a license to that version of SQL Server then you can use that version of SSRS. 3) Typically you can downgrade your SQL without issues (i.e. you have license for 2017, but you can use that license on any lower version of SQL you want to use (YMMV, see point 1). 4) I think the SSRS service may need a matching SQL engine to host it's reportserver database, but your reports can of course point to anything you have drivers for.
– Jonathan Fite
Apr 15 at 14:09
1) talk to your Microsoft Licensing person to get an accurate answer about any licensing requirements you have. 2) SSRS is bundled with SQL Server, so if you have a license to that version of SQL Server then you can use that version of SSRS. 3) Typically you can downgrade your SQL without issues (i.e. you have license for 2017, but you can use that license on any lower version of SQL you want to use (YMMV, see point 1). 4) I think the SSRS service may need a matching SQL engine to host it's reportserver database, but your reports can of course point to anything you have drivers for.
– Jonathan Fite
Apr 15 at 14:09
add a comment |
1 Answer
1
active
oldest
votes
You can download and install SSRS 2017, and use an existing SQL Server to store the Report Server database. The databases can be on any supported version of SQL Server, as documented here.
The server running SSRS 2017 must, of course, be licensed per the licensing guide here.
Alternatively you can get this functionality (and more), with Power BI Report Server, which can be acquired via Power BI Premium, or run using SQL Server Enterprise Edition Core Licenses covered by active Software Assurance.
answered Apr 15 at 15:14
David Browne - MicrosoftDavid Browne - Microsoft
12.7k731
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
MDD is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234820%2fcan-we-download-ssrs-2017-to-use-with-sql-server-2016%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can download and install SSRS 2017, and use an existing SQL Server to store the Report Server database. The databases can be on any supported version of SQL Server, as documented here.
The server running SSRS 2017 must, of course, be licensed per the licensing guide here.
Alternatively you can get this functionality (and more), with Power BI Report Server, which can be acquired via Power BI Premium, or run using SQL Server Enterprise Edition Core Licenses covered by active Software Assurance.
answered Apr 15 at 15:14
David Browne - MicrosoftDavid Browne - Microsoft
12.7k731
add a comment |
You can download and install SSRS 2017, and use an existing SQL Server to store the Report Server database. The databases can be on any supported version of SQL Server, as documented here.
The server running SSRS 2017 must, of course, be licensed per the licensing guide here.
Alternatively you can get this functionality (and more), with Power BI Report Server, which can be acquired via Power BI Premium, or run using SQL Server Enterprise Edition Core Licenses covered by active Software Assurance.
answered Apr 15 at 15:14
David Browne - MicrosoftDavid Browne - Microsoft
12.7k731
add a comment |
You can download and install SSRS 2017, and use an existing SQL Server to store the Report Server database. The databases can be on any supported version of SQL Server, as documented here.
The server running SSRS 2017 must, of course, be licensed per the licensing guide here.
Alternatively you can get this functionality (and more), with Power BI Report Server, which can be acquired via Power BI Premium, or run using SQL Server Enterprise Edition Core Licenses covered by active Software Assurance.
answered Apr 15 at 15:14
David Browne - MicrosoftDavid Browne - Microsoft
12.7k731
You can download and install SSRS 2017, and use an existing SQL Server to store the Report Server database. The databases can be on any supported version of SQL Server, as documented here.
The server running SSRS 2017 must, of course, be licensed per the licensing guide here.
Alternatively you can get this functionality (and more), with Power BI Report Server, which can be acquired via Power BI Premium, or run using SQL Server Enterprise Edition Core Licenses covered by active Software Assurance.
answered Apr 15 at 15:14
David Browne - MicrosoftDavid Browne - Microsoft
12.7k731
answered Apr 15 at 15:14
David Browne - MicrosoftDavid Browne - Microsoft
12.7k731
answered Apr 15 at 15:14
David Browne - MicrosoftDavid Browne - Microsoft
12.7k731
answered Apr 15 at 15:14
David Browne - MicrosoftDavid Browne - Microsoft
12.7k731
12.7k731
add a comment |
add a comment |
MDD is a new contributor. Be nice, and check out our Code of Conduct.
MDD is a new contributor. Be nice, and check out our Code of Conduct.
MDD is a new contributor. Be nice, and check out our Code of Conduct.
MDD is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234820%2fcan-we-download-ssrs-2017-to-use-with-sql-server-2016%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1) talk to your Microsoft Licensing person to get an accurate answer about any licensing requirements you have. 2) SSRS is bundled with SQL Server, so if you have a license to that version of SQL Server then you can use that version of SSRS. 3) Typically you can downgrade your SQL without issues (i.e. you have license for 2017, but you can use that license on any lower version of SQL you want to use (YMMV, see point 1). 4) I think the SSRS service may need a matching SQL engine to host it's reportserver database, but your reports can of course point to anything you have drivers for.
– Jonathan Fite
Apr 15 at 14:09