Error when fetching data thru Link server |
| Rajesh Kallakuri posted at 09-May-08 01:18 |
When i am trying to fetch data from linked server i am getting two types of error messages:
Error 1: Msg 18452, Level 14, State 1, Line 0 Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Msg 10054, Level 16, State 1, Line 0 TCP Provider: An existing connection was forcibly closed by the remote host.
Error 2: OLE DB provider "SQLNCLI" for linked server "premierprw" returned message "The transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 1 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "premierprw" was unable to begin a distributed transaction.
Regarding Error2: how can i execute distributed transation in my server.
Thanks in Advance |
|