I have 2 servers... OTTO is located on site, and connected to domain It is running SQL 2008. I have created the database, in SQL 2000 compatability mode.
WEBDB3 is located in datacenter, not connected to our domain. It is running SQL 2000
DMZ set up between two sites, on Firewall.
I've created a transactional publication on OTTO I then set up a subscription to WebDB3.
After snapshot is initialized, i get this error if i right click and select View Synchronization Status:
The process could not connect to Subscriber 'WEBDB3'.
If i open Replication monitor:
Error messages: The process could not connect to Subscriber 'WEBDB3'. (Source: MSSQL_REPL, Error number: MSSQL_REPL0) Get help: http://help/MSSQL_REPL0 Named Pipes Provider: Could not open a connection to SQL Server . (Source: MSSQLServer, Error number: 53) Get help: http://help/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) Get help: http://help/53
PREVIOUSLY there was a server called NavisionUpgrade. This was set up very similar, and replication worked.
What am I doing wrong? I've spend HOURS on this, and am pulling my hair out!