RE: Problem with SQL trusted connection.
- From: Paul Hale <PaulHale@xxxxxxxxxxxxxxxxx>
- Date: Mon, 24 Mar 2008 06:14:02 -0700
Thanks very much for your reply Peter. I will action as per your suggestions
next week.
Paul.
""Peter Yang[MSFT]"" wrote:
Hello Paul,.
As far as I know, you could still configure Windows authentication in IIS 7
if you add and enable "impersonate=true" in web.config as that in IIS6.
You should add "WindowsAuthenticationModule" in IIS 7
applicationHost.config file:
<add name="WindowsAuthenticationModule" image="…\authsspi.dll" />
Please see the following article for details:
http://learn.iis.net/page.aspx/138/build-a-custom-iis7-server/
In web.config file for ASP.Net you could still use the configurations you
use in IIS6:
<authentication mode="Windows">
<identity impersonate="true" />
<add name="LocalSqlServer" connectionString="Server=DBServer;Initial
Catalog=aspnetdb;User Id=sa;Password=password;Connect
Timeout=200;Trusted_Connection=True;" providerName="System.Data.SqlClient"
/>
Per your question, this configuration of IIS7 should work for both IIS and
sql on the same box. Plesae undrstand for trusted connection and
impersonate=true, all client users should have proper permission on the SQL
server directly.
Please refer to the following links for more related information:
Understanding Sites, Applications, and Virtual Directories in IIS 7.0
http://learn.iis.net/page.aspx/150/understanding-sites-apps-and-vdirs-in-iis
-7/
Building and Running ASP.NET Applications
http://learn.iis.net/page.aspx/23/building--running-aspnet-applications/
If anything is unclear or you have further questions, please feel free to
let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
- References:
- RE: Problem with SQL trusted connection.
- From: "Peter Yang[MSFT]"
- RE: Problem with SQL trusted connection.
- Prev by Date: Re: Migration from existing database server 2005 to new database server 2005
- Next by Date: Login Error 18456
- Previous by thread: RE: Problem with SQL trusted connection.
- Next by thread: Login Error 18456
- Index(es):
Relevant Pages
|
|
