Results 1 to 6 of 6
  1. #1
    Join Date
    May 2004
    Posts
    14

    Unanswered: Is there a way to change the default instance?

    We installed SQL 7.0 first, then SQL 2000. SQL 7.0 is the default instance.

    How can we change the default to SQL 2000?

  2. #2
    Join Date
    May 2003
    Location
    Parsippany NJ
    Posts
    36
    No, SQL 7.0 would always be the defult one.

    If you want to make SQL 2000 to be the default one, remove the SQL 7.0

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I've never tried this, but I think that you can:

    1) Make a backup of everything on the machine, "as is"
    2) Verify to be sure it is readable.
    3) Take that backup off-site.
    4) Make another backup, just for good measure.
    5) Install a named instance of SQL 7.0
    6) Detach a user database (one at a time) from the unnamed instance of 7.0
    7) Attach the database files to the named instance
    8) Repeat 6-7 as needed
    9) Remove the unnamed instance of 7.0
    10) Install an unnamed instance of SQL-2000.

    -PatP

  4. #4
    Join Date
    May 2003
    Location
    Parsippany NJ
    Posts
    36
    SQL 7.0 cannot operate as named instance, only as default instance.

    As long as you have SQL 7.0 install, It's going to be the default instance no matter what.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Why, what is wrong with your installation that prevents a normal "named instance" of SQL 7.0 from running? With MS-SQL 6.5 you could only have one, unnamed instance.

    True, you can only have 16 instances total using 7.0 (unless you add more GUIDs), but that has never been a problem for me.

    -PatP

  6. #6
    Join Date
    May 2004
    Posts
    14

    You cannot have named instances in SQL 7.0

    SQL 2000 is the first version the supports named instances. In SQL 7.0 the name defaults to the computer name.

Posting Permissions

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