How do I install a new instance of the 2005 engine?

I need to be able to add a new instance, we use to use svrnetcn with 2000.

To add an instance you need to run setup and choose a named instance to install.

Svrnetcn.exe is (quoting BOL 2000) “The Server Network utility is used to manage the server Net-Libraries”. On SQL 2005 similar functionality is provided by SQL Server Configuration Manager: http://msdn2.microsoft.com/en-US/library/ms174212.aspx

Regards,

Boris.

|||So far I have only found how to add already existing instances, I have to actually create one.|||

Could you please give more details?

Is running setup, selecting install SQL Server Database Engine and then Advanced, then Named instance and giving it a new name does not work for you? If not, why not?

Boris.

|||

Sorry Boris, my browser setting weren't letting me run the auto setup. the new dvd is a little different and the setup.exe I was choosing in the explorer window wasn't installing the engine. I found the right one though.

I still have a question from this experience, is there no way to do this from a command line like we did with the msde instance?

|||

Take a look at this topic:

How to: Install SQL Server 2005 from the Command Prompt

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

Regards,

Boris.

|||Thanks for the help