Re: Security issues with Win2003 and ASPNet app

From: Dominick Baier [DevelopMentor] (dbaier_at_pleasepleasenospamdevelop.com)
Date: 04/28/05


Date: Thu, 28 Apr 2005 10:36:07 -0700

Hello RichardF,

if you are using a domain account - just give access to sql server for this
account / ntfs acls for your file server
if you are using a local account - recreate that account with same name/password
on the target machines and proceed as described (not the recommended solution
- you have to keep all those passwords in sync a.s.o.)

---------------------------------------
Dominick Baier - DevelopMentor
http://www.leastprivilege.com

> Thanks for the help, I will give that a go. (Assuming I can figure
> out how to add a App Pool!)
>
> Once I do this, how do I then configure permssions on the SQL server
> and Image server machines?
>
> RichardF
>
> On Thu, 28 Apr 2005 08:26:20 -0700, Dominick Baier [DevelopMentor]
> <dbaier@pleasepleasenospamdevelop.com> wrote:
>
>> Hello RichardF,
>>
>> you can configure the identity of your web service using the
>> Application Pool feature of IIS6.
>>
>> Add a new AppPool - give it an identity (local or domain) - and add
>> the web service application to the AppPool (WebApp properties)
>>
>> Add the account to IIS_WPG and give it access to
>> \windows\microsoft.net\framework\v\temporary asp.net files\ and
>> \windows\temp
>>
>> HTH
>>
>> ---------------------------------------
>> Dominick Baier - DevelopMentor
>> http://www.leastprivilege.com
>>> I have an ASP.NET Web Service and Web Site. It accesses a SQL
>>> database for its data and retrieves images from another server.
>>>
>>> There are 4 servers all running Win 2003 as follows...
>>>
>>> 1 - Domain Controller
>>> 2 - SQL Server
>>> 3 - IIS Server (runs Web Service and Web Site)
>>> 4 - File Server (stores all the image files)
>>> I am having lots of issues with permissions because my Web Service
>>> is
>>> running as a user under a LOCAL group IIS_WPG on the IIS Server and
>>> I
>>> don't know how to give it the necessary permissions to access the
>>> SQL
>>> Server and the Images on different machines.
>>> I think what I need to do is create a Domain Account, give it the
>>> appropriate permissions and then somehow get my Web Service to run
>>> using that user account. I did try this using 'impersonate' but
>>> then it appeared i didn't have permission to tun ASP.NET stuff!
>>>
>>> Can anyone give me tips on how to accomplish this, or point me to a
>>> resource that explains how I can accomplish this.
>>>
>>> Thanks for any help
>>>
>>> RichardF
>>>



Relevant Pages

  • Re: Web Service using Windows Authentication
    ... I saw user account ASPNET in my computer. ... this user account in a SQL server, ... >>do we make a web service connect to that SQL server? ...
    (microsoft.public.sqlserver.security)
  • 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: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • 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: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)

Quantcast