How do I create a new instance using SQL Server 2005?

Posted on 2011-05-10
Last Modified: 2012-06-27
How in MS SQL 2005 create a new instance, without reinstalling MS SQL 2005 ?  I recently upgraded from SQl Server 2005 express to 2005 enterprise edition and I want to create a new instance.  I currentl have a 2005express instance called MyPC\SQLExpress.  I now want to create a new instance called something like My2005DB.  How can I do this?
Question by:Hojoformo
    LVL 9

    Accepted Solution

    You have to install SQL Server to create a new instance. However you can rename the existing instace using below commands

    For a renamed default instance, run the following procedures:

    sp_dropserver <old_name>
    sp_addserver <new_name>, local


    For a renamed named instance, run the following procedures:
    sp_dropserver <old_name\instancename>
    sp_addserver <new_name\instancename>, local
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Create instance need to install it again.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now