July 16, 2024 at 10:57 am
Hi SQL experts,
The sql service & agent services are running as local system. Copied the sql jobs from different server, which executes dts packages. The jobs are failing showing that DOMAIN\SERVERNAME$ has no access. I created the login with computer name and provided sysadmin permissions. The user executes the job has sysadmin permissions. Jobs are still failing Even after creating the domain\computer name login with sysadmin. NT Authority\Network service & NT Authority\System are also sysadmin. What else needs to check
July 16, 2024 at 3:37 pm
I assume your packages are stored in msdb, is that right? Are you sure you're accessing the right server from the jobs?
Without code or errors, it's hard to know.
July 16, 2024 at 3:47 pm
I assume your packages are stored in msdb, is that right? Are you sure you're accessing the right server from the jobs?
Without code or errors, it's hard to know.
July 16, 2024 at 7:35 pm
Yes, the dts packages are stored in msdb.
We are using DNS alias in packages. Those aliases are pointing to this server
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply