Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Services > Using [SoapDocumentMethod(OneWay=true)] attribute causes Trusted SQL Connection to fail

Reply
Thread Tools

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

 
 
Christopher D. Wiederspan
Guest
Posts: n/a
 
      12-17-2004
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


 
Reply With Quote
 
 
 
 
Dan Rogers
Guest
Posts: n/a
 
      12-20-2004
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" <>
>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: <#>
>Newsgroups:

microsoft.public.dotnet.framework.adonet,microsoft .public.dotnet.framework.a
spnet,microsoft.public.dotnet.framework.aspnet.sec urity,microsoft.public.dot
net.framework.aspnet.webservices
>NNTP-Posting-Host: 65.102.197.213
>Path:

cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGP08.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.webservic es:27276
microsoft.public.dotnet.framework.adonet:97130
>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservic es
>
>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
>
>
>


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using [SoapDocumentMethod(OneWay=true)] attribute causes Trusted SQL Connection to fail Christopher D. Wiederspan ASP .Net 0 12-17-2004 04:03 PM
Using [SoapDocumentMethod(OneWay=true)] attribute causes Trusted SQL Connection to fail Christopher D. Wiederspan ASP .Net Security 0 12-17-2004 04:03 PM
not able to access sql server using trusted connection. Ramesh ASP .Net 3 06-23-2004 12:07 PM
Not associated with a trusted SQL Server connection vlad ASP .Net 3 08-21-2003 04:37 PM
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Blake Versiga ASP .Net 2 07-09-2003 07:30 AM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57