problem connecting to mssql IIS win2k

[discobean]

I've got a small issue,

I have one server running mssql2k, another server running php..
both servers running win2k server.

I can connect to the mssql server via IIS and PHP, but when running the same script through the command line, the connection fails.

eg. mssql_connect("10.0.0.1", "user", "pass");

this works via IIS, not via command line.

ALTHOUGH..

If I run the same script on the mssql server, (ie. script and server on the SAME machine) the script connects with no problems.

But I don't want that.. I want 2 different machines, connecting via command line.

Any ideas would be great, its killing me.

Mariusz. 😕

[robsevcik]

I Think your probleb is in accounts under which you run the commands. IIS has an account (see directory security setting) which can connect to sql (I hope). from command line it runs as you and may be you cannot conn.