Creating Multiple SQL Server Instances on Single Server
When you install SQL Server, the installation by default creates an instance of SQL Server. But the question is how to create multiple instances?
Once you have installed SQL Server and have the default (or named) instance, start the setup again to create a new instance.
When you run SQL Server 2008 R2 Express setup, the following screen appears:
SQL...