I had a requirement where I had to read data from a table on a different database server.So I created linked server to the database server to read the data.However when I executed my query I started getting the error "Server XYZ is not configured for RPC".
After checking the linked server options I noticed that the RPC is set to false by default.Setting RPC option to true fixed the issue.
Right Click on the linked server and choose Server Options.Set RPC,RPC OUT to true.
After checking the linked server options I noticed that the RPC is set to false by default.Setting RPC option to true fixed the issue.
Right Click on the linked server and choose Server Options.Set RPC,RPC OUT to true.
No comments:
Post a Comment