We had a customer call up that encountered a problem when trying to create a new database for their Report Server through the Reporting Services Configuration Manager. This is what they saw: When we clicked on the Error link, we saw the following details: System.Net.Sockets.SocketException: 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.CreateNewDatabase() The server name that we had specified was in the format of SERVER,PORT. The reason was because there was a firewall in between the Report Server and the Database server. The Database server was a Named Instance and UDP 1434 was being blocked which is the port for SQL Browser. We use SQL Browser to convert the Named Instance name to the actual Port number, or named pipe, of the Named Instance. With SQL Browser not available, we have to specify the actual port number so that we can connect to the database. From the screenshot above, it looks like we were able to connect to the database as “Running database script” was successful. Also the “Test Connection” button on the Database Server part of the wizard connected successfully. So, we got a dump of the error to see what was happening.
Original post:
SocketException when creating a new Report Server Database