How to Create a New Instance in SQL Server

by Lysis

Microsoft has developed a unique way of segregating databases by using named instances. An MSSQL instance is a separate program that runs on a server, and it groups databases within its own memory and processes. When using a named instance in SQL server, the client and administrators must specify the named instance, unlike regular connections where you need only the server name and database. Set up SQL Server named instances from the installation screen.

1

Choose either the default instance name or choose to setup your own named instances from the Named Instance screen. SQL Server allows only one default name, so if you need several named instances, choose the Named Instance option.

2

Enter the name of your instance. You may name the instance anything, but naming restrictions apply; for example, you can't use special characters or reserved programming names and the name must begin with a letter.

3

Choose to detect installed instances. This option locates all the instances installed on your SQL Server network to ensure there are no duplications.

4

Choose an instance ID. By default, the name you used for the instance is used for the ID. You can change this setting by giving the new instance a different ID. The ID is used in the registry and for file identification.

5

Choose a root folder. By default, SQL Server installs the files in the root of the SQL Server executable file folder. You can select a different path for instance files at this window.

Tip

  • check The default named instance for SQL Express is "SQLEXPRESS" during installation. When connecting to this instance on your local machine, add ".\\SQLEXPRESS" (without quotes) to the connection string to find the database.

About the Author

Lysis is the pen name for a former computer programmer and network administrator who now studies biochemistry and biology while ghostwriting for clients. She currently studies health, medicine and autoimmune disorders. Lysis is currently pursuing a Ph.D. in genetic engineering.