SQL Server TCP Port

Taiwo Adejobi 1

some of the answered says to check IPAll TCP Dynamic Ports and be sure its blank, which is the case in my situation but I am still not able to get pass the error message.

1 answer

SunnyNiu-MSFT 1,701 Reputation points

2020-11-20T08:03:33.373+00:00

@Taiwo Adejobi
Thank you for posting in Microsoft Q&A forum.
First, after you set IPAll TCP Dynamic Ports to blank and set IPAll TCP ports to 1433, did you try to restart all SQL services for the SCCM instance?

Then, may we know the architecture of your SQL Server?
If you installed the x86 SQL Server, you may have this issue, you may try to reinstall x64 version to see if it helps.

If the response is helpful, please click "Accept Answer"and upvote it.
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.
Please sign in to rate this answer.
Taiwo Adejobi 1 Reputation point

2020-11-21T02:52:43.797+00:00

Hello,

Thanks a lot for the good responds.

Yes, I did restart all SQL Services for the SCCM instance without but I still kept getting the TCP port error. However, it was x86 SQL Server as you assumed. But how does this affect and create the persistence error in SCCM?

SunnyNiu-MSFT 1,701 Reputation points

2020-11-23T02:39:06.117+00:00

@Taiwo Adejobi
Microsoft's official documentation makes it clear that: Configuration Manager requires a 64-bit version of SQL Server to host the site database.
For more details, you may refer to :
https://learn.microsoft.com/en-us/mem/configmgr/core/plan-design/configs/support-for-sql-server-versions#sql-server-architecture-version
Thanks for your time.

If the response is helpful, please click "Accept Answer"and upvote it.
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.

SunnyNiu-MSFT 1,701 Reputation points

2020-11-26T09:35:22.67+00:00

@Taiwo Adejobi
It seems there is no update for a couple of days. May we know the current status of the problem? Is there any other assistance we can provide?
If the above responses help you, please click "Accept Answer".
Thank you!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SQL Server TCP Port

1 answer

Your answer