July 25, 2013 at 2:53 am
Hi,
One of our Client requests to move away from the default SQL port, if that is port on 1433
Can any one tell me what is the procedure to change the port for sql.
what are the steps to follow for the communication between the DB and the application server ?
On SQL server 2005 insatnce
Many Thanks,
July 25, 2013 at 3:33 am
Go to Start > programs > Microsoft SQL Server > Configuration Tools > SQL configuration manager > expand SQL Network Configuration > Protocols for 'instancename' > right click tcp\ip > IP addresses tab > Put a custom port number in the TCP PORT section right at the bottom.
Restart SQL Server instance.
in the connection string for your app, just put Servername, portnumber
July 25, 2013 at 4:02 am
Thanks for reply,
In ipadress tab, i could see Tcp port column on IP1,IP2,IPALL .
Please clarify do i need to change only TCP Port column on IPAll or i need to update all 3 .
What should be the value of tcp dynamic port
Thanks,
July 25, 2013 at 4:16 am
as you would imagine.. changing the port in IPALL Will make the change apply to them all 🙂 So just change it here.
Leave dynamic port blank.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply