Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL Publication Question

Posted on 1998-08-20
1
180 Views
Last Modified: 2010-03-19
When setting up publishing, I am getting an error when accessing the manage subscriptions dialog box. I see the server I have setup for publishing, but when I click on it , I get an error stating "Unable to connect to site <SERVERNAME> because it isnot defined as a remote server at the site." If I look at sp_helpserver, or the SERVER/REMOTE SERVERS dialog box, I see the server listed. Help...what have I done wrong ?
0
Comment
Question by:waltersw
1 Comment
 
LVL 2

Accepted Solution

by:
connex earned 100 total points
ID: 1089655
You need to Check the RPC-Option in the Server->Remote Servers
Option.


0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question