Download Teebik PC FLV DDL Mobo Market

Learn to earn online!

Here you will find your way to earn through internet.

Hunza-Tech

Hunza-Tech shares the most updated information about how to earn online with its users. This website specifically focuses on Lates SEO / SMM Blogging and content monetization techniques.

Keep on visiting Hunza-Tech.

We constantly update you about the best available and latest Online Earning and Learning resources.

Make your blog / website more income generative!

Here we will be sharing our practical experience of effective SEO Friendly blogging techniques to drive more a traffic.

Hunza-Tech

Well planned Blog / Website with proper marketting returns well. We let you know about the effective blogging and SEO to get more from your blog.

Thursday, June 23, 2016

SQL Server - Creating Multiple SQL Server Instances on Single Server

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:
Installation Screen (First)
SQL Server 2008 R2 Installation Screen
Click “New installation or add features to an existing installation”, from the above window then, the following screen appears:

IN the above screen, you can see that SQLEXPRESS instance already exists on the machine, it was created by the first installation, to install another Instance of SQL server 2008 R2, now select “New installation or add shared features”. Then click Next and accept the License Agreement.
Then select features you want to install for the new instance.
After that the installation lets you specify the name of your new instance (SQLEXPRESS2 was chosen in this example):

Finally, Click Next to create the new instance and perform the remaining setup steps. You need to repeat these steps to create any required number of instances.