Error : Msg 7411, Level 16, State 1 Server is not configured for RPC
This was annoying error which was fixed by Jr. DBA, whom I am personally training at my organization. I think he is going to be great programmer. He worked in my organization for more than 8 months. I finally have decided to coach him myself. When I encountered this error, I gave him task to figure this out himself. I absolutely gave him no direction and very few min to fix this problem. As you might have guessed without using internet help (as there is no help online available for this error) he found the solution.
Go to ServerInstance and follow next two diagrams. They are self-explanatory. Turn on the RPC from False to True.
Reference : Pinal Dave (http://blog.SQLAuthority.com)