Windows 2k3 sp2 and mssql error

am 09.07.2007 17:11:43 von Zleviticus

------=_NextPart_000_000F_01C7C219.F0B62BB0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

I am perplexed with an issue that i need help on. I have searched and can
not find a resolution and can not find out what is going on.

Here is the situation:

I have a windows 2003 Server running IIS 6, php 5.2.1
I have another windows 2003 server running mssql 2000 with all the latest
service packs.

i am using a php script via a web page to access data on the server and
display it. when i run the page i get the standard:
Warning: mssql_connect() [
function.mssql-connect]: Unable to connect to server: 192.168.1.9

I can connect to the sql server via the php script if i run it from my
client in my editing software.

What can i do at thins point to troubleshoot and get it to work. It was
working prior to an installation of sp2 for win2k3

uninstalling sp2 is not an option.

------=_NextPart_000_000F_01C7C219.F0B62BB0--

Re: [PHP-WIN] Windows 2k3 sp2 and mssql error

am 10.07.2007 03:19:24 von bedul

sry if i mistaken

----- Original Message -----
From: "Zleviticus"
To:
Sent: Monday, July 09, 2007 10:11 PM
Subject: [PHP-WIN] Windows 2k3 sp2 and mssql error

> I am perplexed with an issue that i need help on. I have
searched and can
> not find a resolution and can not find out what is going
on.
>
> Here is the situation:
>
> I have a windows 2003 Server running IIS 6, php 5.2.1
> I have another windows 2003 server running mssql 2000 with
all the latest
> service packs.
i think i will called the first as A and the second as B

------------------------------------------------------------
>
> i am using a php script via a web page to access data on
the server and
> display it. when i run the page i get the standard:
> Warning: mssql_connect() [

> function.mssql-connect]: Unable to connect to server:
192.168.1.9
where do you execute this script?? on A or B?
i notice 192.168.1.9 was B right??
--------------------------------------------------
> I can connect to the sql server via the php script if i
run it from my
> client in my editing software.
there were another ?? well are this on A or the new one.

i think the problem are on the permision in B.
you should create an user (example)

user: Bedul
Host: %
password: bedul

then when u want to connect this.. try using user Bedul

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-WIN] Windows 2k3 sp2 and mssql error

am 10.07.2007 03:19:24 von bedul

RE: Windows 2k3 sp2 and mssql error

am 10.07.2007 14:35:44 von Zleviticus

Ok Let me detail the setup more.

A. windows 2k3 server sp2 with php 5.1
Contains the script running via IIS 6

B. windows 2k3 server sp2 with mssql 2000 sp4?

C. My windows xp machine

When I run the script from server A using any username and password
including sa account from A it fails. If I run the script from my editing
software on my local machine it runs fine. If I run another script that
connects up to B using the same settings, not through IIS. (Using php from
command line) it works fine.

-----Original Message-----
From: bedul [mailto:landavia81@gmail.com]
Sent: Monday, July 09, 2007 9:19 PM
To: Zleviticus; php-windows@lists.php.net
Cc: php-db@lists.php.net
Subject: Re: [PHP-WIN] Windows 2k3 sp2 and mssql error

sry if i mistaken

----- Original Message -----
From: "Zleviticus"
To:
Sent: Monday, July 09, 2007 10:11 PM
Subject: [PHP-WIN] Windows 2k3 sp2 and mssql error

> I am perplexed with an issue that i need help on. I have
searched and can
> not find a resolution and can not find out what is going
on.
>
> Here is the situation:
>
> I have a windows 2003 Server running IIS 6, php 5.2.1 I have another
> windows 2003 server running mssql 2000 with
all the latest
> service packs.
i think i will called the first as A and the second as B

------------------------------------------------------------
>
> i am using a php script via a web page to access data on
the server and
> display it. when i run the page i get the standard:
> Warning: mssql_connect() [

> function.mssql-connect]: Unable to connect to server:
192.168.1.9
where do you execute this script?? on A or B?
i notice 192.168.1.9 was B right??
--------------------------------------------------
> I can connect to the sql server via the php script if i
run it from my
> client in my editing software.
there were another ?? well are this on A or the new one.

i think the problem are on the permision in B.
you should create an user (example)

user: Bedul
Host: %
password: bedul

