System.Data.SqlClient.SqlException: Login failed for user

by

Just set Integrated Security=False and it will work ,according to a comment difference between True and False is:

True ignores User ID and Password if provided and uses those of the running process, SSPI(Security Support Provider Interface ) it will use them if provided which is why MS prefers this.
They are equivalent in that they use the same security mechanism to authenticate but that is it.

More Related Contents:

  1. What is the connection string for localdb for version 11
  2. Cannot open database “test” requested by the login. The login failed. Login failed for user ‘xyz\ASPNET’
  3. How to get the current user in ASP.NET MVC
  4. Entity Framework Timeouts
  5. Access to the path is denied
  6. ASP.NET Core 1.0 on IIS error 502.5
  7. Read connection string from web.config
  8. The breakpoint will not currently be hit. No symbols have been loaded for this document in a Silverlight application
  9. What is IMEX within OLEDB connection strings?
  10. Help with a OleDB connection string for excel files
  11. IIS WCF service hosting vs Windows Service
  12. Can you prevent your ASP.NET application from shutting down?
  13. How to check if connection string is valid?
  14. Get the Application Pool Identity programmatically
  15. Setting Culture for ASP.NET MVC application on VS dev server and IIS
  16. How to detect IIS version using C#?
  17. Check ssl protocol, cipher & other properties in an asp.net mvc 4 application
  18. asp.net MVC: How to redirect a non www to www and vice versa
  19. How can I secure passwords stored inside web.config?
  20. Cannot load Counter Name data because an invalid index -Exception
  21. Share Session between two web sites using asp.net and state server
  22. IIS app pool recycle + quartz scheduling
  23. I’ve been hacked. Evil aspx file uploaded called AspxSpy. They’re still trying. Help me trap them‼
  24. Leverage browser caching in IIS (google pagespeed issue)
  25. IIS 7.5, Web Service and HTTP 405 error
  26. Persist Security Info Property=true and Persist Security Info Property=false
  27. Could not load file or assembly ‘System.Web.Helpers, error on IIS 8
  28. Create a user defined table type in c# to use in sql server stored procedure
  29. ASP.NET Core – Authorization Using Windows Authentication
  30. Can I reuse HttpWebRequest without disconnecting from the server?

Leave a Comment