<div>
Use the SQL server configuration tool, and check the tcp configuration for the SQL server instance.
</div>


Use the SQL server configuration tool, and check the tcp configuration for the SQL server instance.

<div>
<div class="content wysiwyg-content">
We had an issue where our SQL 2008 Express server rebooted and for some reason it's no longer listening on tcp 1433.<br />
It has changed to 53300<br />
Can someone tell me how I can change it back to 1433?<br />
<br />
thanks
</div>
</div>


We had an issue where our SQL 2008 Express server rebooted and for some reason it's no longer listening on tcp 1433.
It has changed to 53300
Can someone tell me how I can change it back to 1433?

thanks

sql server is no longer listening on tcp 1433

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.