SSRS - Report Server Configuration Exception ( System.Net.Sockets.SocketException (0x80004005): No such host is known )

2
    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.RSDatabase.IsLocalDbServer(String dbServer)
   at ReportServicesConfigUI.RSDatabase.GrantRSConnectionRights()
   at ReportServicesConfigUI.RSDatabase.ChangeRSDatabase()

Above error came at the last point of report server data base configuration.

Path to reproduce = Report Server Configuration Manager > Database > Change Database > Progress and Finish

error occurred on "Generating Right Scripts"

Can someone please attend on this and help to go through this issue.

Thanks

sql-server
reporting-services
asked on Stack Overflow Sep 11, 2018 by Fazil • edited Sep 11, 2018 by jarlh

2 Answers

1

The server instance must be a domain. If you try to use an IP address you will get this error.

Editing the IP into my hosts file with a domain and then using that solved the issue.

answered on Stack Overflow Apr 14, 2020 by Clint
0

GO to the SQL Server and execute the command, select @@servername(); it gives you the SQL Server Instance name. That instance name you have to provide while configuring the SSRS Report. That's it.

Please do not use IP while configuring SSRS, just use SQL Server Instance Name.

answered on Stack Overflow Apr 30, 2021 by vishal walujwar

User contributions licensed under CC BY-SA 3.0