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.
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'