2

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
  • 6,177
  • 12
  • 40
  • 53

1 Answers1

3

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

anaximander
  • 7,083
  • 3
  • 44
  • 62
Badfishmaan
  • 318
  • 3
  • 10