Need your help. My sql job is not able to take backup to the shared folder although the domain account, under which the sql agent service account is running, has full permission on that shared folder.
In addition to that, my sql service account uses default virtual login. So when I change that account to the domain account that I also used for sql agent service account, then the problem is fixed.
Why can't I take backup to shared folder using sql agent service account?