You must Sign In to post a response.
  • Category: SQL Server

    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

    I got this error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. How to solve this problem.
  • #680975
    This error clearly suggest that this user name does not have permission to logs on to the system. Please provide Permission and rights to this user as well so that it can read write data base. make use of the Management Studio Express
    Thanks & Regards
    Anil Kumar Pandey
    Microsoft MVP, DNS MVM

  • #680979
    try this storedprocedure to solve that problem

    exec sp_addrolemember 'db_owner', 'UserName\ASPNET'

    hope this will help you

  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.