Results 1 to 1 of 1
Thread: mssql_connect problem on windows
Dec 17, 2008, 02:05 #1
- Join Date
- Jul 2004
- Cape Town, South Africa
- 48 Post(s)
- 0 Thread(s)
mssql_connect problem on windows
Im not sure how to explain this, but I will try my best:
I have a 2 windows dedicated server hosting an asp.net website. I also have some pages of the site which is PHP (The latest version of PHP that comes with WAMP 2.0
I have the following code to make the connection:
$con = mssql_connect('126.96.36.199','user','password');
this works fine if the db is on the same machine, but as soon as i try and connect to another server it gives me this error:
Login failed for user 'DEVSERVER\IUSR_DEVSERVER'
The problem is that its trying to connect from the internet guest account which does not have permission instead of the user account that I am providing. I have tried googling, but most solutions i find involve changing the php.ini:
mssql.secure_connection = Off
which i have done and restarted IIS so it accepts the changes.
phpinfo() shows that the changes have been changed, but I still get the same error.
So now I have no idea what to do.
If anyone can shed some light on the matter that would be greatly appreciated.