Hi guys, i need your help urgently. I'm developing a new project for budgeting. My problem is, i have not access to the real server (just call it Server A). The company provides another server (just call it Server B) which provides VIEW for the data from the Server A (Server A and Server B is connected by link server). I need to make a link server from my database server (just call it Server C) to Server B so i can't build stored procedure that access VIEW in server B.

But i got this error message :
Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

Is it possible to make link server to multiple level server?I need it urgently.Thanks for your help...