asp.net - Forms authentication for users and Windows for Database? -


On our production server, the administrator has created a web user Active Directory account that is a user for anonymous access to IIS and It also uses database authentication with our SQL server certified security = SSPI connection connection string and identity = "true" in web.config by using

. I have often come under the circumstances where I would like or even need to use form validation, however, I am using form validation, to enter the user's credentials to authenticate the integrity of the database against the database Seems to be using. In these cases, I changed the connection string instead of using the credentials of a SQL Server users. I would not want to get worse coded username and password and code worse in the connection string.

Is the user able to use authentication and authentication for IIS user with Windows authentication for user authentication? What would be the best practice in such a situation?

Yes, turn off impersonation (i.e.: impersonation = false) and used forms for forms Web authentication and authorization, but the remote call will use ASP.NET process identification.


Comments

Popular posts from this blog

windows - Heroku throws SQLITE3 Read only exception -

lex - Building a lexical Analyzer in Java -

python - rename keys in a dictionary -