E
eRic
Hello,
I am currently trying to use integrated security to access the SQL database for the ASP.NET application (deployed on an intranet)
I am following this article
http://msdn.microsoft.com/library/d...kaccessingsqlserverwithexplicitcredentials.as
So far I hav
1. Set the Web.config file to impersonate a specific domain use
<identity impersonate="true" userName = "myDomain\myUserName" password="password"/
2. Created the login in the SQL server and given it appropriate permission
3. Used Integrated Security = SSPI in the connection strin
4. IIS does not allow anonymous access on the site and is using Windows Integrated Securit
So far it's a no go
I've also gone as far as to set the same user (that maps to the SQL login) as the user for the processModel and still nothing
(do you need to reboot the box before changes in machine.config take place?
I read a previous thread that said you need to enable Kerberos delegation for any identity to be passed acrossed machines. Is that the case? If so I really don't understand how the article that I mentioned above could work
Thank
- e
I am currently trying to use integrated security to access the SQL database for the ASP.NET application (deployed on an intranet)
I am following this article
http://msdn.microsoft.com/library/d...kaccessingsqlserverwithexplicitcredentials.as
So far I hav
1. Set the Web.config file to impersonate a specific domain use
<identity impersonate="true" userName = "myDomain\myUserName" password="password"/
2. Created the login in the SQL server and given it appropriate permission
3. Used Integrated Security = SSPI in the connection strin
4. IIS does not allow anonymous access on the site and is using Windows Integrated Securit
So far it's a no go
I've also gone as far as to set the same user (that maps to the SQL login) as the user for the processModel and still nothing
(do you need to reboot the box before changes in machine.config take place?
I read a previous thread that said you need to enable Kerberos delegation for any identity to be passed acrossed machines. Is that the case? If so I really don't understand how the article that I mentioned above could work
Thank
- e