Yes, this can be different to get working in a workgroup. The SQL Server account needs to have access to the network drive. You would have to set up SQL Server to run under a regular Windows user, and on the other machine you would create the same user with the same password.
Backup maintenance plan not working on remote drive -SQLServer 2008 r2
Bibin Joseph
1
Reputation point
I created a maintenance plan for differential backup. I am a workgroup network. How can I configure the network service. The plan is working perfectly in the local system.
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,503 questions
1 answer
Sort by: Most helpful
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
2021-03-02T23:04:32.883+00:00