{"id":6597,"date":"2022-03-03T06:30:00","date_gmt":"2022-03-03T05:30:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=6597"},"modified":"2022-11-10T11:34:02","modified_gmt":"2022-11-10T10:34:02","slug":"install-second-instance","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/dba\/install-second-instance\/","title":{"rendered":"Install a second instance of SQL Server"},"content":{"rendered":"\n

How to install a second instance of SQL Server?<\/em><\/strong><\/h4>\n\n\n\n

During the first installation of SQL Server, there are two options for the instances, te first option is to install the default instance, the other option is to install a named instance. To install another instance, follow the steps below and adapt according to the SQL Server configuration.<\/p>\n\n\n\n

Add multiple additional instances to a SQL Server<\/h2>\n\n\n\n

To do this, run the installation from the executable and install the new instance of the RDBMS : SQL Server Database Engine. With a SQL Server Developer<\/a>, Standard or Enterprise version, SQL Server names the instance MSSQLSERVER<\/em><\/strong> by default. However, the name of the named instance is free.<\/p>\n\n\n\n

One default instance named MSSQLSERVER per server<\/h2>\n\n\n\n

Furthermore, with the SQL Server Express<\/a> Edition, run the installer twice. Then rename the new instance with a name other than the default instance, i.e. SQLExpress<\/em><\/strong>. If installing an additional database instance is impossible, then an interesting alternative is to create another database in the existing instance!<\/p>\n\n\n\n

Indeed, simply use SQL Server Management Studio with the right privileges or a SQL script. To go further, find out here how to create a database using SSMS and no SQL script<\/a>. When connecting to a default instance, specifying the instance name is not necessary.<\/p>\n\n\n\n

\nhttps:\/\/expert-only.com\/en\/sql-server-db\/display-sql-server-detailed-version-with-a-query\/\n<\/div><\/figure>\n\n\n\n
How to create an instance with SQL Server ?<\/strong>

To create a new database instance with SQL Server, you just have to restart the SQL Server installation utility and choose a named instance.<\/p> <\/div>

What is the name of the default SQL Server instance ?<\/strong>

In SQL Server, the default instance which is installed at first, is named MSSQLSERVER<\/strong>.<\/p> <\/div>

What is the port number of the default instance in SQL Server ?<\/strong>

The default listening port in SQL Server is the 1433 <\/strong>port number. Change it using the SQL Server Configuration Manager tool available on the server hosting your instance.<\/p> <\/div> <\/div>\n\n\n\n

To conclude, it is possible to easily install a new instance with SQL Server 2019 for example.<\/p>\n\n\n\n

MS database tutorials<\/h4>\n\n\n\n