MsSql connection to dedicated server assistance needed

[vbcoach]

Hey guys & gals!  I could use some assistance here.

My hosting provider is switching me from an older web server that had PHP on MsSql (2000) all on one box, to a new server with now a dedicated MsSql (2008) server.  That's cool, and I can take advantage of the upgraded features.  However I am at a crossroads here.  My previous connection settings were pretty straight-forward:

    /*
     * MsSQL settings
     */
    define ( "MSSQL_SERVER"   , "localhost" );
    define ( "MSSQL_USER"     , "xxxxxxxx" );
    define ( "MSSQL_PASSWORD" , "xxxxxxxxx" );
    define ( "MSSQL_DATABASE" , "mydatabase" );

Well guess what?  Now I am not connecting.  I have tried adding the IP address instead of localhost as the new SQL server is separate and dedicated.  Certainly not an expert on these things, so I could use some assistance in generating the new connection string.

Can anyone offer assistance please?

 

[kicken]

Changing the server from localhost to the IP should be all you need. Make sure the username/password/dbname are the same and didn't get changed (or update your settings accordingly). If it won't connect you'll need to post what the error your getting is (or perhaps just email your host for support).

[vbcoach]

I tried changing to IP.  No joy.  I can connect to it via SSMS without issue.  My ISP says this is a coding issue and has just told me to "google it".  All I know is that I get zero output, so is there a quick, down, and dirty way to create or test connections for connectivity via php?

[Barand]

If you are changing from SQL SERVER 2000 then your going to need the new dll from Microsoft (2005 onwards)

 

http://msdn.microsoft.com/en-us/library/cc793139%28v=sql.90%29.aspx

[vbcoach]

Doubt that is the case.  This would be an ISP issue, and he has dozens of clients.

[vbcoach]

Do I need to add the port number to the IP in the connection string?  i.e. 12.345.56.78,1433  ???