Can I install SharePoint without the default port in SQL Server i.e 1433?

Question

Can I install SharePoint without the default port in SQL Server i.e 1433?

Shuvajit Roy 166

I want to install SharePoint server 2019 . By default the SQL server communicates through port 1433.

I want to change the port and make a customize port for SharePoint and SQL server communication so that SQL server communicates through the customized port only.

Scenario 1: I want to change the port first and than install SharePoint server in the customized port. How can I archive this?

Scenario 2: I have SharePoint server installed already with SQL server communicating through port 1433. How can I change the port now? If so, any impact in SharePoint functionality changing the default port?

Accepted answer

1 additional answer

Your answer

Answer 1

Hi @Shuvajit Roy ,

Great to know that and thanks for sharing the update here.

By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

[Can I install SharePoint without the default port in SQL Server i.e 1433?]

Issue Symptom:
I want to install SharePoint server 2019 . By default the SQL server communicates through port 1433.

I want to change the port and make a customize port for SharePoint and SQL server communication so that SQL server communicates through the customized port only.

Scenario 1: I want to change the port first and than install SharePoint server in the customized port. How can I archive this?

Scenario 2: I have SharePoint server installed already with SQL server communicating through port 1433. How can I change the port now? If so, any impact in SharePoint functionality changing the default port?

Current status:
To install SharePoint with customized port, we have to put the alias without the port separated by commas.

With this setup SharePoint successfully installed with alias and customized port.

You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community members to see the useful information when reading this thread. Thanks for your understanding!

Answer 2

Yanli Jiang - MSFT 31,606 Microsoft External Staff

Hi @Shuvajit Roy ,

For Scenario 1, you can change the port number for SQL Server before installing SharePoint Server 2019 by following these steps:

Open SQL Server Configuration Manager.
Expand SQL Server Network Configuration and select Protocols for MSSQLSERVER.
Right-click TCP/IP and select Properties.
Go to the IP Addresses tab and scroll down to the IPAll section.
Change the TCP Port value to your desired port number and click OK.
Restart the SQL Server service.

After changing the port number for SQL Server, you can proceed with installing SharePoint Server 2019 and specify the new port number during the installation process.

For Scenario 2, you can change the port number for SQL Server after installing SharePoint Server 2019 by following the same steps as above. Changing the port number should not have any impact on SharePoint functionality as long as you update the connection string and any other relevant configuration settings to reflect the new port number. It is recommended that you test the changes in a non-production environment before making them in a production environment.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Shuvajit Roy 166 Reputation points

2023-07-03T11:59:54.1566667+00:00

Hi @Yanli Jiang - MSFT ,

For Scenerio1:

would you tell me the point where I can specify the default port during SharePoint installation? I Installed SharePoint many times but I don't see place where I can specify SQL customized port.

For Scenario 2:

I changed the port after installation but sadly SharePoint stopped performing. Tested in dev environment though.
Yanli Jiang - MSFT 31,606 Reputation points Microsoft External Staff

2023-07-04T02:28:55.0766667+00:00

Hi @Shuvajit Roy ,

For Scenario 1, during the SharePoint Server 2019 installation process, you will be prompted to enter the SQL Server instance name and database name. You can specify the SQL Server instance name with the customized port number by using the following format: ServerName,PortNumber. For example, if your SQL Server instance name is SQLServer and the customized port number is 1234, you would enter SQLServer,1234 in the installation wizard.

For Scenario 2, changing the SQL Server port after installation can potentially cause issues with SharePoint functionality. Some SharePoint features and components may rely on the default SQL Server port, and changing the port can cause those features to stop working. It's recommended to test any changes in a development or test environment before making them in a production environment. Additionally, you will need to update any connection strings or configurations that reference the SQL Server instance to use the new port number. If SharePoint has stopped performing after changing the SQL Server port, you may need to investigate the error logs and troubleshoot the issue.
Shuvajit Roy 166 Reputation points

2023-07-05T10:36:53.7166667+00:00

Hi @Yanli Jiang - MSFT ,

I attempted installing with customized port, but faced an error.

"BBL_SHP-DBNEW" is my SQL alias name pointed to two DB servers.

can u suggest any solution to overcome the issue? the error logs does not show anything relevant to resolve the issue.

Telnet from APP Server:

telnet (DC server) 1575 --> Open
telnet (DR server) 1575 --> Open
telnet bbl-shp-dbnew(alias) 1575 --> Open
Yanli Jiang - MSFT 31,606 Reputation points Microsoft External Staff

2023-07-06T02:38:04.4266667+00:00

Hi @Shuvajit Roy ,

I found a way you can have a try:

Enter in the below format (if there is only one instance of SQL in the database server) (append '\MSSQLSERVER' after the Database Server Name followed by the coma and the port number)

Database server: BBL_SHP-DBNEW\MSSQLSERVER,1575

Database name: SharePoint_Config

For more details, please see this blog of Fahad Mohamed Sidheekh:

http://www.sharepointpitstop.com/2013/10/server-nameport-is-invalid-or-loopback.html

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
Yanli Jiang - MSFT 31,606 Reputation points Microsoft External Staff

2023-07-14T08:58:45.01+00:00

Hi @Shuvajit Roy ,

I haven't heard from you for a long time, I am very worried. I wonder if after trying the previous method, the problem is solved. Or you have other concerns about the issue. Please don't hesitate to let me know about any situation. I'm happy to work with you to get this out of the way.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Yanli Jiang - MSFT 31,606 Reputation points Microsoft External Staff

2023-07-27T09:31:00.68+00:00

Hi @Shuvajit Roy ,

Time flies, I am checking to see if there is any progress on the thread. Did the previous method work? Any questions feel free to contact us. :-)

If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Yanli Jiang - MSFT 31,606 Reputation points Microsoft External Staff

2023-08-02T09:42:07.5266667+00:00

Hi @Shuvajit Roy ,

Is there any progress on this issue. Whether the answer helps you?

If there is any problem with this issue, feel free to let me know.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Shuvajit Roy 166 Reputation points

2023-08-08T07:10:11.6166667+00:00

Hi @Yanli Jiang - MSFT ,

Sorry to reply u so late. However, I was very busy with projects and supports.

Well, to install SharePoint with customized port, we have to put the alias without the port separated by commas.

With this setup SharePoint successfully installed with alias and customized port.

Nevertheless, thank you very much for all the suggestion and recommendations u provided to have the issue resolved and also following up for the update of the issue.

Share via

Can I install SharePoint without the default port in SQL Server i.e 1433?

1 additional answer

Your answer