none
Unable to access Linked Server from Client PC

    Question

  • Hi guys  

    I have an issue when trying to connect to linked servers from a client PC.

    The linked servers connection in question works when it gets accessed from the server but when a Client PC tries to connect to it then they receive the following error:


    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "SRV2".

    OLE DB provider "MSOLAP" for linked server "SRV2" returned message "An error was encountered in the transport layer.".

    OLE DB provider "MSOLAP" for linked server "SRV2" returned message "The peer prematurely closed the connection.". (Microsoft SQL Server, Error: 7303)

    ------------------------------

    Anyone else seen this issue or know how to resolve this?

    Thanks

    Friday, August 02, 2013 10:34 AM

Answers

All replies