Moving SSRS from Windows Server 2016 to new Windows Server 2019. Looking at the XML from ExecutionLog3 (Below). Connections take around 20 seconds before it moves on to actually running the report, instant on 2016 server. Testing data sources takes around 20 seconds using domain authentication, using sql authentication, oracle authentication, db2, all instant on both servers. SPNs have been moved to new server and service accounts, when I connect the report server database it does use Kerberos.
I was upgrading the report server to the latest 2019 version, which was just dot versions higher then the 2016 install. Uninstalled and installed the same version of SSRS as on the 2016 server, same experience as kind of expected.
I have turned on verbose logging on the report server, I can not see the issue.
HTTP Log
Server Name:
Software: Report Server Version 2018.0150.1102.675 ((BI_Server_Main).191031-2025)
Version: 1.0
Date: 07/10/2021-01:52:33
Fields: date time c-ip cs-username s-ip s-port s-host cs-method cs-uri-stem cs-uri-query sc-status cs-bytes time-taken cs-version cs(User-Agent) cs(Cookie) sc(Cookie) cs(Referrer)
07/10/2021 01:52:42 #.#.#.193 - #.#.#.99 20480 #.#.#.99 POST /ReportServer/ReportService2010.asmx 401 878 0 1.1 Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000) - - -
07/10/2021 01:52:42 #.#.#.193 - #.#.#.99 20480 #.#.#.99 POST /ReportServer/ReportService2010.asmx 401 623 16 1.1 Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000) - - -
07/10/2021 01:53:05 #.#.#.193 domain\user #.#.#.99 20480 #.#.#.99 POST /ReportServer/ReportService2010.asmx 200 1069 22453 1.1 Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000) - - -
The last line shows my 22 second delay again. Not knowledgeable enough to know what it is trying to do, that is so slow.
Execution Log 3
<Connections>
<Connection>
<ConnectionOpenTime>21854</ConnectionOpenTime>
<DataSets>
<DataSet>
<Name>DataSet1</Name>
<RowsRead>176</RowsRead>
<TotalTimeDataRetrieval>3668</TotalTimeDataRetrieval>
<ExecuteReaderTime>3660</ExecuteReaderTime>
</DataSet>
</DataSets>
</Connection>