SOAP Endpoint accessing SP on another server
-
2012年7月24日 18:17
I am creating a SOAP endpoint* on SQL Server 2008 (Enterprise x64) R2 SP1. I would like for its webmethods to access stored procedures on another SQL Server box. When I try to use a 4-part fully qualified object name for the sproc, I get the error:
Msg 7819, Level 15, State 1, Line 22
The SOAP method object 'myserver\myinstance.mydb.myschema.mysproc' must be specified using a fully qualified three-part name.
Is this really true that I cannot access another server for the webmethod or am I just not specifying the object name correctly? Thanks for any help.
*Yes, I know they are deprecated.
すべての返信
-
2012年7月24日 18:24
*Yes, I know they are deprecated.
And in SQL Server 2012 finally removed.
You have to create a route to the other server, see CREATE ROUTE (Transact-SQL)
Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing -
2012年7月26日 13:57
You have to create a route to the other server, see CREATE ROUTE (Transact-SQL)
Do you know if it is possible to do this with a linked server construct? We have that already in place and I am being pushed to use that if at all possible. (I tried it again with the link in place, but I still get the "fully qualified three-part name" error.)
