October 2, 2007 at 4:09 am
iam trying to do a local replication
i have two databases
jb1 and jb2
i want to update a single table with some fields into database of jb2
for that iam doing replication
but iam always getting error of distribution_admin
----------------
Error 18483: Could not connect to server db1 because "distributor_admin" is not is not
defined as a remote login on the server.
----------------------------
to resolve it i creatd distributor_admin manually and also given it all the role rights, but still it doesnt work
some where i saw that to resolve it u need to change the servername, but iam against changing the servername, as iam afraid that it may create lot of problems
when i run this query
select @@servername,SERVERPROPERTY('ServerName')
---
LOCALHOST,JOBDHUNDOSERVER
-----------
i get the following result, can any 1 tell me what can i do to resolve this
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
November 6, 2007 at 2:28 pm
I can only assume you have a seperate dedicated distributor.
The passwords must match on both servers for distributor_admin sql login... if you don't know password - change at both locations to match. Visit Publisher Properties and make pwd same as sql login.
Hope this helps.
ChrisB MCDBA
MSSQLConsulting.com
Chris Becker bcsdata.net
November 7, 2007 at 2:07 pm
Are the tables in jb1 and jb2 identical and you want to keep them that way with replication? If that is the case, why don't you just create a view in jb2 of the table in jb1?
Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply