Results 1 to 4 of 4

Thread: Server registration in sql

  1. #1
    Join Date
    Sep 2004
    Posts
    23

    Server registration in sql

    hi ,

    i am trying to upgrade from sql 7 to sql 200 .. i am doing a new clean install using the copy database wizard.

    both sql 7 and sql 2000 are on different server connected on the network.

    the problem i am facing is that i am not able to see the sql 7 server under the source database.

    i have tried doing a new registration on sql 7 .. it does not seem to show up.

    i have tried using the ip address. does not work

    could you tell me how i can register the sql 7 server so that it is visible to all the other servers on the network..

    thanks,

    ggupta

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Why don't just backup db from sql7 then restore it on sql2k?

  3. #3
    Join Date
    Sep 2004
    Posts
    23
    i want to use the copy database wizard. acyually i am testing all the various methods of upgrading

    i have already tried the backup and restore

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    What's sql service startup account on sql2k server? Checked 'Upgrading Databases from SQL Server 7.0 (Copy Database Wizard)' in books online?

Posting Permissions

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