Personal Notes of Edwin Eu

SQL Server – How to change SQL Server 2008 R2 database port

In Microsoft SQL Server on 06/15/2012 at 3:16 PM

Over the years, I learned that Microsoft SQL Server product has TCP/IP port configured to 1433 by default.    I strongly advised to change the SQL Server TCP/IP port to unique port number.  In addtion, It’s Microsoft Best Practice advised SQL Server database’s TCP/IP port to be changed.    Enclosed are the procedures how to change Microsoft SQL Server 2008 R2 database port.

  1. Go to SQL Server Configuration Manager –> Select Protocols for SQL01
  2. Right Click the TCP/IP –> Then go to Properties
  3. Click on IP Addresses –> Scroll down to TCP Port
  4. Then changed the TCP Port to unique number.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: