SSRS- database and Report Server - can they be different?

Clash Royale CLAN TAG#URR8PPP

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;

up vote
1
down vote

favorite

I have inherited a few database servers. I am currently planning for a Server upgrade, but this DB server has a ReportServer and ReportServerTempDB database in it.

When I open Reporting Service configuration Manager I am not able to connect to the above mentioned database server.

Is it possible that the Reporting Server for the above databases is configured in a different server other than the database server? How should I go about identifying these for further information.

I am asking because I have to move the ReportServer and ReportServerTempDB but I am not able to access the ReportServer Configuration Manager for the encryption keys.

sql-server migration ssrs

share|improve this question

edited 15 mins ago

Tom V

13.1k74373

asked 1 hour ago

abbhey

344

add a comment | 

up vote
1
down vote

favorite

I have inherited a few database servers. I am currently planning for a Server upgrade, but this DB server has a ReportServer and ReportServerTempDB database in it.

When I open Reporting Service configuration Manager I am not able to connect to the above mentioned database server.

Is it possible that the Reporting Server for the above databases is configured in a different server other than the database server? How should I go about identifying these for further information.

I am asking because I have to move the ReportServer and ReportServerTempDB but I am not able to access the ReportServer Configuration Manager for the encryption keys.

sql-server migration ssrs

share|improve this question

edited 15 mins ago

Tom V

13.1k74373

asked 1 hour ago

abbhey

344

add a comment | 

up vote
1
down vote

favorite

up vote
1
down vote

favorite

I have inherited a few database servers. I am currently planning for a Server upgrade, but this DB server has a ReportServer and ReportServerTempDB database in it.

When I open Reporting Service configuration Manager I am not able to connect to the above mentioned database server.

Is it possible that the Reporting Server for the above databases is configured in a different server other than the database server? How should I go about identifying these for further information.

I am asking because I have to move the ReportServer and ReportServerTempDB but I am not able to access the ReportServer Configuration Manager for the encryption keys.

sql-server migration ssrs

share|improve this question

edited 15 mins ago

Tom V

13.1k74373

asked 1 hour ago

abbhey

344

I have inherited a few database servers. I am currently planning for a Server upgrade, but this DB server has a ReportServer and ReportServerTempDB database in it.

When I open Reporting Service configuration Manager I am not able to connect to the above mentioned database server.

Is it possible that the Reporting Server for the above databases is configured in a different server other than the database server? How should I go about identifying these for further information.

I am asking because I have to move the ReportServer and ReportServerTempDB but I am not able to access the ReportServer Configuration Manager for the encryption keys.

sql-server migration ssrs

sql-server migration ssrs

share|improve this question

edited 15 mins ago

Tom V

13.1k74373

asked 1 hour ago

abbhey

344

share|improve this question

edited 15 mins ago

Tom V

13.1k74373

asked 1 hour ago

abbhey

344

share|improve this question

share|improve this question

edited 15 mins ago

Tom V

13.1k74373

edited 15 mins ago

Tom V

13.1k74373

edited 15 mins ago

Tom V

13.1k74373

13.1k74373

asked 1 hour ago

abbhey

344

asked 1 hour ago

abbhey

344

asked 1 hour ago

abbhey

344

344

add a comment | 

add a comment | 

2 Answers
2

active

oldest

votes

up vote
1
down vote

It could be installed on a different server, it is a better practice to do that.

Check out this stack overflow post for an 'unsupported' way to query the reportserver db for the connection string:

Get SSRS Datasources from reportserver

share|improve this answer

answered 1 hour ago

Randi Vertongen

1413

add a comment | 

up vote
1
down vote

Yes, the report server can be installed on another machine than the server where the databases reside, there can even be more than one report server instances connected to the same reportserver database (this is called scale out deployment).

Two or more report server instances sharing a single report server database.

You can run

exec ListInstallations 

In the reportserver database to list the Report servers connected to this database.

share|improve this answer

edited 57 mins ago

answered 1 hour ago

Tom V

