Hello Friends, I am developing one application in php and its Database is SQL 2005 and same time it working perfectly at localhost and having no problem but when i upload to windows server and try to connect with SQL SERVER THEN send me this error Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 64.50.162.71 in c:\domains\rockersinfo.com\wwwroot\update\driver\includes\functions\database.php on line 5 PHP: CLICKE HERE TO CHECK OUT AT MY SERVER PLEASE HELP ME OUT....THANKS ALL OF YOU
check the server for remote accessing.. or if the script is uploaded with the same server where the db is, just use localhost
there is a chance that mssql_connect function is not enabled in php. Put a phpinfo page and check if mysql is allowed in php.
Check your php.ini and uncomment the mssql lines. If you're on windows you should be able to connect once you do this.
If not using "localhost" as your servername/address, then you will have to enable remote sql connections. How to configure SQL Server 2005 to allow remote connections http://support.microsoft.com/kb/914277