Nupur Dave is a social media enthusiast and an independent consultant. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2). Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at. Pinal has authored 13 SQL Server database books and 40 Pluralsight courses. He holds a Masters of Science degree and numerous database certifications. Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience. In almost all such cases, this should fix your problem. On the lower screen, check the role db_owner. Then, on the “User Mapping” tab, select the desired database – especially the database for which this error message is displayed. In newly opened screen of Login Properties, go to the “User Mapping” tab. Go to SQL Server > Security > Logins and right click on NT AUTHORITY\NETWORK SERVICE and select Properties However, I will be going over a solution that works always and is very simple. If you search online, there are many different solutions provided to solve this error, and many of these solutions work fine. This error can also occur when replication or mirroring is set up. This error occurs when you have configured your application with IIS, and IIS goes to SQL Server and tries to login with credentials that do not have proper permissions. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. This error is quite common and I have received it few times while I was working on a recent consultation project.Ĭannot open database requested by the login.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |