Unable to install Power BI Report Server Due to blocking error

[harunkara]

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.

[harunkara · Accepted solution]

@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. 

[v-deddai1-msft]

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-data...

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

[harunkara]

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.

[harunkara]

udl test is below

[v-deddai1-msft]

Hi @harunkara ,

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

Best Regards,

Dedmon Dai

[harunkara]

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

[v-deddai1-msft]

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

[harunkara]

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. 

[v-deddai1-msft]

Hi @harunkara ,

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

Best Regards,

Dedmon Dai

[harunkara]

@v-deddai1-msft 

yes tried that as well, procudes same error. 

[v-deddai1-msft]

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...

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

[harunkara]

@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. 

[d_gosbell]

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.

[harunkara]

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