error 18483 & 18482



Hi ,


At first i was trying to set up replication where i got the Error 18483:
could not connect to server 'SQL1; because 'distributor_admin' is not defined
as a remote login at the server.

as per some of the posting i used "Select @@Servername" (e.g SQL2)and found
that the name returned is not the same as the computer name(e.g SQL1)

so i executed sp_dropserver @@Servername (SQl2)

now when i tried to configure it as a publisher , it gives me "could not
configure SQL1 as the distributor for SQL1. error 18482 : could not connect
to SQL1 because 'SQL2' is not defined as a remote server

i have tried sp_addserver SQL1 but it does not work either

kindly advise

tks & rdgs

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200512/1
.



Relevant Pages

  • Re: Error for a job that uses a MSDASQL linked server
    ... the job step that calls the remote stored procedure saved on SQL1. ... The related login has to be present in SQL1 and SQL2. ... linked server on db server SQL1. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Remote Server issue...
    ... production server to my reporting server. ... I have replication from sql1 to sql2. ... I noticed that there is already a remote server setup on ...
    (microsoft.public.sqlserver.security)
  • Re: Error for a job that uses a MSDASQL linked server
    ... the job is, i.e., on the server where you define the linked server. ... Tibor Karaszi, SQL Server MVP ... The related login has to be present in SQL1 and SQL2. ...
    (microsoft.public.sqlserver.server)
  • Re: Error for a job that uses a MSDASQL linked server
    ... Tibor Karaszi, SQL Server MVP ... to SQL1. ... that calls a remote stored procedure saved on SQL1. ...
    (microsoft.public.sqlserver.server)
  • Multi Instance Cluster Question
    ... Its SQL 2000 EE on ... Windows Server 2003 EE ... one ..in my case SQL2.. ... a default instance was named as SQL1. ...
    (microsoft.public.sqlserver.clustering)