1

I have ASP.NET MVC app that connects to MSSQL database on Windows Server 2008 R2. The thing is that I see this error and can't solve the problem:

Login failed for user NT Authority\System
  • I have created login under SQL Server for NT Authority\System and gave sysadmin access to my database (+ selected default database)
  • Application pool uses LocalSystem user
  • Firewall is turned off

What may be a reason of my problem?

Vnuuk
  • 5,825
  • 11
  • 34
  • 50

1 Answers1

3

You should run the application pool under a custom account (Windows admin for me)

anaximander
  • 6,938
  • 3
  • 45
  • 62
Badfishmaan
  • 198
  • 2
  • 10