greedyh4mster

Here is an update of the situation that I am in. I have tried to adjust the local security policy: Applying Everyone permission to anonymous users. But with no success. I have also tried to change the MS SQL server's port to 80, and get mssql_connect to connect. However I get an error message in the server's event viewer, when I tried different ways of putting in the port number for mssql_connect. The php script I used to generate the error: mssql_connect('69.162.105.186:80','useruser1','sai12ram'); The error is the following: This gives me a deduction that remote mssql_connect over at my webhost's ends, is doing fine. But the problem is over at the ms sql server. Doesnt seems to be a network issue since the error is generated when I tried different ways of putting in the port number, shows that the packet has reached the server. It rather seems to be an issue with MS SQL Server 2005. Somehow, it is rejecting the connection. I have seen quite a number of people having permissions problem as well. However, I have no idea what do they meant by that. Anyone has a clue?

Yup! I have tried the IP address. However, hostname is not configured on the server though. I have tried the IP address, both with or without the instance name. The werid thing is that I am able to connect remotely through the RazorSQL. But through php script, it is unable to. So i thought it might be the host's problem, in this case; Hostgator. But apparently, their technical support told me otherwise. I have checked the web again, and found possible solution posted by someone in php.net. It says that I will have to go adjust the security settings in the local security policy, and apply the group: Anonymous Users into Everyone. I have not tried the solution yet though. But I will when I reached home.

Hi! I have problem connecting to a remote MSSQL server 2005, using PHP hosted by hostgator. The error is the following: Php host (Hostgator): Active Persistent Links - 0 Active Links - 0 Library version - FreeTDS mssql.allow_persistent - On mssql.secure_connection - Off Remote MSSQL Server 2005: Windows Server 2003 R2 x64 Firewall disabled Remote Connection - Enabled Mixed - Windows and SQL Authentication These are the following test cases that I have done: 1) Able to use RazorSQL, mssql gui tool, connect to remote server. This is done on my personal computer. 2) Scanned ports on remote server. Result shown that the port, 1433 is opened. This is done via my personal computer and one other computer. I have also requested Hostgator to check on their ends whether connections to remote mssql servers are allowed, and or working. The reply was that they have checked my account, and confirmed that the problem is not on their side. I have researched into the problem and found something interesting, however I am unsure whether is it applicable in my case. If the above quote is true. If I upgrade to MS SQL Server 2008 Express Edition, will it solve the problem? Is there any other ways which I could try? Or anybody has similar problems with me? Thanks a lot in advance!