vbcoach Posted May 3, 2013 Share Posted May 3, 2013 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? Quote Link to comment https://forums.phpfreaks.com/topic/277588-mssql-connection-to-dedicated-server-assistance-needed/ Share on other sites More sharing options...
kicken Posted May 3, 2013 Share Posted May 3, 2013 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). Quote Link to comment https://forums.phpfreaks.com/topic/277588-mssql-connection-to-dedicated-server-assistance-needed/#findComment-1428003 Share on other sites More sharing options...
vbcoach Posted May 3, 2013 Author Share Posted May 3, 2013 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? Quote Link to comment https://forums.phpfreaks.com/topic/277588-mssql-connection-to-dedicated-server-assistance-needed/#findComment-1428038 Share on other sites More sharing options...
Barand Posted May 3, 2013 Share Posted May 3, 2013 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 Quote Link to comment https://forums.phpfreaks.com/topic/277588-mssql-connection-to-dedicated-server-assistance-needed/#findComment-1428042 Share on other sites More sharing options...
vbcoach Posted May 3, 2013 Author Share Posted May 3, 2013 Doubt that is the case. This would be an ISP issue, and he has dozens of clients. Quote Link to comment https://forums.phpfreaks.com/topic/277588-mssql-connection-to-dedicated-server-assistance-needed/#findComment-1428049 Share on other sites More sharing options...
vbcoach Posted May 3, 2013 Author Share Posted May 3, 2013 Do I need to add the port number to the IP in the connection string? i.e. 12.345.56.78,1433 ??? Quote Link to comment https://forums.phpfreaks.com/topic/277588-mssql-connection-to-dedicated-server-assistance-needed/#findComment-1428051 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.