Tips:sql Server 2012 Report Server error 40 error

After you enable the Reporting Services feature on an existing SQL Server SP1 database, you find that you cannot configure the reporting database, such as an error.

Provider: Named pipe provider error:40-Unable to open a connection to SQL Server

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/7e/fc/wkiol1cpoocavgcoaalpzkntmzm371.png "height=" 412 "/>

Workaround:

You need to open SQL Server Configuration Manager, locate the SQL Server network configuration, locate the TCP/IP protocol for the instance project, and modify the static port to 1433.

650) this.width=650; "title=" 96E4C80FDF0843D596FAE3926EAEEFFB "style=" border-top:0px;border-right:0px; background-image:none;border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; " Border= "0" alt= "96E4C80FDF0843D596FAE3926EAEEFFB" src= "http://s3.51cto.com/wyfs02/M00/7E/FC/ Wkiol1cpoogsn8oaaac8piphfug408.jpg "height=" 484 "/>

You can then connect to SQL Server to configure the reporting database as normal.

This article from "Zeng Hung Xin Technical column" blog, declined to reprint!

Tips:sql Server 2012 Report Server error 40 error