Cannot open database “test” requested by the login. The login failed. Login failed for user ‘xyz\ASPNET’

Well, the error is pretty clear, no? You are trying to connect to your SQL Server with user “xyz/ASPNET” – that’s the account your ASP.NET app is running under.

This account is not allowed to connect to SQL Server – either create a login on SQL Server for that account, or then specify another valid SQL Server account in your connection string.

Can you show us your connection string (by updating your original question)?

UPDATE: Ok, you’re using integrated Windows authentication –> you need to create a SQL Server login for “xyz\ASPNET” on your SQL Server – or change your connection string to something like:

connectionString="Server=.\SQLExpress;Database=IFItest;User ID=xyz;pwd=top$secret"

If you have a user “xyz” with a password of “top$secret” in your database.

Related Posts:

  1. How can I secure passwords stored inside web.config?
  2. System.ComponentModel.Win32Exception: Access is denied Error
  3. An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode
  4. CS1617: Invalid option ‘6’ for /langversion; must be ISO-1, ISO-2, 3, 4, 5 or Default
  5. Call a stored procedure with parameter in c#
  6. Cannot drop database because it is currently in use
  7. Why is HttpContext.Current null?
  8. C# HttpClient An existing connection was forcibly closed by the remote host
  9. How to resolve “Input string was not in a correct format.” error?
  10. failed to load resource: the server response with a status 500 (internal server error)
  11. The request was aborted: Could not create SSL/TLS secure channel
  12. ASP.NET 5 MVC: unable to connect to web server ‘IIS Express’
  13. Twilio TwilioRestClient does not contain a definition for SendSmsMessage
  14. How to add a default Default.aspx to a ASP.NET Web Application Project?
  15. how does Request.QueryString work?
  16. The request was aborted: Could not create SSL/TLS secure channel
  17. The request was aborted: Could not create SSL/TLS secure channel
  18. System.web.mvc missing
  19. Access to the path is denied
  20. The client and server cannot communicate, because they do not possess a common algorithm – ASP.NET C# IIS TLS 1.0 / 1.1 / 1.2 – Win32Exception
  21. WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for jquery
  22. What is WebResource.axd?
  23. Invalid length for a Base-64 char array
  24. What does vary:accept-encoding mean?
  25. The HTTP request was forbidden with client authentication scheme ‘Anonymous’. The remote server returned an error: (403) Forbidden
  26. Why am I getting a “Could not find a part of the path” exception?
  27. C# Gridview CheckBox Field VS (Template Field + CheckBox)
  28. How to use the “Using” statement in ASP.net razor webpages?
  29. calling javascript function on OnClientClick event of a Submit button
  30. What is the difference between “@Scripts.Render” and “

    Recommended Hostings

    Cloudways: Realize Your Website's Potential With Flexible & Affordable Hosting. 24/7/365 Support, Managed Security, Automated Backups, and 24/7 Real-time Monitoring.

    FastComet: Fast SSD Hosting, Free Migration, Hack-Free Security, 24/7 Super Fast Support, 45 Day Money Back Guarantee.

© 2024 Read For Learn