then when u want to connect this.. try using user Bedul

--
PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Windows 2k3 sp2 and mssql error

am 10.07.2007 15:00:25 von Niel Archer

Hi

I know very little about IIS, but I do know that "it fails" doesn't tell
us much of anything. We need details. What are the actual errors
reported. Have you tried running it from A without using IIS under the
same conditions as "another script that connects up to B using the same
settings, not through IIS" If, as it seems you mean, that was via the
command line then the settings were likely subtly different (user would
probably be different). At a guess, I'd say your problem is either
configuration/installation of the module, or user based.
--
Niel Archer

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Windows 2k3 sp2 and mssql error

am 10.07.2007 17:50:41 von Zleviticus

As stated in a previous post:

It fails with :

i am using a php script via a web page to access data on the server and
display it. when i run the page i get the standard:
Warning: mssql_connect() [
function.mssql-connect]: Unable to connect to server: 192.168.1.9

-----Original Message-----
From: Niel Archer [mailto:spam-free@blueyonder.co.uk]
Sent: Tuesday, July 10, 2007 9:00 AM
To: php-windows@lists.php.net
Subject: Re: [PHP-WIN] Windows 2k3 sp2 and mssql error

Hi

I know very little about IIS, but I do know that "it fails" doesn't tell us
much of anything. We need details. What are the actual errors reported.
Have you tried running it from A without using IIS under the same conditions
as "another script that connects up to B using the same settings, not
through IIS" If, as it seems you mean, that was via the command line then
the settings were likely subtly different (user would probably be
different). At a guess, I'd say your problem is either
configuration/installation of the module, or user based.
--
Niel Archer

--
PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Windows 2k3 sp2 and mssql error

am 10.07.2007 18:11:59 von Zleviticus

To add a php script will run from the IIS machine via command prompt. Both
the command prompt one and the IIS one use the mssql connect function.

As stated in a previous post:

It fails with :

i am using a php script via a web page to access data on the server and
display it. when i run the page i get the standard:
Warning: mssql_connect() [
function.mssql-connect]: Unable to connect to server: 192.168.1.9

-----Original Message-----
From: Niel Archer [mailto:spam-free@blueyonder.co.uk]
Sent: Tuesday, July 10, 2007 9:00 AM
To: php-windows@lists.php.net
Subject: Re: [PHP-WIN] Windows 2k3 sp2 and mssql error

Hi

I know very little about IIS, but I do know that "it fails" doesn't tell us
much of anything. We need details. What are the actual errors reported.
Have you tried running it from A without using IIS under the same conditions
as "another script that connects up to B using the same settings, not
through IIS" If, as it seems you mean, that was via the command line then
the settings were likely subtly different (user would probably be
different). At a guess, I'd say your problem is either
configuration/installation of the module, or user based.
--
Niel Archer

--
PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php

--
PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Windows 2k3 sp2 and mssql error

am 10.07.2007 18:32:36 von Zleviticus

Iswsue resolved. The issue was related to a security update to ISS. It
stopped allowing a local anonymous account from accessing the mssql server.
I created a new user account on the Domain, gave it little permissions in
the domain (same as atypical user) and then it worked. I would not
recommend this workaround for a production internet server but it does work
in my environment where there is not any access from outside the firewalla
nd there are not any more permissions than a standard user has anyways.

Thanks for the suggestions.
Z

-----Original Message-----
From: Zleviticus [mailto:zleviticus@fitnessnow.org]
Sent: Monday, July 09, 2007 11:12 AM
To: php-windows@lists.php.net
Subject: [PHP-WIN] Windows 2k3 sp2 and mssql error

I am perplexed with an issue that i need help on. I have searched and can
not find a resolution and can not find out what is going on.

Here is the situation:

I have a windows 2003 Server running IIS 6, php 5.2.1 I have another windows
2003 server running mssql 2000 with all the latest service packs.

i am using a php script via a web page to access data on the server and
display it. when i run the page i get the standard:
Warning: mssql_connect() [
function.mssql-connect]: Unable to connect to server: 192.168.1.9

I can connect to the sql server via the php script if i run it from my
client in my editing software.

What can i do at thins point to troubleshoot and get it to work. It was
working prior to an installation of sp2 for win2k3

uninstalling sp2 is not an option.

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php