Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

local replication Expand / Collapse
Author
Message
Posted Tuesday, October 2, 2007 4:09 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 18, 2012 1:09 PM
Points: 347, Visits: 50
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





For IT jobs click here

*Sukhoi*
Post #405473
Posted Tuesday, November 6, 2007 2:28 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 11, 2014 7:22 PM
Points: 222, Visits: 246

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



Post #419327
Posted Wednesday, November 7, 2007 2:07 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 21, 2012 3:13 PM
Points: 516, Visits: 1,563
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



Post #419764
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse