MSSQL Connection/Authentication Problem?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • menmaatre
    New Member
    • Nov 2008
    • 2

    MSSQL Connection/Authentication Problem?

    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
Working...