topic Re: Unable to install Power BI Report Server Due to blocking error in Report Server

Unable to install Power BI Report Server Due to blocking error

harunkara — Mon, 26 Apr 2021 11:04:45 GMT

Hi,

Last week while I was trying to install power bi report server on a customer system I was prompted with this error message. Any idea how to resolve this issue? I was trying to install the latest version of power bi report server for your information.

See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Net.Sockets.SocketException (0x80004005): No such host is known at System.Net.Dns.GetAddrInfo(String name) at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6) at System.Net.Dns.GetHostEntry(String hostNameOrAddress) at ReportServicesConfigUI.WMIProvider.RSInstance.get_MachineIPAddresses() at ReportServicesConfigUI.RSDatabase.IsLocalDbServer(String dbServer) at ReportServicesConfigUI.RSCredentialPanel.EnsureHaveValidData() at ReportServicesConfigUI.RSCredentialPanel.NotifyNextClicked() at ReportServicesConfigUI.DatabaseWizard.MovePage(MoveDirection direction) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib Assembly Version: 4.0.0.0 Win32 Version: 4.7.3740.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll ---------------------------------------- RSConfigTool Assembly Version: 15.0.0.0 Win32 Version: 15.0.1104.310 CodeBase: file:///C:/Program%20Files/Microsoft%20Power%20BI%20Report%20Server/Shared%20Tools/RSConfigTool.exe ---------------------------------------- System.Windows.Forms Assembly Version: 4.0.0.0 Win32 Version: 4.7.3690.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 4.0.0.0 Win32 Version: 4.7.3640.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing Assembly Version: 4.0.0.0 Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Configuration Assembly Version: 4.0.0.0 Win32 Version: 4.7.3630.0 built by: NET472REL1LAST_B CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Core Assembly Version: 4.0.0.0 Win32 Version: 4.7.3781.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll ---------------------------------------- System.Xml Assembly Version: 4.0.0.0 Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Management Assembly Version: 4.0.0.0 Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Management/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Management.dll ---------------------------------------- Microsoft.ReportingServices.Editions Assembly Version: 2020.10.0.0 Win32 Version: 2020.10.6.6 CodeBase: file:///C:/Program%20Files/Microsoft%20Power%20BI%20Report%20Server/Shared%20Tools/Microsoft.ReportingServices.Editions.DLL ---------------------------------------- System.ServiceProcess Assembly Version: 4.0.0.0 Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceProcess/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll ---------------------------------------- Accessibility Assembly Version: 4.0.0.0 Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- System.Data Assembly Version: 4.0.0.0 Win32 Version: 4.7.3710.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- System.Transactions Assembly Version: 4.0.0.0 Win32 Version: 4.7.3260.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll ---------------------------------------- System.EnterpriseServices Assembly Version: 4.0.0.0 Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll ---------------------------------------- System.Numerics Assembly Version: 4.0.0.0 Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.

Re: Unable to install Power BI Report Server Due to blocking error

d_gosbell — Tue, 27 Apr 2021 00:01:57 GMT

It's not good that the app crashes like that. But the message that "No such host is known" sounds like the name you've been given for the database server is not correct. That message means that when the configuration tool queried DNS it could not resolve the host name to an IP address.

If you open a command prompt and try to ping the database server does that work? If not this is a networking issue or you've been given the wrong server name.

Re: Unable to install Power BI Report Server Due to blocking error

v-deddai1-msft — Wed, 28 Apr 2021 08:57:13 GMT

Hi @harunkara ,

Would you please test if you can connect to database server by udl file? Using HOSTNAME\INSTANCE,PORT instead of HOSTNAME for database server.

Please refer to the similar post: https://community.powerbi.com/t5/Report-Server/Unable-to-create-PBI-Report-Server-configuration-database-on/m-p/501291

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Re: Unable to install Power BI Report Server Due to blocking error

harunkara — Thu, 29 Apr 2021 06:35:59 GMT

Hi, When I try to ping, It resolves the IP but it times out. Could that be the reason?

Re: Unable to install Power BI Report Server Due to blocking error

harunkara — Thu, 29 Apr 2021 07:03:17 GMT

Hi, I haven't tried udl yet but telnet works fine on port 1433 to the sql server. I was also able to install SharePoint on the same server to the same sql server.

I have tried hostname\instance,port but that also fails. I am at a loss.

I tried adding an entry to hosts file to maybe fix the problem bu that didn't work either.

And one thing i wanna mention is that the sql db and power bi server are in different VLANS.

Re: Unable to install Power BI Report Server Due to blocking error

harunkara — Thu, 29 Apr 2021 07:16:45 GMT

udl test is below

Re: Unable to install Power BI Report Server Due to blocking error

v-deddai1-msft — Thu, 29 Apr 2021 08:49:10 GMT

Hi @harunkara ,

Did you test it on the server host the report server?

Best Regards,

Dedmon Dai

Re: Unable to install Power BI Report Server Due to blocking error

harunkara — Thu, 29 Apr 2021 08:51:01 GMT

@v-deddai1-msft Yes, that screenshot is from the server where i am trying to install Report Server.

Re: Unable to install Power BI Report Server Due to blocking error

v-deddai1-msft — Thu, 29 Apr 2021 09:04:29 GMT

Hi @harunkara ,

It's really strange that you can use udl test successfully but can't ping the server name. Did you do the both test on the report server? And why your named instance use the port 1433. It's used for default instance.

Best Regards,

Dedmon Dai

Re: Unable to install Power BI Report Server Due to blocking error

harunkara — Thu, 29 Apr 2021 09:08:48 GMT

Hi @v-deddai1-msft , When I send install requirements to customer, its listed as 1433 in my farm topology as its the default port. After that its up to the db admin to decide the port. In this case they decided they will go with 1433 as I sent.

Both tests, ping and udl was performed on report server.

Would that cause problem? I installed SharePoint without problem using the same db instance and port.

Re: Unable to install Power BI Report Server Due to blocking error

v-deddai1-msft — Thu, 29 Apr 2021 09:18:04 GMT

Hi @harunkara ,

Have ever try to use ip address instead of server name?

Best Regards,

Dedmon Dai

Re: Unable to install Power BI Report Server Due to blocking error

harunkara — Thu, 29 Apr 2021 09:44:20 GMT

@v-deddai1-msft

yes tried that as well, procudes same error.

Re: Unable to install Power BI Report Server Due to blocking error

v-deddai1-msft — Fri, 30 Apr 2021 01:41:21 GMT

Hi @harunkara ,

If you're creating the report server database on a database server on a different machine, change the service account for the report server to a credential that is recognized on the database server.

Please refer to https://docs.microsoft.com/en-us/power-bi/report-server/install-report-server#creating-a-database-on-a-different-server

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Re: Unable to install Power BI Report Server Due to blocking error

harunkara — Fri, 30 Apr 2021 08:30:50 GMT

@v-deddai1-msft

Can you elaborate on recognize? What rights should system admin give to that user on the db server?

Another info that came to light is that,

machine host name for db is OF-DEVQASQL-N but the netbios name is OF-DEVQASQL-N43,

I believe this is the reason for the error, But i have no idea how to fix it, other than requesting new servers with hostname-netbios name matching machines. Which might not be an option here so im open to suggestions.

Re: Unable to install Power BI Report Server Due to blocking error

harunkara — Tue, 04 May 2021 10:43:07 GMT

@v-deddai1-msft

@d_gosbell

I was able to solve the problem by changing the hostnames to a smaller version that doesn't get shortened in "systeminfo".

Edit: before changing the hostname to a shorter version, I was also able to install it successfully by installing a new sql server on the report server hosting machine.