Hi all

1. When i try to set up Transactional Replication, our Machinename+Dbinstance name is more than 30 Characters. Then we are getting error Error 14234 : the specified '@server' is invalid. (Valid values are retrieved by sp_helpserver)

2.Then We registered with IP+DBinstance name, when we try to set up Transactional Replication we got error Error 18483 : Could not connect to server. 'xxxxxxxx' becuase 'distributor_admin' is not defined as a remote log in at the server

Please Advise me, Thnaks In Advance

Hi Benhur,

You should check two things in sp_helpserver:
1. The server name is correct.
2. The ID for that server must be 0.

If either of these is incorrect, please use sp_dropserver and sp_addserver
to correct the problem. You'll have to restart the SQL Server service for
the changes to take effect.

You should not use an IP address in replication. That's probably causing
the 18483 error message. The wizard cannot create the remote server if an
IP address is being used.

Regards,
Shirley
SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.