[Last Call] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2011-05-10
Medium Priority
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

Accepted Solution

kaminda earned 2000 total points
ID: 35734942
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
ID: 35736084
Create instance need to install it again.

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

830 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