uninstall default instance

  • Hello

    i have a default instance in SQL server 2000 and a named instance in SQL Server 2005 (the two instances are on the same server).

    I need to uninstall the default instance , because i do not use SQL Server 2000 any more.

    When i uninstall the default instance will my SQL server 2005 instance become a default instance by default? or do i have to do something?

    and about the new name of the SQL Server 2005 instance (if it passes by default to default instance) will it change?

    Tks,

    Pedro

  • The named instance will not become a default instance automatically, nor can it be renamed. The way to make the SQL 2005 instance the default instance would be to intall a default SQL 2005 instance and backup/restore or detach/attach the databases .

    Greg

  • Hi, You need to do the following in order to install the SQL Server 2005 default instance.

    First you need to uninstall the SQL Server 2000 default instance.

    Then install the SQL Server 2005 default instance by choosing that as an option during the installation process.

    Hope this helps...

    Cheers,

    Basit Ali Farooq
    MCITP Database Administrator
    Microsoft Certified Professional Developer (Web Applications)
    Microsoft Certified Database Administrator
    Microsoft Certified Systems Engineer
    Microsoft Certified Systems Administrator
    CIW Security Analyst
    Cisco Certified Network Associate

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply