Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    3

    Unanswered: Replication on cluster Problem (SQL 2000)

    Config :
    2 database servers SQL 2000, running with OS Windows 2000 Advanced Server. Set in a cluster.

    Prob :
    I want to replicate some data from my database for reporting issues.
    Now when i go trough "Configure Publishing and Distribution Wizard"
    and use the "defaults", i always seem to have this error :
    "Error 18483 : Could not connect to server XXX because 'distributor_admin' is not defined as a remote login at the server"

    Cause this doesnt work, i tried to "set the distribution properties ...", in the "Configure Publishing and Distribution Wizard". At the Screen with "Provide Distribution Database Information", i have this nice line on the bottem :
    "The paths must refer to disks that are local to 'XXX' and begin with a local drive letter and colon (for example, C. Mapped drive letters and network paths are invalid."

    Now since i am using a cluster, and the whole database (all .mdf, ...) are on the network drives, this is a big problem.

    Is there any way arround this ?

  2. #2
    Join Date
    Jul 2003
    Posts
    1

    Re: Replication on cluster Problem (SQL 2000)

    Do you register the server with the exact server name NOT the IP address in the Enterprise Manager Console?
    If you didn't , the problem was encountered.
    You should register with the servername.
    Use the following query:
    Select @@SERVERNAME
    to get the Servername.
    I'm sure you can miss it!


    Originally posted by Sublimo
    Config :
    2 database servers SQL 2000, running with OS Windows 2000 Advanced Server. Set in a cluster.

    Prob :
    I want to replicate some data from my database for reporting issues.
    Now when i go trough "Configure Publishing and Distribution Wizard"
    and use the "defaults", i always seem to have this error :
    "Error 18483 : Could not connect to server XXX because 'distributor_admin' is not defined as a remote login at the server"

    Cause this doesnt work, i tried to "set the distribution properties ...", in the "Configure Publishing and Distribution Wizard". At the Screen with "Provide Distribution Database Information", i have this nice line on the bottem :
    "The paths must refer to disks that are local to 'XXX' and begin with a local drive letter and colon (for example, C. Mapped drive letters and network paths are invalid."

    Now since i am using a cluster, and the whole database (all .mdf, ...) are on the network drives, this is a big problem.

    Is there any way arround this ?

  3. #3
    Join Date
    Jul 2003
    Posts
    3
    i have the real servername

    SO it isnt that. Main prob imo, is that i want to set the replication database on the clustered disk. And SQL-Server is being a bitch about it.

    Sub

Posting Permissions

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