Ad

How To Install/register More Than One Instances In SqlServer

- 1 answer

Is it possible to install/register another local server instance in any SqlServer version, besides the default local instance, where only one SqlServer version is installed?

Ad

Answer

Yes, it's possible. I have several combinations in my servers. I have one server that has both SQL Server 2000 and 2005 installed side by side. My desktop at work is a Windows 2003 Server, and I have SQL Server 2005 and 2008 installed side by side.

What you want is called a named instance. There will be a screen during the install, where you will be able to give it a name.

Ad
source: stackoverflow.com
Ad