August 29, 2016 at 4:54 pm
All,
I'm new to this particular company and we are in the process of migrating servers. In this case SSRS is installed on one server and the databases are on another. I know the database server, but I don't know how to find on which server SSRS is installed. I've done several searches but can't seem to find any information. I would assume the information would be located somewhere in the ReportServer database, but I haven't been able to find it yet. Any suggestions and/or help would be greatly appreciated!
August 30, 2016 at 4:23 am
The Reporting Services database is purely for deploying your RS data and reports to. it holds your security settings, and stuff like that, but where you run the service could technically be anywhere, as long as it has a connection to your SQL Server.
SSRS is actually part of the SQL Server installation, so a quick question, it isn't install and running on your SQL server is it?
If not, a report URL will probably tell you, as the domain/server name will be in it. Provided your running it locally. so, if your SSRS report has a URL of http://srvsqlserver/ReportServer?%2FReports%2FNumber%20of&Sales%3Aisnull=True&rs%3AParameterLanguage=en-GB then your SSRS server is the server name "srvsqlserver".
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 30, 2016 at 5:49 am
You can also try using a couple of the DMVs to determine the IP address of the originating server, then work with your network team to find the computer name.
The script below should pull the information:
use [master];
go
select sdes.session_id
, sdes.program_name
, sdes.login_name
, sdec.connect_time
, sdec.client_net_address --This is the IP of the SSRS server
, sdec.local_net_address --This is the IP of the SQL Server
from sys.dm_exec_sessions as sdes
inner join sys.dm_exec_connections as sdec
on sdes.session_id = sdec.session_id
where sdes.program_name = 'Report Server';
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply