Nowadays, most of the organisations are using Azure Virtual Machine to host SQL Server Reporting services. By default, we can access the reporting service manager with-in same network. It won’t be possible to access the reporting services outside of network without setting up below configuration.
This is not only for SSRS in Azure VM. The same setup is applicable for the on-premises server.
Follow the below steps,
Step 1: Go to virtual machine resource group and select Network Security Group.
Step 2: Create a new inbound security role with service as HTTP, it will take 80 as a port.
Step 3: Create a same inbound rule inside the virtual machine. Use the below power shell script to create a rule.
New-NetFirewallRule -DisplayName “Report Server (TCP on port 443)” -Direction Inbound –Protocol TCP -LocalPort 80
Step 4: Enable DNS if not configured already. Click Public IP in Virtual Machine overview section in the portal. Set up the DNS name. It will look like below.
Step 5: Make sure report server is configured and working without an issue.
Step 6: Pass the DNS name with extension in your local machine as like below.
Step 7: Pass the credentials and it will show your reports.
Share your comments below.