I want to setup ProGet on a 2016 server with SQL Express and IIS.
Both the service and IIS web runs under the Network Service user. None seem to be able to access the Database on a local SQL Express instance.
The IIS website tells me that the login
PACKAGE is the servers name) cannot access the database:
I understand that I need to add the Network Service (which IIS uses to actually authenticate with SQL Express) as a login/user to the database.
When I tried adding the NT-Authority\Network Service as a login/user to the database, I get an error that tells me that Windows cannot find any authentication for the Network Service.
How can this be? Why can't SQL Express find the Network Service?