title: SQL Linked server - Remote access error when executing SP
body: <p>I've set up a linked server between an instance on SQL 2012 and SQL 2008R2 but 
  I keep getting the below error when trying to execute a stored procedure on a remote server: </p>
  
  <pre><code> Msg 7201, Level 17, State 4, Line 1
  Could not execute procedure on remote server 'TEST' because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access.
  </code></pre>
  
  <p>I've checked on both servers and they're configured to allow remote connections. The login that I've used has sysadmin access on the remote server and I can see all the databases when I expand 'Catalogs' within the linked server. When I test the connection this also says it's connected successfully. The SQL Service account also has SA on both instances for what it's worth  </p>
  
  <p>The odd thing is when I run a simple select query on one of the tables within the database it shows a result but it doesn't seem to like the SP. </p>
  
  <pre><code>Select * from Linkserver.database.dbo.table 
  </code></pre>
  
  <p>The above works fine but this SP doesn't: </p>
  
  <pre><code>EXECUTE  Linkedserver.database.[dbo].[SP] ....
  </code></pre>
  
  <p>Any recommendation would be appreciated. </p>