SP_HELPSERVER - Status yields no Data Access

Last Post 20 Aug 2007 12:18 PM by leohalim. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
leohalim
New Member
New Member

--
20 Aug 2007 10: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 12:18 PM
Yes. It does the same version and sp level as the others. thanks.
You are not authorized to post a reply.

Acceptable Use Policy