When I run an application of type site in visual studio, the connections to the database work normally. But when trying to run IIS 7 to perform some tests, I get the following message:
Unable to open the "XXX" database requested by logon. Logon failed.
User login failed 'IIS APPPOOL \ DotNet4'.
The specific Bank with which I am having difficulty connecting, left the authentication method configured to be accessed through the Windows user login.
The conectionString
of my Web.config
looks like this:
<add name="LocalConnection" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=XXX;Connect Timeout=3000; Integrated Security=True;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />
Note : I was told that I should go into the application pool and set the Identity option to that of my user, my user has a password and is not accepting me to add it in this dialog: