How to add a new Named Instance in SQL Server

How to add a new named instance in SQL Server

In this tutorial, we will be looking at how to add a new Named Instance in SQL Server. The version that we will be installing is SQL Server 2016 Developer edition. According to Microsoft’s websiteAn instance of the Database Engine is a copy of the sqlservr.exe executable that runs as an operating system service. Each instance manages several system databases and one or more user databases. Each computer can run multiple instances of the Database Engine. Applications connect to the instance in order to perform work in a database managed by the instance.

Now that we know what an instance is, let’s get into how to add a new named instance in SQL Server.

How to add a new Named Instance in SQL Server

  1. Locate and launch your SQL Server installation application , namely setup (setup.exe)
  2. A popup User Account Control might appear, click yes to proceed. How to add a new named instance in SQL Server, User Account Control
  3. In the new window that appears (SQL Server Installation Center) select installation on the left. In the right panel select “New SQL Server stand-alone installation or add features to an existing installation“. New SQL Server stand-alone installation or add features to an existing installation
  4. A new window should appear (SQL Server 2016 setup). The left panel is the navigation panel and the right panel is where you will make your configurations. Because we are adding a new named instance, we want to ensure that Perform a new installation of SQL Server 2016 is selected, then click next. Perform a new installation of SQL Server 2016
  5. We should now be at the Product Key window. In my case I will be installing the Developer Edition. If you have a Production Product Key, enter it and click next. See our other post them makes mention to SQL Server Edition (How to easily downgrade SQL Server from Enterprise to Developer/Standard Edition). Sql server product key window
  6. On the License terms screen, check the I accept the license terms and Privacy Statement and click Next.
  7. Next on the Feature Selection screen, under instance Features on the right check the Database Engine Services box and click Next. You may select additional features base on your needs, but for the purpose of this tutorial i will only be selecting Database Engine Services. On this screen you can also change the Instance root directory, which is defaulted to the C drive. Sql Server Feature Selection window
  8. Next we will be taken to the Instance Configuration screen, this is where we will be naming our new instance. Enter the new instance name in the Named Instance section and click next. Sql Server Instance Configuration window
  9. After clicking next we will be taken to the Server Configuration screen. This is where you will configure passwords for the database services, I will be leaving mine as the defaults. Beside the Service Accounts tab is the Collation tab. This is where you can change the server’s collation if needs be. Click Next.
  10. Next on the Database Engine Configuration screen, we will be configuring Authentication mode, SA accounts, Data Directory etc. In our example we will be selecting Mixed Mode and setting a password, also we will be adding the current LDAP user an Administrator. We can leave the other tabs as default, for the data directory SQL Server will install the instance on the C drive. It is recommended to put both data and log file on separate drives. Click Next. SQL Server Database Engine Configuration window
  11. On the Ready to Install screen Click Next.
  12. On the next screen, the installation should begin. Let it run to completion.
  13. Congratulations you’ve successfully installed a new instance on you existing SQL Server. Now it’s time to utilize it. To connect to the new instance, open management studio and select connect > database engine. In the new window that appears enter the servername\instancename (.\instancename also works if you are on the server that has the database installed) your credentials and then hit connect. Connecting to new SQL Server instance GIF