Re: Web Service using Windows Authentication

From: Mary Chipman (mchip@nomail.please)
Date: 06/06/02 

From: Mary Chipman <mchip@nomail.please>
Date: Thu, 06 Jun 2002 09:54:08 -0400

Go into the Enterprise Manager and in the security tab enable the
domain/login for the server. Set the default database and enable
database access to the database your web service is using.

--Mary

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

>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