Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1034
  • Last Modified:

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

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
itxtech
Asked:
itxtech
  • 2
1 Solution
 
milankuzmanovicCommented:
What about sql agents services  login?
Are they on local acount. They should be on same account.
0
 
reddy16Commented:
s
0
 
reddy16Commented:
I have the same issue. Does anyone have solution for this?
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now