9/19/2023 0 Comments Cloudapp power up![]() ![]() Open Active Directory Users and Computers. We have to configure the delegation settings on the report server service account. ![]() Register the following SPNs under the SQL Server service account using the following commands (for a default instance of SQL Server): setspn -s MSSQLSVC/FQDN\_of\_SQL\_Server: 1433 (PortNumber) Setspn -s http/ FQDN\_of Power BI Report Server\_server Power BI Report Server\_ServiceAccount ![]() Register the following SPNs under the account Power BI Report Server service account using the following commands setspn -s http/ Netbios name\_of\_Power BI Report Server\_server Power BI Report Server\_ServiceAccount Open the command prompt as an administrator and perform the following steps. If you have to change the configuration file, stop and restart the report server service from Report Server Configuration Manager to make sure the changes take effect. We want to make sure that RSWindowsNegotiate is listed and is first in the list of authentication types. Within the nfig file, find the Authentication/AuthenticationTypes section. This configuring is done within the nfig file. We need to configure the authentication type for the report server to allow for Kerberos constrained delegation. Configure Power BI Report Server to work with Kerberos 1. HKEY\_LOCAL\_MACHINE \SYSTEM\CurrentControlset\Control \Lsa\ MSV1\_0 registry keyĪdd a new value BackConnectionHostNames, a multi-string value, and provide the host name .com.Īfter that, we can access the URLs on the server as well. On accessing the URL on the server, we're prompted three times for credentials, and see a blank screen. The Web service and Web portal URLs should be accessible successfully after making the above-mentioned changes. To avoid this, you can set the Public IP address to static in the Azure portal. ![]() Note that on restarting the VM, the dynamic IP address might change, and you may have to add the right IP address again in the host file. Hence, we added the host file entry on the VM (Power BI Report Server) to include the Public IP address and the host name .com. The Public IP address is used for access from outside the virtual machine. In Azure portal we see two IP addresses for the VM in the networking section We performed the previous step for both Web service and Web portal section and got the URLs registered on the report server Configuration Manager: The DNS name configured for the VM in our environment is .com.Ĭonfigure the Power BI Report Server external web service and web portal URL by selecting the Advanced tab > Add button > Choose Host Header Name and adding the host name (DNS name) as shown here. Also, create inbound and outbound rules for Azure VM from the Azure portal for TCP protocol – Port 80. SQL Server Data Source: Īfter installing Power BI Report Server (assuming on an Azure VM), configure the Power BI Report Server web service and web portal URLs using the following steps:Ĭreate inbound and outbound rules on the VM firewall for Port 80 (Port 443 if you have https URLs configured).We used these values in the example we created. Read more about remote access to on-premises applications through Azure Active Directory's Application Proxy. Through this integration, users who are away from the corporate network can access their Power BI Report Server and Reporting Services reports from their client browsers and be protected by Azure Active Directory (AD). This article discusses how to use Azure Active Directory Application Proxy to connect to Power BI Report Server and SQL Server Reporting Services (SSRS) 2016 and later. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |