>In SQL Server, I have created a user for a specific database. In the connection string, I have entered the proper username and password. From a desktop application, I can add new records in one of the table. However, from the Web application, the only way to add a new record is to go in the Web site ASP.NET pane and enter an administrative account in the Application pane for the Identity settings. I would like to avoid that step. Considering that I am defining an account to be used in the connection string, is there a way to avoid doing any setting at the Web site level?
Michel,
In 1.x I store an encrypted connection string in the web.config and unencrypt it in code before assigning the value to the SqlConnection.ConnectionString property. In 2.0 I have heard that there is a new feature for encrypted connection strings in the web.config - and the Application pane sounds like a GUI for the web.config file.