Setting up replication with virtual server name -- sql server replication

Peter
10/18/2006 12:35:33 PM

We are trying to setup merge replication on a virtual server, but it
keeps failing. We have run "sp_helpserver", "sp_dropserver
'localmachinename'", and "sp_addserver 'virtualservername', 'local'" to
ensure that SQL Server will use the virtual server name, but the setup
still fails. We have also tried adding the virtual server name as an
alias in the Client Network Utility.

Does anyone have any other suggestions on how to fix it so that we can
get the replication setup using the virtual servername?

We are on SQL Server 2000. The reason we need to use a virtual server
name is because we are using SteelEye LifeKeeper clustering software.
We have contacted them with support but so far their help has been
limited.

Thanks,
Peter

Hilary Cotter
10/18/2006 3:53:15 PM

Replication needs the netbios name to be whatever is returned by select
@@servername. So setting it to something different won't work.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server replication : Setting up replication with virtual server name