My scenario is like this:
Upstream server [U] --> Regional servers [R] --> Local server [L] (3 different servers)
regarding permissions:
I have select permissions on [U] and execute permissions on [R] and [L]
########### Errors #############
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.
##########################
####
I have created a linked server to fetch data from [U] to [R] (APGCUAT) and [R] to [L] (PREMIERPRW)
so my linked servers exist in [R] is (APGCUAT) and [L] is (PREMIERPRW) with all the necessary permissions.
##My workaround is:
~~~~~~~~~~~~~~~~~
AIM: To fetch data from [U] to [L] thru linkes servers...
when i am trying to execute a sp with the linked server (Premierprw) from [L] i am getting an error:
###
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.
###
2. if i try to execute linked server in [R] to fetch data from [U] it is working fine and after this instantly if i execute the linked server (Premierprw) from [L] then the error message is occurred like this:
###
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.
###
Start Free Trial
