DOMAIN\\SERVERNAME$ Failure even with sys admin

  • 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

    • This topic was modified 3 months, 2 weeks ago by  ramana3327.
    • This topic was modified 3 months, 2 weeks ago by  ramana3327.
  • 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.

  • 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.

  • 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