SQL Server 2016 Reporting Services fails to find instance after in-place upgrade
I upgraded from SQL Server 2014 to 2016 (in-place) upgrade. Our portal was: http://myServer:81/Reports before the upgrade. The upgrade/installation went perfectly fine: all components were upgraded successfully according to all logs. And everything works except for report server.
1- Our report server link (http://myServer:81/Reports) no longer works.
2- When I try to open it via SSMS it doesn't find it.
3- Config (SSCM) shows SSRS to be running but here is what it shows under "Log On as...""NOT INSTALLED", with no option to change. This is definitely strange and different.
4- Report config cannot find it either:
5- To add to the mystery, Report Server Config manager of my 2014 environment FINDS the server:
6- I tried to use my own login (I'm SA/Admin on the server) and force it down SSCM via Services on Windows. It didn't do me any good.
So here I am sobbing hoping someone can hint me in the right direction. Thank you very much in advance.
sql-server sql-server-2014 sql-server-2016 ssrs
asked 3 mins ago
LearnByReadingLearnByReading
406316
add a comment |
I upgraded from SQL Server 2014 to 2016 (in-place) upgrade. Our portal was: http://myServer:81/Reports before the upgrade. The upgrade/installation went perfectly fine: all components were upgraded successfully according to all logs. And everything works except for report server.
1- Our report server link (http://myServer:81/Reports) no longer works.
2- When I try to open it via SSMS it doesn't find it.
3- Config (SSCM) shows SSRS to be running but here is what it shows under "Log On as...""NOT INSTALLED", with no option to change. This is definitely strange and different.
4- Report config cannot find it either:
5- To add to the mystery, Report Server Config manager of my 2014 environment FINDS the server:
6- I tried to use my own login (I'm SA/Admin on the server) and force it down SSCM via Services on Windows. It didn't do me any good.
So here I am sobbing hoping someone can hint me in the right direction. Thank you very much in advance.
sql-server sql-server-2014 sql-server-2016 ssrs
asked 3 mins ago
LearnByReadingLearnByReading
406316
add a comment |
I upgraded from SQL Server 2014 to 2016 (in-place) upgrade. Our portal was: http://myServer:81/Reports before the upgrade. The upgrade/installation went perfectly fine: all components were upgraded successfully according to all logs. And everything works except for report server.
1- Our report server link (http://myServer:81/Reports) no longer works.
2- When I try to open it via SSMS it doesn't find it.
3- Config (SSCM) shows SSRS to be running but here is what it shows under "Log On as...""NOT INSTALLED", with no option to change. This is definitely strange and different.
4- Report config cannot find it either:
5- To add to the mystery, Report Server Config manager of my 2014 environment FINDS the server:
6- I tried to use my own login (I'm SA/Admin on the server) and force it down SSCM via Services on Windows. It didn't do me any good.
So here I am sobbing hoping someone can hint me in the right direction. Thank you very much in advance.
sql-server sql-server-2014 sql-server-2016 ssrs
asked 3 mins ago
LearnByReadingLearnByReading
406316
I upgraded from SQL Server 2014 to 2016 (in-place) upgrade. Our portal was: http://myServer:81/Reports before the upgrade. The upgrade/installation went perfectly fine: all components were upgraded successfully according to all logs. And everything works except for report server.
1- Our report server link (http://myServer:81/Reports) no longer works.
2- When I try to open it via SSMS it doesn't find it.
3- Config (SSCM) shows SSRS to be running but here is what it shows under "Log On as...""NOT INSTALLED", with no option to change. This is definitely strange and different.
4- Report config cannot find it either:
5- To add to the mystery, Report Server Config manager of my 2014 environment FINDS the server:
6- I tried to use my own login (I'm SA/Admin on the server) and force it down SSCM via Services on Windows. It didn't do me any good.
So here I am sobbing hoping someone can hint me in the right direction. Thank you very much in advance.
sql-server sql-server-2014 sql-server-2016 ssrs
sql-server sql-server-2014 sql-server-2016 ssrs
asked 3 mins ago
LearnByReadingLearnByReading
406316
asked 3 mins ago
LearnByReadingLearnByReading
406316
asked 3 mins ago
LearnByReadingLearnByReading
406316
asked 3 mins ago
LearnByReadingLearnByReading
406316
asked 3 mins ago
LearnByReadingLearnByReading
406316
406316
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
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%2f228910%2fsql-server-2016-reporting-services-fails-to-find-instance-after-in-place-upgrade%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f228910%2fsql-server-2016-reporting-services-fails-to-find-instance-after-in-place-upgrade%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
