0

I have problem setting my replication between two servers on different locations (different network).

Steps I have done:

  • setup aliases in SQL Server Native Client configuration on both servers
  • setup ports on both server
  • created Windows accounts on both server and run SQL Server and SQL Agent under this account
  • created SQL Server users for replication with sysadmin permissions
  • checked that ports are opened and reachable
  • connected on both sides from Management Studio and connection works
  • I am almost sure that I have done this correct, because I have done it 100 times....

Then I made replication on publisher server using exact procedure as described here: http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/2/

In Replication Monitor I get error:

Error messages:
The process could not connect to Subscriber 'XXX'. (Source: MSSQL_REPL, Error number: MSSQL_REPL0)
Named Pipes Provider: Could not open a connection to SQL Server [53]. (Source: MSSQLServer, Error number: 53)
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (Source: MSSQLServer, Error number: 53)
Login timeout expired (Source: MSSQLServer, Error number: HYT00)

As I can see I have the same problem than in this post: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b5095a7f-e015-4086-a8cc-c31abb022aa4/transactional-replications-problem?forum=sqlreplication

But there were no solutions to it...

migrated from stackoverflow.com May 8 '15 at 8:08

This question came from our site for professional and enthusiast programmers.

1

Ok it was problem that Windows block cross domain connections.

Error in error log: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

I had to make new local Windows account and used it for replicaton snapshot agent. Solution

0

if the servers have adifrent DNS then the publisher could not reach to the subscription server.

tray to connect with Netbios Name or ip IpServername\Netbios name

hop this will help

Regev

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.