How to fix : Server is not configured for RPC.

.Net SqlClient Data Provider: Msg 7411, Level 16, State 1, Line 3

Server name is not configured for RPC.

 

If you receive an error something like this most likely is from the Linked server its because when you try to run a remote procedure call like stored procedures.. Linked server setup should have RPC enabled

In order to fix this change the Linked server properties

EXEC sp_serveroption ‘server_name’, ‘rpc’, ‘true’;

EXEC sp_serveroption ‘server_name’, ‘rpc out’, ‘true’;

or we can change usi SSMS GUI interface

 

Reomote procedure linked server

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s