Unable to create PBI Report Server configuration database on remote host

[dpombal]

Hi all,

I am installing Power BI Report Server August 2018 in a Machine A using a remote Machine B with SQL Server for its security.

• Machine A: PowerBI Report Server
• Machine B: SQL Server 2017

Both machines are included in the same Domain

I am blocked in the step of configuring database step.

These have been my instructions:

1 . Select Create a new report server database details (host/user) Test Connectivity Passed OK

 

2 . Select database name PowerBI

1. Select credentials to connect from Repor Server to Repor Server database (Error in this step)

 I am using same credentials from step 1

1. Error Exception raised after clicking next in previous step

It is very strange unknown host... since I have allowed remote connections on SQL Server database and port 1433 is open. 

Error stack trace (FULL LOG)

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.InternalGetHostByAddress(IPAddress address, Boolean includeIPv6)

   at System.Net.Dns.GetHostEntry(String hostNameOrAddress)

   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.3130.0 built by: NET472REL1LAST_B

    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll

----------------------------------------

RSConfigTool

    Assembly Version: 15.0.0.0

    Win32 Version: 15.0.2.540

    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.3062.0 built by: NET472REL1

    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.3062.0 built by: NET472REL1

    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.3062.0 built by: NET472REL1

    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.3062.0 built by: NET472REL1

    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.3062.0 built by: NET472REL1

    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.3062.0 built by: NET472REL1

    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.3062.0 built by: NET472REL1

    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: 2018.8.0.0

    Win32 Version: 2018.08.06.112

    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.3062.0 built by: NET472REL1

    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.3062.0 built by: NET472REL1

    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.3062.0 built by: NET472REL1

    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.3062.0 built by: NET472REL1

    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.3062.0 built by: NET472REL1

    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.3062.0 built by: NET472REL1

    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.

[dpombal]

After enabling Named Pipes, I am now getting a different Error

Error 

System.Net.Sockets.SocketException (0x80004005): The requested name is valid, but no data of the requested type was found

   at System.Net.Dns.InternalGetHostByAddress(IPAddress address, Boolean includeIPv6)

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): The requested name is valid, but no data of the requested type was found

   at System.Net.Dns.InternalGetHostByAddress(IPAddress address, Boolean includeIPv6)

   at System.Net.Dns.GetHostEntry(String hostNameOrAddress)

   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)

[dpombal · Accepted solution]

Solved Using following HOSTNAME,PORT instead of only  HOSTNAME.

If 2 SQL Server Instances exist in the same  HOST it is required to specify

HOSTNAME\INSTANCE,PORT

Instance was empty so in my case I use

HOSTNAME,PORT