<div>
So if I select 4010 and then in my connection string put that number in then it knows to find it with that port number? &nbsp;would there be any impact if another server on the network had the same port number?
</div>


So if I select 4010 and then in my connection string put that number in then it knows to find it with that port number?  would there be any impact if another server on the network had the same port number?

<div>
Both answers were excellent.
</div>


<div>
<div class="content wysiwyg-content">
The security folks are telling me I have to change the default port for my sql server from 1433. &nbsp;I am not sure how to do this and also after I do it how will a client connect through a web interface to the sql database. &nbsp;Any links that explain this for sql 2008 R2 would be appreciated. &nbsp;Can I pick any port number or do I have to get a specific one or range I should pick from.
</div>
</div>


The security folks are telling me I have to change the default port for my sql server from 1433.  I am not sure how to do this and also after I do it how will a client connect through a web interface to the sql database.  Any links that explain this for sql 2008 R2 would be appreciated.  Can I pick any port number or do I have to get a specific one or range I should pick from.

sql server 2008 r2 changing default port

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.