This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 28.000000000000004%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBJ%3C/text%3E%3C/svg%3E)
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.
Sorry your question is not clear. What do you want to do with network service
I want to store the backup in a remote location. I am able to access the remote folder through SMB protocol from SQL server. But the maintenance plan getting fails while setting the remote location. While I check some blogs many said the network service accounts need to reconfigure with a domain user, unfortunately, I am working in a workgroup environment.
Hi @Bibin Joseph , is there any error message? if there has any error message, could you please provide the screenshot?
Hi, we have not received a reply from you. Any update for this?
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.