Solved

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

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

805 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