Remote stored procedure

[Ravi]

Hi All,

I need to execute the stored procedure/sql statement from different sql server.I have described below, what i have done to do this...if it is not the correct process, please let me know the correct one.....thanks


I have added the remote server on local server by using the following....

EXEC sp_addlinkedserver @srvproduct = 'any',
@server = 'server_name',
@provider = 'MSDASQL',
@provstr = 'DRIVER={SQL Server};SERVER=dsnname;UID=user_id;PWD=password;&# 39;
GO

I have added the remote login by using the following:

EXEC sp_addremotelogin 'server_name', 'user_id', 'user_id'


when I tried to execute the stored procedure, am getting the following error:

exec server_name...sp_solution_details

error:
Server: Msg 7411, Level 16, State 1, Line 1
Server 'inprodb0201' is not configured for RPC.







getting error:
Server: Msg 15429, Level 16, State 1, Line 0
'(null)' is an invalid product name.

[Sue]

Hi,

Linked servers are configured only for data access by default. You have to specify RPC and RPC out if you want to do Remote Procedure Calls.

From Enterprise Manager - open the server - open the Security folder - expand Linked Servers - right click your linked server and choose properties then check on RPC and RPC out check boxes.


------------
Ravi at 1/22/01 11:41:09 AM

Hi All,

I need to execute the stored procedure/sql statement from different sql server.I have described below, what i have done to do this...if it is not the correct process, please let me know the correct one.....thanks


I have added the remote server on local server by using the following....

EXEC sp_addlinkedserver @srvproduct = 'any',
@server = 'server_name',
@provider = 'MSDASQL',
@provstr = 'DRIVER={SQL Server};SERVER=dsnname;UID=user_id;PWD=password;&# 39;
GO

I have added the remote login by using the following:

EXEC sp_addremotelogin 'server_name', 'user_id', 'user_id'


when I tried to execute the stored procedure, am getting the following error:

exec server_name...sp_solution_details

error:
Server: Msg 7411, Level 16, State 1, Line 1
Server 'inprodb0201' is not configured for RPC.







getting error:
Server: Msg 15429, Level 16, State 1, Line 0
'(null)' is an invalid product name.