Linked Server Error:
Could not execute procedure on remote server ‘XXXX’ because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access.
Fix:
Make sure remote access is enabled on the database server and that the server has been restarted if the configuration changed.
EXEC sp_configure 'remote access', 1 ;
GO
RECONFIGURE ;
GO Also make sure the linked server properties “RPC” and “PRC OUT” has been set to True.
EXEC master.dbo.sp_serveroption @server=N'XXXX', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'XXXX', @optname=N'rpc out', @optvalue=N'true'Sources:
https://www.sqlservercentral.com/forums/topic/error-when-executing-procedures-in-linked-server
Comments