SQL Execution Distributed Query error "server: Message 7411, level 16, status 1, Row 1"

Server: Message 7411, level 16, status 1, Row 1
The server 'erpsyssoluts' is not configured for RPC purposes.

 

Solution:

(1)

Exec sp_serveroption 'srv _ lnk ', 'rpc out', 'true'
Exec sp_serveroption 'srv _ lnk ', 'rpc', 'true'

(2)

<1> sqlserver2000 in Enterprise Manager --> database --> Security --> link database --> click the link database you want to configure --> attribute page -->
"Server options" --> select RPC and RPC out.

<2> sqlserver2005: on Microsoft SQL Server Management studio --> Server Object --> connection server --> right-click the database you want to configure --> Select page, change the server option RPC and RPC out to "true".