Solved

SQL Publication Question

Posted on 1998-08-20
1
182 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to handle time out inside the stored procedure 10 28
How to keep a record with the highest value 3 44
Parsing this XML works but the other one doesn't 9 30
sql query 5 44
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
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…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

696 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