New Publication

Hi,
I'm trying to set up a new publication on a Veritas Cluster/SQL Server 2005.
The problem i'm having is that sql server reports that in order to do that
"SQL Server replication rquires the actual server name to make a connection
to the server. Connections through a server alias, IP address or any other
alternate name are not supported"
When you run sql on a cluster you virtual names set up. How do i get aroud
this?
Regards
Michael
do this
xp_cmdshell 'hostname'
then do this
select @.@.servername
these should be the same. If not you must do the following
sp_dropserver @.server='OldServerName'
sp_addserver @.server='CorrectServerName', @.local='LOCAL'
As you are on a cluster I am not exactly sure how this is going to work.
Hilary Cotter
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
"Michael_Sergel" <MichaelSergel@.discussions.microsoft.com> wrote in message
news:26053401-B617-4E56-A359-80CB8CDD67D8@.microsoft.com...
> Hi,
> I'm trying to set up a new publication on a Veritas Cluster/SQL Server
> 2005.
> The problem i'm having is that sql server reports that in order to do that
> "SQL Server replication rquires the actual server name to make a
> connection
> to the server. Connections through a server alias, IP address or any other
> alternate name are not supported"
> When you run sql on a cluster you virtual names set up. How do i get aroud
> this?
> Regards
> Michael