IIS,SQL Server and Windows Authentication
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > IIS server support > IIS Server Security > IIS,SQL Server and Windows Authentication




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    IIS,SQL Server and Windows Authentication  
Garth Wells


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
07-12-07 12:27 AM

I have two servers that are member servers in a trusted domain. One has
IIS 6.0 on 2003 and the other SS on 2003. In an effort to enable
Integrated Authentication I completed the following:

1. Created an application pool named: AppXPortal

2. Changed the Identity for the AppXPortal pool to Local System

3. Assigned the AppXPortal pool to the virtual directory in which the app
is located

4. Gave the ASPNET account Read & Execute permissions on  the
subdirectory in which the web is located

5. Gave the SYSTEM account Read & Execute permissions on  the
subdirectory in which the web is located

6. Verified Integrated Authentication is enabled on the FinancialReports
virtual directory

7. Verified the ASP.Net app is not configured to impersonate a user


When I execute a valid SQL command I still get a permissions error
referencing the calling server.

Any suggestions?

Thanks







[ Post a follow-up to this message ]



    Re: IIS,SQL Server and Windows Authentication  
Ken Schaefer


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
07-12-07 06:22 AM

If you are not impersonating a user, then ASP.NET wil be running as worker
process identity (LOCALSYSTEM) which is a local account that can't be
assigned permissions to remote resources usually. You'd need to assign
permissions to the computer account instead (webservername$)

Cheers
Ken

"Garth Wells" <nobody@nowhere.com> wrote in message
news:uOhREUBxHHA.3944@TK2MSFTNGP06.phx.gbl...
>I have two servers that are member servers in a trusted domain. One has
> IIS 6.0 on 2003 and the other SS on 2003. In an effort to enable
> Integrated Authentication I completed the following:
>
> 1. Created an application pool named: AppXPortal
>
> 2. Changed the Identity for the AppXPortal pool to Local System
>
> 3. Assigned the AppXPortal pool to the virtual directory in which the app
> is located
>
> 4. Gave the ASPNET account Read & Execute permissions on  the
> subdirectory in which the web is located
>
> 5. Gave the SYSTEM account Read & Execute permissions on  the
> subdirectory in which the web is located
>
> 6. Verified Integrated Authentication is enabled on the FinancialReports
> virtual directory
>
> 7. Verified the ASP.Net app is not configured to impersonate a user
>
>
> When I execute a valid SQL command I still get a permissions error
> referencing the calling server.
>
> Any suggestions?
>
> Thanks
>






[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 02:10 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register