IIS and SqlServer permissions
- From: "Sam" <sam@xxxxxxxxxx>
- Date: Sat, 11 Oct 2008 03:10:24 +0200
Hi,
I developed an ASP.NET application with VS2005. And now I would like to deploy it on IIS (5.1 on windows XP) to give access, to everyone in my LAN network, on it. During development I used Windows Security authentication but when I deployed web site on IIS an error occurred: Login failed for user 'SERVERNAME\ASPNET'.
I have looked for any solution many hours till I understand that it is better to use Sql server authentication. I did all operations and now my website works well.
But, if I want to use Windows authentication, what I have to do?
I tried:
Inside Web.Config :
<authentication mode="Windows"/>
<identity impersonate="true"/>
on IIS i turned on:
Anonymous access(with IUSR_NAME), integrated Windwos authentication
and finally:
osql -E -S (local)\NetSDK -d puthereyourdatabasename -Q "sp_grantdbaccess 'YourServer\ASPNET'"
osql -E -S (local)\NetSDK -d puthereyourdatabasename -Q "sp_addrolemember 'db_owner', 'YourServer\ASPNET'"
but I can't run my application anyway!!
Thanks.
Bye.
.
- Prev by Date: Re: Virtual PC connectivity Problem
- Next by Date: Outlook MSSMLBIZ cannot start Error 3417
- Previous by thread: Event trigger when database connection lost in sqlserver and how to trap that event
- Next by thread: Outlook MSSMLBIZ cannot start Error 3417
- Index(es):
Relevant Pages
|
