• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1038
  • 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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