Forum Discussion
SSMS connection failure to reporting services
Hi Xriz,
Thank you for the update.Since the Web Service URL (/ReportServer) is returning HTTP 500, the issue now appears to be with the Power BI Report Server configuration rather than SSMS itself. SSMS connects through the Report Server Web Service endpoint, so if /ReportServer cannot load successfully, SSMS connections will also fail. The fact that the Web Portal is accessible, but the Web Service URL does not indicate that the Report Server service is reachable but encountering an internal error during initialization.
As a next step, please review the PBIRS log files and Windows Event Viewer for errors generated when accessing /ReportServer. Also verify in Report Server Configuration Manager that the Report Server database connection is valid, the service account has the required permissions, and the encryption keys were restored successfully after the migration. If accessing http://localhost/reportserver (or the configured HTTPS URL) locally also returns HTTP 500, this would confirm a PBIRS configuration issue rather than a network or VPN routing problem. Sharing the relevant log entries should help identify the exact cause of the failure.The problem has been resolved. The cause was a custom installation to an alternative path. This resulted in the virtual user attempting to start the service lacking write permissions (more precisely, delete permissions) to the folder containing the service.
Hi Xriz,
Thank you for reaching out to the Microsoft Fabric Community Forum.
Based on your description, the issue started after migrating and upgrading Power BI Report Server. Since the PBIRS instance is visible in SSMS but the connection fails, this typically points to an issue with the PBIRS endpoint configuration, URL accessibility, SSL bindings, migration settings, or a potential compatibility issue between the January 2026 PBIRS release and SSMS 22.6.
As a first step, please verify that the Power BI Report Server service is running and confirm whether you can access both the Web Portal URL (https://<server>/reports) and the Web Service URL (https://<server>/reportserver) directly from a browser. If either URL is inaccessible, the issue is likely with the PBIRS configuration rather than SSMS. Also review the configuration in Report Server Configuration Manager (Web Service URL, Web Portal URL, Database, Service Account), verify that the encryption keys were restored successfully after the migration, and check the PBIRS log files for any errors during the connection attempt. Additionally, test with the latest SSMS version to rule out a compatibility issue.
Refer these links:
1. https://learn.microsoft.com/en-us/power-bi/report-server/getting-around?
2. https://learn.microsoft.com/en-us/power-bi/report-server/install-report-server?
Could you please confirm whether the /reports and /report server URLs are accessible and whether any relevant errors appear in the PBIRS logs? This will help narrow down the root cause.
Hi Xriz,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.
Hi Xriz,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.
Thanks for all the tips. It looks like we're generally having network issues on the new machine caused by a self-hosted VPN. I'm currently trying to investigate and fix them. That said, I’ve updated the report server to the latest version and set up the web portal URL and the web service URL locally as recommended. Unfortunately, I can only access the portal URL through the browser via [MachineName]reportsbrowse. The web service URL [MachineName]ReportServer doesn’t work and gives an HTTP 500.
Hi Xriz,
Thank you for the update.Since the Web Service URL (/ReportServer) is returning HTTP 500, the issue now appears to be with the Power BI Report Server configuration rather than SSMS itself. SSMS connects through the Report Server Web Service endpoint, so if /ReportServer cannot load successfully, SSMS connections will also fail. The fact that the Web Portal is accessible, but the Web Service URL does not indicate that the Report Server service is reachable but encountering an internal error during initialization.
As a next step, please review the PBIRS log files and Windows Event Viewer for errors generated when accessing /ReportServer. Also verify in Report Server Configuration Manager that the Report Server database connection is valid, the service account has the required permissions, and the encryption keys were restored successfully after the migration. If accessing http://localhost/reportserver (or the configured HTTPS URL) locally also returns HTTP 500, this would confirm a PBIRS configuration issue rather than a network or VPN routing problem. Sharing the relevant log entries should help identify the exact cause of the failure.Hi Xriz,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.