Sql-server – Cannot open database “MyDatabaseName” requested by the login. The login failed. Login failed for user ‘IIS APPPOOL\MyAppName

asp.netiissql server

I have created a web application. I am using SQL 2012 express as a database. Its working fine when I am running on debug mode. When I deployed that application on local IIS it's throwing an error

Cannot open database "databaseName" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\MyApplicationName'.

My connection string is <add name="DefaultConnection" connectionString="Data Source=HAPPY\SQLEXPRESS;uid=sa;password=123;Initial Catalog=dwm;integrated security=sspi;" providerName="System.Data.SqlClient" />

I am able to login with this login detail on my SQL 2012 express. I am attaching a screenshot .

Best Answer

You are using SSPI Integrated Security, thus it is trying to use Windows authentication. Try setting to False:

 connectionString="Data Source=HAPPY\SQLEXPRESS;uid=sa;password=123;Initial Catalog=dwm;integrated security=False;" providerName="System.Data.SqlClient"

Related Solutions

C# – Login failed for user ‘IIS APPPOOL\ASP.NET v4.0’

Looks like it's failing trying to open a connection to SQL Server.

You need to add a login to SQL Server for IIS APPPOOL\ASP.NET v4.0 and grant permissions to the database.

In SSMS, under the server, expand Security, then right click Logins and select "New Login...".

In the New Login dialog, enter the app pool as the login name and click "OK".

enter image description here

You can then right click the login for the app pool, select Properties and select "User Mapping". Check the appropriate database, and the appropriate roles. I think you could just select db_datareader and db_datawriter, but I think you would still need to grant permissions to execute stored procedures if you do that through EF. You can check the details for the roles here.

C# – Cannot open database “” requested by the login. The login failed. Login failed for user ‘sa’

If you are using LAN connection between you and your customer, use this connection string.

"Data Source=Master-PC\Master;;Initial Catalog=dbNegin;Integrated Security=True;Connect Timeout=30;User Instance=True"

"Data Source=Master-PC\Master\SQLExpress;Initial Catalog=dbNegin;Integrated Security=True;Connect Timeout=30;User Instance=True"

For data source you can also use IP Address of your PC. This will help u.

Best Answer

Related Solutions

C# – Login failed for user ‘IIS APPPOOL\ASP.NET v4.0’

C# – Cannot open database “” requested by the login. The login failed. Login failed for user ‘sa’

Related Topic