What is the impact if we use DYNSA User ID instead of the sa User ID for installs?
You can use the DYNSA User ID as an alternative to the ‘sa’ User ID. This will not impact installs and updates. Make sure the DYNSA has the same rights as the ‘sa’ did and that they also have sufficient SQL Server rights to be able to create Tables. This user must either be in the ‘sysadmin’ fixed server role or the ‘db_owner’ role for the DYNAMICS database. Also, here is the Role and Task for Omni Tools. Please make sure the DYNSA User ID is assigned to it.
Our company had policy not allow sa user for execute batch job .How can I created new user instead sa user for execute batch job with same authority.
I try to created new user(I created jobrun user) and changed it in my batch job but when that job executed it show in log “Executed as user NT SERVICE\SQLSEVERAGENT” .
I don’t understand why it executed by NT Authorize instead Jobrun user.I’d like toknow how can I execute batch job by jobrun user .
Regards,
Ben
Related Questions
- Only individuals with a user ID on the Access Data Backup Client software will be able to administer its functions. Can users administer backups for their own machines?
- Can I use my User ID and Password from another Texas Workforce Commission (TWC) Internet system?
- What user ID and password should I use to access CSU Marketplace?
