The Open Data Services setup program installs the PROCSRV sample application on the same computer as SQL Server. Before you can use PROCSRV, you need to set up PROCSRV and SQL Server as described below.
SQL Server can communicate with PROCSRV using remote stored procedure calls in the same way it communicates with other SQL Servers on the network. When SQL Server communicates with the PROCSRV application, it uses client connection values to locate and connect to the application. Be sure that SQL Server is configured for the appropriate client connection values. For more information, see Network Setup Options for Open Data Services Server Applications.
On the SQL Server, use sp_addserver and sp_configure to identify the PROCSRV application as a remote server in the same way you would identify a SQL Server as a remote server. For example:
sp_addserver SERVNAME
provides SQL Server with remote access to the Open Data Services server application SERVNAME. For more information about sp_addserver, see the Microsoft SQL Server Administrator's Companion. For more information about sp_configure, see Microsoft SQL Server Setup.