Re: Web Service using Windows Authentication

From: David Ge (dge@microsoft.com)
Date: 06/06/02


From: "David Ge" <dge@microsoft.com>
Date: Wed, 5 Jun 2002 15:33:04 -0700


Hi Mary,
I saw user account ASPNET in my computer. How do I enable
this user account in a SQL server, which is on another
computer? We do not know the password of ASPNET account
(I think we should not change the password for this
account?)
Thank you for your help.
David Ge

>-----Original Message-----
>See the topic Securing XML Web Services Created Using
ASP.NET in the
>..NET help files. You can pass credentials by setting
the Credentials
>property or you can pass it in SOAP headers for a custom
solution. As
>far as the web service connecting to SQLS, the default
is to use the
>ASPNET windows account, so you can enable that account
as a login and
>grant it appropriate permissions in the database. If you
use
>impersonation, then the windows credentials of the user
will be
>passed, which is probably not what you want for a web
service.
>
>-- Mary
>MCW Technologies
>http://www.mcwtech.com
>
>On Mon, 3 Jun 2002 16:32:42 -0700, "David Ge"
<dge@microsoft.com>
>wrote:
>
>>If SQL server uses Windows authentication ONLY, then
how
>>do we make a web service connect to that SQL server?
>>
>>I made a web service in C#, which opens a SQL server
>>connection to get data and send result back to web
>>clients. The SQL Server uses Windows authentication
only.
>>How do I config the web server so that when the web
>>service is making SQL connection, it may use an NT
>>account? For a DCOM DLL, it is to set its identity. For
a
>>web service, how do we do that?
>
>.
>



Relevant Pages

  • RE: router, windows authentication and passing credentials
    ... Bear in mind that Windows 2000 does *NOT* support impersonation by the ... ASP.NET worker process account. ... The reason is that the ASPNET account lacks ... web service router ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: Windows Auth to SQL Server from ATL Web Service not working...
    ...  When I hit the web service with a simple test application, ... account I'm logged on as. ... could even be the one the application pool in iis is running under) to ... this impersonation token is not passed on to the SQL Server. ...
    (microsoft.public.vc.atl)
  • Re: Windows Auth to SQL Server from ATL Web Service not working...
    ... When I hit the web service with a simple test application, ... account I'm logged on as. ... this impersonation token is not passed on to the SQL Server. ... Probably the simplest solution is to run the web service under a specific account, something other than the local system account. ...
    (microsoft.public.vc.atl)
  • Re: ASP.net Integrated Security SQL Server
    ... It fails becouse by default wp_net.exe is running under local ASPNET account which does not have access to any network resources. ... Use SQL authentication ... > associated with a trusted SQL Server connection. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Global.asax not allowing identity impersonation?
    ... Not allowed to use the ASPNET machine account in SQL Server (very ... test environment, ...
    (microsoft.public.dotnet.framework.aspnet)