13.1k74373

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',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

 

draft saved

draft discarded

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

Name Email

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f218972%2fssrs-database-and-report-server-can-they-be-different%23new-answer', 'question_page');

);

Post as a guest

Name Email

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

active

oldest

votes

active

oldest

votes

up vote
1
down vote

It could be installed on a different server, it is a better practice to do that.

Check out this stack overflow post for an 'unsupported' way to query the reportserver db for the connection string:

Get SSRS Datasources from reportserver

share|improve this answer

answered 1 hour ago

Randi Vertongen

1413

add a comment | 

up vote
1
down vote

It could be installed on a different server, it is a better practice to do that.

Check out this stack overflow post for an 'unsupported' way to query the reportserver db for the connection string:

Get SSRS Datasources from reportserver

share|improve this answer

answered 1 hour ago

Randi Vertongen

1413

add a comment | 

up vote
1
down vote

up vote
1
down vote

It could be installed on a different server, it is a better practice to do that.

Check out this stack overflow post for an 'unsupported' way to query the reportserver db for the connection string:

Get SSRS Datasources from reportserver

share|improve this answer

answered 1 hour ago

Randi Vertongen

1413

It could be installed on a different server, it is a better practice to do that.

Check out this stack overflow post for an 'unsupported' way to query the reportserver db for the connection string:

Get SSRS Datasources from reportserver

share|improve this answer

answered 1 hour ago

Randi Vertongen

1413

share|improve this answer

share|improve this answer

answered 1 hour ago

Randi Vertongen

1413

answered 1 hour ago

Randi Vertongen

1413

answered 1 hour ago

Randi Vertongen

1413

1413

add a comment | 

add a comment | 

up vote
1
down vote

Yes, the report server can be installed on another machine than the server where the databases reside, there can even be more than one report server instances connected to the same reportserver database (this is called scale out deployment).

Two or more report server instances sharing a single report server database.

You can run

exec ListInstallations 

In the reportserver database to list the Report servers connected to this database.

share|improve this answer

edited 57 mins ago

answered 1 hour ago

Tom V

13.1k74373

add a comment | 

up vote
1
down vote

Yes, the report server can be installed on another machine than the server where the databases reside, there can even be more than one report server instances connected to the same reportserver database (this is called scale out deployment).

Two or more report server instances sharing a single report server database.

You can run

exec ListInstallations 

In the reportserver database to list the Report servers connected to this database.

share|improve this answer

edited 57 mins ago

answered 1 hour ago

Tom V

13.1k74373

add a comment | 

up vote
1
down vote

up vote
1
down vote

Yes, the report server can be installed on another machine than the server where the databases reside, there can even be more than one report server instances connected to the same reportserver database (this is called scale out deployment).

Two or more report server instances sharing a single report server database.

You can run

exec ListInstallations 

In the reportserver database to list the Report servers connected to this database.

share|improve this answer

edited 57 mins ago

answered 1 hour ago

Tom V

13.1k74373

Yes, the report server can be installed on another machine than the server where the databases reside, there can even be more than one report server instances connected to the same reportserver database (this is called scale out deployment).

Two or more report server instances sharing a single report server database.

You can run

exec ListInstallations 

In the reportserver database to list the Report servers connected to this database.

share|improve this answer

edited 57 mins ago

answered 1 hour ago

Tom V

13.1k74373

share|improve this answer

share|improve this answer

edited 57 mins ago

edited 57 mins ago

edited 57 mins ago

answered 1 hour ago

Tom V

13.1k74373

answered 1 hour ago

Tom V

13.1k74373

answered 1 hour ago

Tom V

13.1k74373

13.1k74373

add a comment | 

add a comment | 

 

draft saved

draft discarded

 

draft saved

draft discarded

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

Name Email

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f218972%2fssrs-database-and-report-server-can-they-be-different%23new-answer', 'question_page');

);

Post as a guest

Name Email

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

Name Email

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

Name Email

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

Name Email

Name Email

Name

Email

Name Email

Name

Email