• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 414
  • Last Modified:

Add new instance to MSSQL 2005

I'm trying to add a new instance to my MSSQL 2005 server. I don't want to make any changes to the existing 2instances. When I run setup on the original installation media, at System Configuration Check I get this warning message...

- Edition Change Check (Warning)
Messages
Edition Change Check
 
To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.

I don't want to change anything, I just want to add the new instance. Can I safely ignore this warning? What settings or options should I choose during setup? Does anyone know of a step by step guide to adding a new instance?

Thanks,
Rick
0
RickKnight
Asked:
RickKnight
4 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
yes you can
0
 
dhobaleCommented:
simply run the installation disk and when it comes to specify an instance, make sure you name it different than default or the previous instace you have created. Everything else is same.
0
 
St3veMaxCommented:
As above; SQL Setup will detect the default instance is already installed; so will force you to specify the instance name.

HTH
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Hope this helps you with the complete installation of Named Instance:

http://www.exforsys.com/tutorials/sql-server-2005/installing-a-second-copy-of-sql-server-2005.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now