I am using sql server 2008 r2 on windows server2003 with sql server management studio. I want to create more than one instances of sql server for some activity. Is it possible to create more than one instance of server and if yes than how to create this? please provide some joyfull solution.
If you already install one instance already.Insert the sqlserver cd and following the wizard. 1. The most important section of the installation process that address your problem is:Instance Configuration window. There you select the radio button that says:Name Instance. 2. You specify the name of your instance and continue to your configuration. 3. You can access your instance like this:Your pc name \yourinstancename 4. IF you have issue during login, you shall consider starting sqlserver browser service