Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Location
    Sheffield, UK
    Posts
    17

    Question Unanswered: Connecting to an external server

    Hi,
    I have been developing an app using SQL Server 2000 and am ready to transfer to a server located offsite. How can I connect to this server through enterprise manager or anything else so that I can use the copydatabase wizard to move it to the live server?

    Thanks

    Wheelz

  2. #2
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    Perhaps I'm missing something here (wouldn't be the first time, I'll grant ya that ) but if it's on your server network, you just add the server to your "SQL Server Group" in the enterprise manager, and then you can transfer stuff willy-nilly.

    Right-click on the SQL Server Group in the console file system pane of the Enterprise Manager, then add the remote server.

    Like I said, I may be missing something, but if the remote server is accessable from your network, you oughta be good to go, I would think. :???:
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

  3. #3
    Join Date
    Dec 2003
    Location
    Sheffield, UK
    Posts
    17

    Too dumb I think

    Hi,
    I've done what you said and it offers me to register a new instance or a new group. Either one of these doesn't let me specify an IP address to the live server.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You should regiustering a server alias..

    And that has to be added.....to.....Damn a network question....

    I forget....

    But it's good to do this in case you have to flip th ip for disaster purposes....

    I'll go look...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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