March 10, 2017 at 12:32 pm
Hi All,
In Our production the client is generating the report from one server to another, but it shows the below error.
OLE DB provider "SQLNCLI11" for linked server "***" returned message "The transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Line 100
The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "****" was unable to begin a distributed transaction.
We have given necessary permissions in MSDTC services also. But still it is continuing.
Regards
NM
March 11, 2017 at 3:57 am
Narine M - Friday, March 10, 2017 12:32 PMHi All,In Our production the client is generating the report from one server to another, but it shows the below error.
OLE DB provider "SQLNCLI11" for linked server "***" returned message "The transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Line 100
The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "****" was unable to begin a distributed transaction.We have given necessary permissions in MSDTC services also. But still it is continuing.
Regards
NM
Have you configured MSDTC on the remote server?
😎
March 12, 2017 at 11:38 pm
Yes, we configured MSDTC server also, but still problem exists...
March 13, 2017 at 8:03 am
ensure you have enabled reomote procedure calls on the linked server itself
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2017 at 11:08 pm
Yes, RPC in and out are true only. but problem still exists. We cant able to generate the report from colo to AWS server(Specific server).
March 14, 2017 at 12:22 am
We are facing the below error.:
The OLE DB provider "SQLNCLI10" for linked server indicates that either the object has no columns or the current user does not have permissions on that object.
March 14, 2017 at 10:56 am
Narine M - Tuesday, March 14, 2017 12:22 AMWe are facing the below error.:The OLE DB provider "SQLNCLI10" for linked server indicates that either the object has no columns or the current user does not have permissions on that object.
Is that a new error or an additional error? Which applies can matter but...for the error of no columns, etc, that can happen when you have multiple result sets returned.
Try SET NOCOUNT ON. Sometimes doing SET FMTONLY OFF gets around that as well.
Sue
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply