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

Share on twitter
Share on facebook
Share on linkedin

Related FAQs

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

Please submit your question and answer.