Flex app. calling webservices using SSPI to SQL Server fails on IIS Server

[mfarhanali]

Hi,
  I have flex project calling webservices developed within the flex project is running fine in my flex 3.5 development environment but when i push the application on IIS server, it throws exceptions.

WebServices are calling the SQL Server database with the SSPI integrated security= true, which runs fine from my local flex test environment but it does not work in the IIS Server 7 on Windows 2008 server. If i hardcode my id and pwd in the web.config, it runs fine on IIS Server.

The Service account created for SSPI is fine since i ran one asp.net page on IIS with SSPI settings. It runs fine.

I would highly appreciate your help in this issue.

Thanks

[flexy]

What response code is your server responding with when the error occurs? I've seen issues like this before which have been caused by malformed request headers failing to pass the filters on HTTP.sys on IIS7.

[mfarhanali]

status code = 500

here is the sspi connection string i am using and it works fine from my local flex environment but fails in IIS 7, windows 2008 server

<add name="OnboardingDB" connectionString="server=IMCNJSQLDV03;database=OnBoarding; Trusted_Connection=Yes" providerName="System.Data.SqlClient" />     


Thanks

[flexy]

So you're getting an internal server error, implying one of your scripts is barfing. I doubt this is an issue with HTTP.sys now, as the response code would be 400 or 406.