Connecting to hosted MS SQL DB with PHP
<p>The front end of my website runs on PHP.  It is hosted on a shared hosting platform run by Verio.  The back end is a MS SQL database which is also hosted Verio's platform.  </p>

<p>Verio which was recently bought by Endurance International Group Hldgs Inc (EIG).  My site's files were migrated automatically to EIG's servers.  The connection to the MS SQL database broke when that happened.    </p>

<p>One of the files on my website is a settings.php file.  Prior to Verio's migration to Endurance's servers, the connection string I used for the 'DB_SERVER' global variable in that settings.php file was '198.170.241.132,1433\SQLExpress1'  That box is going offline soon and my site has been migrated so I need to connect to a database on the new servers.</p>

<p>I've been able to create a MS SQL database on Endurance's servers through their web portal. However Endurance support tell me they can't give out an IP address for the server the database is hosted on. I'm trying to figure out how I would connect to the server without an IP address.</p>

<p>The file settings.php on my website contains  connection info which I tried to update to the following (being the details of the database I set up through the new web portal) to see if it would work.  It did not work:</p>

<pre><code>$GLOBALS['DB_DATABASE']='mydbnamegoeshere';
$GLOBALS['DB_SERVER']='VCNSQL102';
$GLOBALS['DB_USERNAME']='myusernamegoeshere';
$GLOBALS['DB_PASSWORD']='mypasswordgoeshere';
$GLOBALS['DB_VENDOR']='MSSQL';
</code></pre>

<p>There is a knowledgebase article on Verio's site discussing how to connect to the servers, however it is written for ASP.NET websites, not PHP sites.  Furthermore it does not specify the IP of the server that MS SQL databases are hosted on.  The knowledgebase article is here: <a href="http://www.verio.com/knowledgebase/beta/article.bml?ArticleID=1829" rel="nofollow noreferrer">http://www.verio.com/knowledgebase/beta/article.bml?ArticleID=1829</a></p>

<p>Any suggestions on the correct settings to use (and where to put them) would be most welcome.</p>