Thursday, October 3, 2013

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
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.

No comments: