August 22, 2012 at 4:50 am
Hi all
I am having a little trouble getting a replication set up across domains to a named instance using a static port number.
The firewalls are open as I can connect from the client to the remote server. I am using a push subscription however it says it can not find the subscriber server\instance. I have tried using the named instance with and without the port number (the browser service is running) however I get the same error.
Has anyone managed to get this working previously?
Thanks
August 22, 2012 at 6:24 am
OK I have tried setting up an alias on my publisher (which connects fine when using SSMS) and using a push subscription connected to the subscriber using an SA account and it all creates fine. However after a generate a snapshot and initialise the subscription I get the error of:
Error messages:
The process could not connect to Subscriber 'SERVER\INSTANCE'. (Source: MSSQL_REPL, Error number: MSSQL_REPL0)
Get help: http://help/MSSQL_REPL0
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. (Source: MSSQLServer, Error number: -1)
Get help: http://help/-1
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: -1)
Get help: http://help/-1
August 22, 2012 at 6:31 am
OK I seem to have fixed it, I had created the Alias under the 32bit client as this was the one that was working when testing with SSMS, however the replication required the alias to be created under the 64bit client.
Weird that SSMS didn't work when I originally created this under the 64bit client, it must be that SSMS is 32bit only!?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply