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?