April 9, 2008 at 6:59 am
Hi guys
hope someone can help.
I would like to centrally collect data from my remote servers - including MSDE and SSE to my central 'master' 2005 server.
I have created the linked servers fine to MSDE, checked the sp_configure option for remote access (it is set to 1) and all seems fine.
I can query tables on the remote servers and execute stored procedures using Select * from openquery(server, stored proc)
I cannot however seem to get it to work using 4 part naming
eg. exec server...sp_configure and every variant therein fails, whereas if i stick it in the openquery it works
error is
could not execute procedure on remote server 'server' because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access.
Any help you can offer would be most appreciated
Regards
Ross
April 9, 2008 at 7:36 am
Look at the RPC settings on your linked servers.
April 9, 2008 at 7:40 am
could you be more specific as to what i am looking for?
Why would would the openquery work in that circumstance?
April 9, 2008 at 7:43 am
Just for information, the RPC service is running on these servers
R
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply