# Sql-server – Migration to databases Domain Users do not have access

permissionsSecuritysql serversql-server-2008

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.

You can either create another login for DOMAIN\DOMAIN USERS and go through and manually remap, or run sp_revlogins (link) and sp_change_users_login 'Report' (link)
If sp_change_users_login 'Report' finds orphans, run sp_change_users_login 'Auto_Fix', 'user'.