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


Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  Error when fetching data thru Link server - Rajesh Kallakuri  09-May-08 01:18 1:18:13 AM
      user in null in your connection string.. - Vasanthakumar D  09-May-08 01:34 1:34:17 AM
          Try this. - Anil Desai  09-May-08 03:52 3:52:39 AM
              i am not executing this - Rajesh Kallakuri  09-May-08 04:37 4:37:52 AM
                  check your query... - Vasanthakumar D  10-May-08 12:48 12:48:55 AM
      Try this way - Aravind Kumar  12-May-08 12:50 12:50:03 AM
View Posts