Connecting Tech Pros Worldwide Forums | Help | Site Map

MSSQL Connection/Authentication Problem?

Newbie
 
Join Date: Nov 2008
Posts: 2
#1: Nov 15 '08
Hi all,

I have a very odd problem:

- System A: Win 2k3 with IIS 6 exposing a little WSDL Webservice
- System B: Win 2k3 with MSSQL Server 2k5
- System C: RedHat Enterprise Server running apache 2.2.x with PHP5 and
PHP Soap extension

All systems are at the same subnet. xxx.xxx.xxx.10 / 11 / 12

I run a PHP script on C consuming a little 'Hello world' Webservice at A:
Response time 0.002 seconds.
After this I added a MSSQL-Connect to the webservice and a small SELECT

Consuming the webservice from A (at localhost): 0.003 sec
Consuming the webservice from B: 0.005 sec
Consuming the webservice from C: Response time 5.x seconds !!!

I found out that the connection/authentication at the MSSQL service seems
to take about 5 seconds in the last case.

To me it's a mystery.

I would appreciate any suggestions.

Thank you in advance
Andreas

Reply