Hi guys,
I have finally been granted a SQL dev server for a POC for a reporting/BI/DW solution for the coming years.
I am trying to setup replication from our current production servers to this new server, I'm having no problems connecting and creating a subscription database for SQL instance which exist in our domain, although those that exist in our sub-domain I'm having issues with. Some stats in regards to the sub-domain instances are:
Full domain trust exists.
I can ping through FQDN's
I can connect with SSMS using FQDN's
The FQDN is 'HKDBSRV01.asia.CompanyXZY.corp'
I have created an Alias, connected successfully through SSMS, but it fails on attempting to connect to publisher for replication.
On a different SQL 2000 instance I have a subscriber already connected and replicating for the past 6 months.
When trying to select the publisher I am getting the error:
SQL Server Replication requires the actual server name to make a connection to the server.
Connects through a server alias, IP addres, or any other alternate name are not supported.
Specify the actual server name 'HKDBSRV01'(Replication.Utility)
This issue is very similar to that of Post: http://qa.sqlservercentral.com/Forums/Topic415693-291-1.aspx
Although in this case creating an alias does not work.
Any suggestions or work arounds, has anyone had similar experiences?
Cheers.