So you want to host the website in seperate hosting? Check your cpanel if MSSQL extension is available for PHP, if not contact your hosting company.
The rest is as usual, add an exception for the hosting company's IP from your firewall and than configure the php script with real mssql settings. Also make sure that remote connection is enabled from mssql configuration manager.