How to add a named SQL Server 2008 R2 instance

Introduction

This posting walks through the steps necessary for installing a named instance of SQL Server 2008 R2 to an existing default instance.  Total time to completion is approximately 25 minutes.  This procedure was performed on a virtualized Windows Server 2008 R2 SP1, hosting a default instance of SQL Server 2008 R2 SP2.  The development network is hosted on VMware Workstation 7.X and has Internet connectivity.  Take note of step 11, below: this is the critical step for installing a named instance.

Procedure

1. Load and launch the SQL Server 2008 R2 installation. SQL Server Installation Center dialog appears:
   
2. Click New installation or add features to an existing installation.  The first page of the SQL Server 2008 R2 Setup wizard appears:
   
3. Click Install. Setup performs a system check: 
   
4. Click Next.  The Installation Type page appears:
   
5. Select New installation or add shared features, and then click Next.  The Product Key page appears:
   
6. Enter the product key or select evaluation, and then click Next.  The License Terms page appears:
   
7. Check the I accept the license terms, and then click Next. The Setup Role page appears:
   
8. Select All Features With Defaults, and then click Next.  The Feature Selection page appears:
   
9. Check/uncheck desired features, and then click Next.  Setup runs installation rules and then presents the results:
   
10. Click Next.  The Instance Configuration page appears:
    
11. Select Named instance, and then enter the Instance ID (i.e., name) for the new instance.  For this posting, the named instance is called SQL2:
    
12. Click Next.  The Disk Space Requirements page appears:
    
13. Click Next.  The Server Configuration page appears:
    
14. Configure accounts as needed. For this posting, the System account was used:
    
15. Click Next.   The Database Engine Configuration page appears:
    
16. Click Add Current User.  This will most likely already be added.
17. Click the FILESTREAM tab and configure this for possible dev exploration in the future:
1. Check Enable FILESTREAM for Transact-SQL access.
2. Check Enable FILESTREAM for file I/O streaming access.
   
18. Click Next.  The Analysis Services Configuration page appears:
    
19. Click Add Current User, to add the current account:
    
20. Click Next.  The Reporting Services Configuration page appears:
    
21. Select Install, but do not configure the report server, and then click Next. The Error Reporting page appears:
    
22. Click Next.  The Installation Configuration Rules page appears:
    
23. Click Next again.  The Ready to Install page appears:
    
24. Click Install.  Installation takes approximately 20 minutes.
25. Click Close.
26. This completes installation of a new named instance of SQL Server 2008 R2 to an existing default instance on the same server.
27. Optional: Verify successful installation and configuration:
1. Launch SQL Server 2008 R2 Management Studio.
2. Connect to the new instance.  For this posting, the named instance server name is: SPDEV11\SQL2.
   
28. Click Connect.  The Management Studio will appear and is connected to the named instance:
    
29. This concludes this procedure.

Summary

This posting presented a step-by-step procedure for installing a named instance of SQL Server 2008 R2 to an existing default instance.  For additional detail on the topics presented here, please consult the references below.

References

• Microsoft TechNet: SQL Server 2008 R2
• Instance Configuration
• About SQL Server Agent
• SQL Server Browser Service

Notes

• This walkthrough was performed in preparation for setting up a new SharePoint Server 2013 instance on the same network as an existing 2010 instance in preparation for migration testing.  The 2013 instance will employ the named instance.