Results 1 to 8 of 8

Thread: SQL2000, installing default instance after named instance

  1. 04-13-2007, 09:38 AM #1
    culture
    culture is offline Registered User
    Join Date
    Apr 2007
    Posts
    1

    SQL2000, installing default instance after named instance

    Hi all,

    Hopefully a simple question. Is it a problem (safe) to install the default instance after you installed a named instance? I have a server running only a named instance...
    Reply With Quote Reply With Quote
  2. 04-13-2007, 11:19 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Should be ok althouhg people tend to install default instance first.
    Reply With Quote Reply With Quote
  3. 04-18-2007, 09:38 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    no problem encountered when I installed like that
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  4. 04-19-2007, 01:45 PM #4
    Owais
    Owais is offline Registered User
    Join Date
    Jun 2006
    Posts
    28

    SQL Server Instance

    Just to test it I installed the Default instance on SQL server 2000 successfully. However when i tried to uninstall default instance it just removed all the SQL server components i.e. Management Tools like Enterprise Manager, SQL Profiler etc.

    I uninstalled the default instance using Add or Remove program feature in Control Pannel. After removing the default instance I still see the other computer instance but not the Management tools.

    Can someone help me out here. Also I would appreciate if someone can elaborate about the disadvantages of installing the 2nd instance on the server.
    Reply With Quote Reply With Quote
  5. 04-19-2007, 02:17 PM #5
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    I guess you just did click click and click.

    Just install only the client portion.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  6. 04-19-2007, 02:17 PM #6
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    I guess you just did click click and click.

    Just install only the client portion.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  7. 04-19-2007, 02:17 PM #7
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Did you chose named instance in SQL Server setup wizard to uninstall?. By default it uninstalls default instance. If you have more than one instance then you need to run it again.
    Reply With Quote Reply With Quote
  8. 04-19-2007, 03:45 PM #8
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Owais, you can install sql client tools again. To have multiple instances on single server, the server should be power enough to handle those instances.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules