Cannot configure replication

• shanila_minnu

  Hall of Fame

  Points: 3465

  More actions

  February 8, 2011 at 4:57 am

  #148343

  when trying to configure replication,i am getting the below error.my server name is gimldnsps315.but select @@servername is giving the output as 'GARTMORE-748E90'.But when i try connecting via 'GARTMORE-748E90'.its not allowing.Please help me

  ERROR

  ======

  SQL Server replication requires 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. Specify the actual server name, 'GARTMORE-748E90'. (Replication.Utilities)

• avinashily

  Say Hey Kid

  Points: 661

  More actions

  February 8, 2011 at 7:36 am

  #1283677

  hi shanila,

  i think you are using the sql server default instance, right. if so,

  your system administrators might have changed the server name after installing the sql server.

  you can check it with this command.

  select @@servername

  sp_helpserver

  if both the queries give you different names then you need to drop the server name in the sql server and recreate it with

  sp_dropserver 'old server name'

  sp_addserver 'new server name', 'local'

  and then restart the server agent.

  try to do replication now. i think it should work.