by I am developing an ODS based server using the PROCSRV example as a model.
If I run Procsrv on the same machine as SQL Server, it all works fine, as
per the documentation. However, I want to debug the ODS Server which
ideally means running on it my development machine, not the server.
The ODS Server is set to listen on a named pipe, I have used SQL client
configuration to set up an alias to the application on my development
machine. I can connect to the ODS server with ISQL running on the SQL
server and run the extended procedures. I can see the named pipe using
readpipe
from the SQL server machine.
But, when I try to call the sp from my database using:
use master
sp_addserver procsrv
exec procsrv...proclist
all I get back is the error ->
Msg 18481, Level 16, State 2
Unable to connect to site 'PROCSRV' because it is unavailable or does not
exist.
Anybody got any suggestions??
Thanks
Richard