Remote Stored Procedure

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;'
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.