SP_HELPSERVER - Status yields no Data Access

Last Post 20 Aug 2007 01:18 PM by leohalim. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
leohalim
New Member
New Member

--
20 Aug 2007 11:24 AM
I'm troubleshooting a problem with linked servers. I ran the SP_HELPSERVER and the results yielded several servers all having status of "rpc, rpc out, Data Access" except on the server that I'm having problem. It does not list "Data Access" on the status column.

I checked the properties of the linked servers including the problem server, and the data access in the Server Options is checked.

How do I enable the data access on the problem server?

Leo
leohalim
New Member
New Member

--
20 Aug 2007 01:18 PM
Yes. It does the same version and sp level as the others. thanks.


Acceptable Use Policy
---