Live Chat Icon For mobile
Live Chat Icon

Why do I get error message ‘Login failed for user DOMAIN\USERNAME’

Platform: ASP.NET| Category: Miscellaneous

You’ll have to create an account in SQL Server for the aspnet user.

  • Start enterprise manager-> expand the server-> select security->Right-click in the right view and select new login,
  • enter the DOMAIN\USERNAME and select your database as the default database of the user at the bottom of the page,
  • Select last tab Database Access -> select your database, and add the db_datareader and db_datawriter policies to your user.

Share with

Related FAQs

Couldn't find the FAQs you're looking for?

Please submit your question and answer.