CODEWITHSUNDEEP
sql-serverreporting-services
Fazil
Fazil

Reputation: 21

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

    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

Upvotes: 2

Views: 3343

Answers (2)

vishal walujwar
vishal walujwar

Reputation: 71

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.

Upvotes: 1

Clint
Clint

Reputation: 2793

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.

Upvotes: 1

Related Questions