SQLTeam.com | Weblogs | Forums

Sql port number changed

What will check application team while changed SQL static port number. After the user connects the application can not working. So please help me with what to do in the SQL Server.

What is the new port being used and what is the connection string settings in the application

I will change the SQL port number for security reasons. So if I changed the SQL port we need to add an connection string in front end.

Yes we must unless the new port is the default port 1433. You need to add connection string to any app if you want to work with sql server

Ok thank you for the advice Yosiasz.

Also, make sure that the new port is allowed from the firewall side.
just, do a telnet from the app server to test.

2 Likes

Ok, thanks, Ahmed.