Hey guys

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('74.98.56.21','user','password');
mssql_select_db('database');

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.

Thanks