"Faisal" <fharoon@akunet.org> wrote in message
news:%23x4oAjZuDHA.4056@TK2MSFTNGP11.phx.gbl...
> hi,
> Servers Configs: Win2K with SP4, SQL Server 2K with SP3
> I'm setting up replication b/w two servers, one is on my pvt. n/w while
the
> other one is on internet. When I tried to configure Publishing,
Subscribers
> and Distribution... I get
> Error 18483:
> Could not Connect to XXX Server because distributor_admin is not defined
as
> a remote login at the Server
> I've checked both servers are responding to each other. A clue I got from
> internet is that by both hostname and @@servername should be same, in my
> case they are not. By running @@servername I get "ABC1" instead of "ABC".
> However I used sp_addserver to add "ABC" and restarted sql server but
> @@servername is still showing only "ABC1"
> Immediate help is appreciated in this regard.
> regards,
> Faisal
> Sr. Programmer / Analyst
> Information Systems Dept.
> Aga Khan University
>
>

"koohyar[MSFT]" <anonymous@discussions.microsoft.com> wrote in message
news:B1B73EC7-0E06-4CFE-85FF-A909580F960B@microsoft.com...
> Don't forget to restart SQL Server services after you rename the SQL
Server.
>
> This posting is provided "AS IS" with no warranties, and
> confers no rights.
> http://www.microsoft.com/info/cpyright.htm