Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212

    Red face Unanswered: Replication Between Instances Issue.

    I'm doing Transactional Replication from Server1 to PC1.


    Server1 Info:
    Domain: A
    SQL Server 2000 Enterprise Edition SP3.
    SQL Server Services under Local System Account.

    PC1 Info:
    Domain: B
    SQL Server 2000 Developer Edition SP3
    SQL Server Services under Local System Account.


    The process I did in EM was:

    1. Create Remote Server to PC1 from Server1. Did not check RPC checkbox.Map all remote logins to same name. Did not check password.
    2. Created Publisher and Distributer on Server1.
    3. Publish new publication of DB1 in Server1.
    4. Push new subscriber , auto create DB1_copy in PC1.
    5. Snapshot successful.
    6. Distributor Agent Failed.

    Error Message:
    The process could not connect to Subscriber 'Pc1'.

    Error Details:
    Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
    (Source: PC1 (Data source); Error number: 18452)

    I have identical local WINNT ID's and password on both machine. I was guessing that would solve it. But it didn't.

    Previously I did snapshot and transactional replication on the same machine itself( Server1 only). It was succesful.

    Did I miss out anything?
    Has it got to do with any Remote Server setting?
    I've heard that Replication can only be done on the same domain. Is this true?
    What if there are cases of different domains? Or in a workgroup perharps?
    Or can it be overwritten by having 2 identical local WINNT ids in both machines?
    Lastly, Can Personal Edition SQL Server 2000 do replication?
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  2. #2
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    Help?
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  3. #3
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Replication Between Instances Issue.

    By not knowing your environment completely, I would suggest that you change your sql startup account from local system account to a network account. Use the same network account for both machine and, of course, it has to be admin in both machine.

    Good luck!

  4. #4
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    I've actually solve the problem and concluded by myself that replication can be done on separate domains or workgroups or whatever.
    As long as an IP can ping the other IP, it will work.

    During registration of Publisher and Subcriber, check "show advanced options" during the wizard. From there, there will be a section where u can click to chose Windows Authetication or SQL Server Login.

    Chose SQL Server Login during Publisher Wizard and also SQL Server Login during Subscriber Wizard. And voila!, that will solve the problem.

    However, again, this is thru test and fail method of solving a problem, are there any pointer anybody would like to share?
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •