I created a stored proc in a database called DBA_Test. I went to another server and tried to execute the SP using EXEC LinkedServerName.DBA_Test.dbo.spLoad_Clients_Monthly_Filings. When I try to Execute the query I get the following error: Server ‘LinkedServerName‘ is not configured for RPC. When the line is in the query window of SSMS, the DBA_Test is underlined in red and hovering over it
Query_Window shows a message
Could not locate entry in sysdatabases for database ‘DBA_Test’. No entry found with that name. Make sure that the name is entered correctly.
I have everything spelled correctly and the stored proc is listed in the database as seen below.
DBA_Test_Stored_Procs
I tried executing the SP on the same server but from another database and it ran fine. Every other server I switched to gave the red line error saying that the database could not be found in sysdatabases. I have all the linked servers working correctly.
>Solution :
When you create linked server you need to set RPC (and maybe RPC out):
Regarding your second question, sometimes SSMS doesn’t correctly parse linked server objects