error 18483 & 18482
- From: "maxzsim via SQLMonster.com" <u14644@uwe>
- Date: Wed, 07 Dec 2005 10:16:02 GMT
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
.
- Follow-Ups:
- Re: error 18483 & 18482
- From: maxzsim via SQLMonster.com
- Re: error 18483 & 18482
- Prev by Date: Re: Initialize from backup files.
- Next by Date: Re: error 18483 & 18482
- Previous by thread: Eliminate a table
- Next by thread: Re: error 18483 & 18482
- Index(es):
Relevant Pages
|