CODEWITHSUNDEEP
sql-serversql-server-2016
DeeJay007
DeeJay007

Reputation: 509

SQL server database port parameter in configuration file

I am trying to install SQL Server 2016 using configuration file. Instead of using Instance name, I am trying to use database port (1433) to install the Server. The parameter name for Instance name in the configuration file is INSTANCENAME. Could someone tell what is the database port parameter name?

I see parameters like COMMFABRICPORT and MATRIXCMBRICKCOMMPORT, but I am not sure if it is the database port which I am looking for.

Upvotes: 1

Views: 2207

Answers (1)

José Luiz
José Luiz

Reputation: 333

The port 1433 are default on SQL Server. You don't need change if you want to use this port, but, remember, you can change the port on SQL Server Configuration Manager.

If you Need to generate the configuration file, please follow this step:

How to generate a configuration file

  1. Insert the SQL Server installation media. From the root folder, double-click Setup.exe. 
Note
SQL Server Express Edition setup does not create a configuration file automatically.

The following command will start setup and create a configuration file.

SETUP.exe /UIMODE=Normal /ACTION=INSTALL

  1. Follow the wizard through to the Ready to Install page. The path to the configuration file is specified in the Ready to Install page in the configuration file path section.

  2. Cancel the setup without actually completing the installation, to generate the INI file.

This steps will create a configuration file for you.

Upvotes: 2

Related Questions