September 11, 2024 at 7:36 am
create table #failover_logs
(
id int identity,
logdate datetime,
processinfo nvarchar(100),
logging nvarchar(max)
)
--DROP TABLE #failover_logs
insert into #failover_logs
(
logdate,
processinfo,
logging
)
exec [Linked server].master.sys.sp_executesql N'sp_readerrorlog 0, 1, ''failover'', ''offline'''
While executing this I'm getting below error
"The transaction manager has disabled its support for remote/network transactions.".
The operation could not be performed because OLE DB provider "MSOLEDBSQL" for linked server "Server Name" was unable to begin a distributed transaction.
September 11, 2024 at 7:42 am
Have you checked and/or configured MSDTC to allow "remote/network transactions".
What do your MSDTC setting look like on the component services snapin on the linked host.
September 12, 2024 at 2:33 pm
Just to add, I believe you also need RPC OUT enabled on the linked server in order to execute stored procedures on a remote system as well.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply