-2

Login failed for user 'xx'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'xx

  • `Login failed for user 'xx'` Once login successes, then the error will be gone. Please check your connection string `User name` and `password` and `Server Name` and `Database Name` – Ramesh Rajendran Jan 28 '19 at 11:34
  • 2
    Possible duplicate of [System.Data.SqlClient.SqlException: Login failed for user](https://stackoverflow.com/questions/22415319/system-data-sqlclient-sqlexception-login-failed-for-user) – Ramesh Rajendran Jan 28 '19 at 11:36

1 Answers1

0

The issue has been resolved after changing the settings of IIS. I have changed it to Application pools--> Default app pool --> advance settings--> identity --> local system.IIS settings . Also i have changed the settings on SQL database(security --> logins-->select your login name --> (right click )properties-->server role--> sysadmin) Database settings on login