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.
Connecting multiple machines on the same domain would be one of the requirement to all the network administrator to set up the environment for any scenario.
This post explains this scenario how administrators can they do this setup easily.
I pretend that you have a machine with a domain controller on it.
While creating another machine, you need to choose the first machine’s virtual network instead of creating a new one as like below.
Next, you can identify the IP address by typing ipconfig in command line tool.
Also, you can ping the machines each other. In case, if you are not able to ping then turn off your firewall.
Then, try to add the domain and it will throw an error message as like below.
To rectify the above issue, you need to add the domain control IP address on DNS Server. Go to Azure Portal and Network Interface.
In DNS Server add the domain controller IP address in custom and restart the machine.
Again log into the machine and now try to add the domain and this time you can add successfully. Share your comments, if any issues.
This article explains to you that how can you host your SAP Machine in Azure. Let us host SAP BW Machine in Azure here. Same steps should be followed for other SAP machine templates.
Follow the below steps to host your SAP BW in Azure,
Step 1: Connect to https://cal.sap.com/catalog#/solutions and filter “SAP BW”
Step 2: Choose the instance and click “Create Instance”
Step 3: Log into SAP CAL
Step 4: Choose “Create a new account” in Account section.
Step 5: Choose the “Microsoft Azure” and get subscription id. Visit portal.azure.com and log in with your azure credentials.
Step 6: Fill the details as like below,
Step 7: Click the “Download New Certificate”. The certificate will be downloaded.
Step 8: Visit the below URL to upload the certificate to Azure management portal.
Step 9: Upload the certificate.
Step 10: Go to cal.sap.com URL again and click “Test Connection”. It will open the other details.
Step 11: Fill the Instance details and click “Create”
Step 12: Download the “Private key”. A message window will pop up.
Step 13: Check the system status and wait until to complete the activation.
Step 14: Once Status changed to “Active” then click “Connect”.
Step 15: Click “Connect” RDP. Enter the instance password which you defined.
Step 16: Inside RDP, check the guide and start to use BW.
That’s it. It is simple to host any template from cal.sap in Azure as like this.
Share your comments below.