I migrated databases to new servers, however the applications that were previously used with the databases are failing to load. I have changed the connections and etc. The jobs also seem to be failing. I have a domain account who is the job owner. However, when I try to execute the job under my username I get the following error:
Executed as user: NT AUTHORITY\SYSTEM. Login failed for
user…..[SQLSTATE 28000) (Error 18456).
Is this related to
Domain Users not having appropriate read and write access to the database?
How would I give
all domain users permissions to execute stored procedures.