Login failed for user 'IIS APPPOOL\myAppPoolName' and cannot add new user for this

sql server login failed for user 18456
login failed for user sql server authentication
login failed for user c#
connectionerror: login failed for user ''.
sql server login failed for user 18456 sql server authentication
login failed for user microsoftaccount
login failed for user 'sa'
login failed for user 'root'.

I am getting the following error while asp.net app trying to connect database. Login failed for user 'IIS APPPOOL\myAppPoolName'.

I use ms SqlServer 2008 r2, windows server 2008 r2.

This happened when I've just moved the application and database from one server to another.

I thought adding a new user to database named 'IIS APPPOOL\myAppPoolName' but when i try it, I'm getting following error on adding new db user wizard:

'IIS APPPOOL\myAppPoolName' is not a valid name because it contains invalid characters. (Microsoft SQL Server, Error: 15006)

How can I fix this?

Thanks in advance.

Erdem.

By default, custom application pools receive the 'Network Service' user credentials. Simply try adding a new login for your mssql server (and database, of course) for the 'Network Service' account. Read more here

"Login failed for user" error message when you log on to SQL Server, The generic message “Login Failed for User (Microsoft SQL Server, Error: 18456) ” means you entered invalid credentials when logging into SQL Server. The generic message “Login Failed for User (Microsoft SQL Server, Error: 18456)” means you entered invalid credentials when logging into SQL Server. Video is short but has additional tips and tricks so watch the video to get the FULL STORY!

Thanks @Nissim

In Sql > Security > Logins > Right-click > new login > Login name "NT AUTHORITY\NETWORK SERVICE"

In Same New login window On left side > User Mapping > Check the database you want > Select each database and in Database roles (second box below) > db_owner

Click Ok

In IIS > Application Pools > Your app pool > advance settings > Identity (change to "NetworkService")

Click Ok

How to Fix Login Failed for User (Microsoft SQL Server, Error: 18456 , I ran into the same issue, and I fixed it by adding my windows username to SQL and then to my server, here is how I did: First, create a new� Reason: Exception while trying to connect to DataSource: new connection: java.sql.SQLException: Login failed for user 'username'. Cause This is caused by not having the SQL Server configured properly for use with Spectrum Technology Platform.

You can also fix this without adding new SQL login simply Change App pool Identity to LocalSystem

Right click on the App pool > Advanced Settings > then change Identity to LocalSystem

SqlServer: Login failed for user, Troubleshooting Microsoft SQL Server Error 18456, Login failed for user � Step 1: Log In with Remote Desktop � Step 2: Run Microsoft SQL Server� The generic message "Login Failed for User (Microsoft SQL Server, Error: 18456)" means you entered invalid credentials when logging into SQL Server. In the below screen shot, I am logging into

Troubleshooting Microsoft SQL Server Error 18456, Login failed for , The generic message "Login Failed for User (Microsoft SQL Server, Error: 18456) " means you entered invalid credentials when logging into� Either Change Server Authentication mode of this SQL Server Instance to Mixed mode (SQL Server and Windows Authentication Mode)Or, always use windows login or Domain login account to connect to SQL Server Instance.

How To Fix Login Failed for User Microsoft SQL Server Error 18456 , Solution by Pinal Dave: Create new user with Administrator privilege with same username and password as of SQL Server 2008 in operating system. On SQL� Enabling login for the user and click OK. After refreshing the list user logins, we can confirm the user no longer has a red x present. This should allow the user to log in. In this example, the SQL user ‘sa’ failed to log in because there was no permission to log in. Continuing with user troubleshooting, right-click the user and choose

Login failed for user 'domain\username'. (Microsoft SQL Server , SQL Server 2017 (Login Failed for User sa, Error:18456)Duration: 1:57 Posted: 11 May 2018 I've written a very simple jdbc login test program. And after all kinds of problems I've almost got it working. Almost, just can't seem to get past this "SQLServerException: Login failed for user xxxxx" problem. I created a simple database PersonInfo then I created user user1 password1 (sql authenication).

Comments
  • Thank you @Nissim it was very helpful. I added new Sql Server login and select its' initial database as my application Db, instead of adding new db user. This fixed this situation.