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

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" <zleviticus@fitnessnow.org> To: <php-windows@lists.php.net> 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() [ <http://solomon/Flash/function.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