Create new instance in sql server 2017 after installation

After installing SQL Server 2017, you can create a new instance by following these steps:

Method 1: Using SQL Server Configuration Manager

  1. Open the SQL Server Configuration Manager (SSCM) by searching for it in the Start menu or by navigating to C:\Windows\SQLServer\SQLServerManager15.exe (assuming you installed SQL Server 2017).
  2. In the SSCM, expand the "SQL Server Network Configuration" section.
  3. Right-click on "Protocols for [Instance Name]" (e.g., "MSSQLSERVER" for the default instance) and select "Add Server Alias".
  4. In the "Add Server Alias" dialog box, enter a new instance name (e.g., "MyNewInstance") and click "OK".
  5. Repeat steps 2-4 for each protocol you want to add (e.g., TCP/IP, Named Pipes, etc.).

Method 2: Using the SQL Server Installation Center

  1. Open the SQL Server Installation Center by navigating to C:\Windows\SQLServer\Setup.exe (assuming you installed SQL Server 2017).
  2. In the SQL Server Installation Center, click on "Maintenance" and then "Configure SQL Server".
  3. In the "Configure SQL Server" wizard, select "Add a new instance" and click "Next".
  4. Enter a new instance name (e.g., "MyNewInstance") and click "Next".
  5. Follow the wizard to complete the configuration.

Method 3: Using the Command Line

  1. Open a Command Prompt as an administrator.
  2. Run the following command to create a new instance:
    sqlservermanager15.exe -a -i <new_instance_name>

    Replace <new_instance_name> with the name you want to give your new instance (e.g., "MyNewInstance").

Verify the new instance

After creating the new instance, you can verify its existence by:

  1. Opening the SQL Server Configuration Manager (SSCM) and checking the "SQL Server Services" section.
  2. Running the following command in a Command Prompt:
    sqlcmd -S <new_instance_name>

    Replace <new_instance_name> with the name of the new instance. If the instance exists, you should see a SQL Server Management Studio (SSMS) prompt.

Note: Make sure to restart the SQL Server service after creating a new instance to ensure that the changes take effect.