0

How to change MSSQL Port from 1433 to 1533 in Centos. My hosting provider has blocked the port 1433 in their network.

I have installed the MSSQL with this command.

sudo yum install -y mssql-server

Configuration file is at opt/mssql/bin/mssql-conf setup

I want to access it with ServerIPAddress,1533 from management studio out side of server.

0

Following command has fixed my issue.

sudo /opt/mssql/bin/mssql-conf set tcpport 1533

sudo systemctl restart mssql-server

sudo firewall-cmd --zone=public --add-port=1533/tcp --permanent

sudo firewall-cmd --reload

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.