Allow remote access to SQL Server

You may need remote access to SQL Server from client machines or for SSMS from remote location
When the port (1433) is opened in the firewall please make sure to allow only restricted IP to the ports.
To allow remote access to SQL server kindly use the below commands
EXEC sp_configure ‘remote access’, 1 ;

GO
RECONFIGURE WITH OVERRIDE;

GO

After configuring please restart SQL server
On Linux servers please use the below command:
sudo systemctl restart mssql-server
Allow remote access to SQL Server