This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.