RE: Using [SoapDocumentMethod(OneWay=true)] attribute causes Trusted SQL Connection to fail

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dan Rogers (danro_at_microsoft.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 22:59:46 GMT

Hi Christopher,

This is more likely due to the round tripping that goes on with a
integrated security connection. A one-way call has to be fire-and-forget.
The better choice for you, I think, at this point is to look at the
WS-Security implementation in the WSE (web service extensions) SP1 SDK.

I hope this helps

Dan Rogers
Microsoft Corporation
--------------------
>From: "Christopher D. Wiederspan" <wiederspan@reachdigital.com>
>Subject: Using [SoapDocumentMethod(OneWay=true)] attribute causes Trusted
SQL Connection to fail
>Date: Fri, 17 Dec 2004 09:03:16 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <#40NoGF5EHA.1300@TK2MSFTNGP14.phx.gbl>
>Newsgroups:
microsoft.public.dotnet.framework.adonet,microsoft.public.dotnet.framework.a
spnet,microsoft.public.dotnet.framework.aspnet.security,microsoft.public.dot
net.framework.aspnet.webservices
>NNTP-Posting-Host: 65.102.197.213
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.framework.aspnet:284257
microsoft.public.dotnet.framework.aspnet.security:12686
microsoft.public.dotnet.framework.aspnet.webservices:27276
microsoft.public.dotnet.framework.adonet:97130
>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservices
>
>I have a web service and I'm using a connection string to SQL Server that
>specifies "Integrated Security=SSPI" to impersonate the calling user. My
>setup works fine until I add the [SoapDocumentMethod(OneWay=true)]
attribute
>to the web service, and then I start getting the error: Login failed for
>user '(null)'. I'm guessing that this has something to do with threading
and
>the new thread not having the context of the calling user. Can somebody
>enlighten me?
>
>Thanks,
>Chris
>
>
>

Relevant Pages

  • Re: Web Services and SQL Server Stored Procedures
    ... but don't require the consumer to do anything but consume the web service. ... feel compelled to leave the connection open for the entire lifespan of the ... the next sql statement, it probably needs closed. ... "Christopher Rose" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Strange webservice problem
    ... I guess it must be something in your web service calling code. ... WSDL proxy generated class? ... There is nothing else runninging that is try to initiate a connection, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: One Web Service updates SQL, another cant?
    ... I guess its because this is my first Web Service and I ... it opens the database connection. ... > Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.security)
  • Dataset retunring Null ..a gurus opinion required!
    ... toolbox to the design area to establish the connection. ... Whenever I try to consume this service (using a web or even a windows ... 'Bind the data to the datagrid by transferring ... To ensure that my web service is well connected to my Access database, ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Empty Dataset retunedt!! Help is desparetely required!!
    ... toolbox to the design area to establish the connection. ... Whenever I try to consume this service (using a web or even a windows ... 'Bind the data to the datagrid by transferring ... To ensure that my web service is well connected to my Access database, ...
    (microsoft.public.vsnet.general)