By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

MSSQL Connection/Authentication Problem?

P: 2
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
Nov 15 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.