Please read the following blog for best practice of connecting to SqlExpress. If Sqlexpress was installed on the remote box, you need to enable remote connection for Express. Np was disabld by default after installing SqlExpress.Ĭ. User is not aware of SqlExpress was installed as a named instance, consequently, in his/her connection string, he/she only specify ".","localhost" etc instead of ".\SqlExpress" or "\Sqlexpress".ī. The typical error when dealing with Express includes:Ī. Incorrect connection string, such as using SqlExpress. Named Pipes Provider, error: 40 - Could not open a connection to SQL Server :
MICROSOFT ERROR REPORTING 2.2.9 HOW TO
Anyone have any ideas on how to troubleshoot my situation. I have a feeling this error 40 issue has to due with permissions/authentication between the SQL Server boxes but I can't really be sure. I've been through a few threads describing the error 40, fiddling around with the SQL Server configuration as well as SSRS, to no avail. on the 2000 box, and try to test the reports, I get this same error 40 issue. Now when I open IE on an external box, i.e. When I redeployed the reports with this authentication change, testing the reports via IE locally (on the 2005 box) worked. I tested this in SSRS and this works too.
MICROSOFT ERROR REPORTING 2.2.9 WINDOWS
Now I changed the datasource's authentication from SQL Server to Windows authentication. I made sure that Named Pipes and TCP were enabled and the port set at 1433 (to match that on the 2000 box). When I deploy them to the reporting server and launch IE to test locally (still on the 2005 box), I get this "Named Pipes Provider, error 40" issue. When testing the reports via SSRS (in Visual Studio 2005), the connection to the data works and the reports are generated fine. I've set up the reports on SSRS such that their datasources hit the 2000 server. The 2005 database is used only for Reporting Services. The SQL Server 2000 contains the actual application data. I have two SQL Servers installed on two separate Win2K3 Server boxes, one is SQL Server 2000 and the other is SQL Server 2005. I'm encountering an issue with "Named Pipes Provider, error: 40 windows" and am having problems determining how to fix it due to the environment I'm using.