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.