Post reply

Setting up the distributor

  • August 20, 2003 at 2:47 am

    #82222

    I'm having a bit of trouble setting up my distributor on a server and was wondering if anyone can help.

    I'm trying to replicate Database1 on Server1 to Database2 on Server1.

    When I go through the wizard and try to set up Server1 as it's own distributor, it comes back at me with the following message:

    Error 18483: Could not connect to server Server1 because 'distributor_admin' is not defined as a remote login at the server.

    Any help will be grateful?

    Thanks

  • August 20, 2003 at 1:26 pm

    #470654

    There is no problem in setting the distributor in the same server that the subscriber and the publisher, so you should't have any problem. I would run the wizard to set up the distributor. If it continues failing check if the distributor_admin login was created.

  • August 21, 2003 at 6:58 am

    #470752

    Perform the following task:

    ONE: Run this in QA and check to make sure that Server1 has srvid = 0

    use master

    go

    select * from sysservers

    go

    TWO: If ONE did not give you srvid = 0 for Server1, then run the followig code

    Use master

    exec sp_dropserver 'repl_distributor','droplogins'

    exec sp_dropserver 'Server1','droplogins'

    exec sp_addserver 'Server1','local'

    Note: You MUST restart MSSQLSERVER Service in order for these changes to take effect.

    THREE: Run ONE again to check the srvid = 0

    Then use the wizard to set up the replication again. I had the same problem and this resolved it for me. Hope it works for you.

  • August 21, 2003 at 7:22 am

    #470756

    Yaweah, Thank you, thank you, thank you.

    It worked.

    Dave

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply