Post reply

provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

  • April 26, 2007 at 12:05 pm

    #177536

    We just changed the dev environment to sqlagent. From then we were unable to see the reports on the report server because:

    An error has occurred during report processing.

    Cannot create a connection to data source 'IHRSDataSource'.

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    this error is cropping up.

    To Resolve this issue, we checked the Surface Area Configuration and also checked the Reporting Service Configuration . There seem to be  no problem and everything looks ok.

    Please help me in resolving this issue.

  • April 26, 2007 at 1:55 pm

    #702776

    Solved the problem.

    Its soo weired... I cannot even imagine this happens. I cannot even explain why does this happen.

    OK...here is what I did. As explained earlier wee changed our environmnet from dev to sqlagent . I believe this triggred all the connection strings to be empty in the DataSource section of our server.

    I specifed the connection string and checked the Windows integrated security. Thats it, it worked.

    Thanks all for the support.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply