Solved

Replication Error: SQL Server does not exist or access denied. (Source: MSSQLServer, Error number: 17)

Posted on 2008-06-12
3
1,025 Views
Last Modified: 2011-10-31
Here is my setup. 3 sql servers.
Publisher: sql 2000
Distributor: sql 2000
Subscriber: sql 2005

Publisher can push the data to the distributor. A snapshot is generated successfully. However when replication starts from distributor to subscriber it fails givng the following message:

SQL Server does not exist or access denied. (Source: MSSQLServer, Error number: 17)

Publisher and distributor are on the same domain. Subscriber is on a different domain. Using sql logins for all the servers.

Please let me know if you need any further info.

Thank you.
0
Comment
Question by:itxtech
[X]
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
  • 2
3 Comments
 

Accepted Solution

by:
milankuzmanovic earned 500 total points
ID: 21776854
What about sql agents services  login?
Are they on local acount. They should be on same account.
0
 

Expert Comment

by:reddy16
ID: 37060873
s
0
 

Expert Comment

by:reddy16
ID: 37060883
I have the same issue. Does anyone have solution for this?
0

Featured Post

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

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

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

710 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