Solved

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

Posted on 2008-06-12
3
1,026 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

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

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…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

623 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