Error SocketException getaddrinfo no data of the requested type was found when creating a new Report Server Database

When you are trying to create a new database for your Report Server through the Reporting Services Configuration Manager and the database server is not local but a remote server and in the remote server you have changed the default port and the SQL Browser is not running, you will run in the following error SocketException getaddrinfo no data of the requested type was found , and the configuration tool will show the following error in the Generating rights scripts section.

 

image

 

 

When you click on the Error link, you will saw the following detail:

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()

This happens because the configuration tools is trying to resolve the server name you have specified, for example if your remote server is called DBServerA and you have created an alias whose name is DB you will run into this error. To solve it, you need to create an alias with the same name of the remote server and you have to specify the remote port, as shown in the following screenshot:

 

image

If you are running in a 64 bits machines you will also have to create the alias for the 32 bits clients, I had to create the alias twice for this in order to work.

 

Regards,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Comments

Popular posts from this blog

Cómo identificar consultas más pesadas en SQL Server

Permitiendo la administración de los jobs a usuarios que no son System Administrators en SQL Server Agent 2005 o superior

FileTable en SQL Server 2012