Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    99

    Unanswered: Installing A Default Instance AFTER a Named Instance???

    I have SQL Server 2000 Standard Edition (sp3a) running on a windows 2003 (sp4) Server.

    It is a Production Server with 3 NAMED Instances and NO Default Instance.

    Does anyone know if I can rerun the SQL Server Install and add a DEFAULT Instance to this box without disrupting the other Named Instances???

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Except for a reboot after the install, you should have no problems installing a default instance.

  3. #3
    Join Date
    Mar 2004
    Posts
    99
    Thank you : )

  4. #4
    Join Date
    Mar 2004
    Posts
    99
    Will the default instance automatically have the name of the Server - or is there a way to give it name - like you would a named instance.. sorry if the question sounds stupid.. : )

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The default instance will have the name of the server. The only way around this that I can think of off the top of my head is to give the machine a DNS alias.

  6. #6
    Join Date
    Mar 2004
    Posts
    99
    Thanks !!! I'm not so much worried about the name as I am Blowing up the Server by installing a Default Instance AFTER it has already been populated with Named Instances.

Posting Permissions

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