May 5, 2018 at 5:39 am
I'm trying to make a backup from SQL Server into a shared folder. Although I am able to manually go to shared folder and create or modify files, but I realized NT Service\MSSQLSERVER doesn't have permission to access to it and it throw this exception:
Cannot open backup device 'W:/something/backup' Operating system error 3
I thought since I am able to manually go to shared folder and modify files, if I change SQL Server account from NT Service\MSSQLSERVER to Local System it should work fine. But what scares me and stops me to test it is that at the moment various softwares are working with SQL Server and I'm afraid something regretful going to happen if I change NT Service\MSSQLSERVER to Local System.
So, I thought maybe I can decide better what to do if I understand what happens when SQL Server uses NT Service\MSSQLSERVER or Local System account.
___________________________________
Computer Enterprise Masoud Keshavarz
I don't care about hell.
If I go there I've played enough Diablo to know how to fight my way out.
May 5, 2018 at 7:25 am
NT SERVICE\MSSQLSERVER is a Virtual Accounts https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-2017#VA_Desc.
Changing this to Local System don't solve your problem and is a security risk, this is why virtual account was made.
If this is a domain, MSSSQL running under NT SERVICE\MSSQLSERVER will authorize using computer account, so you just need add access to this share for computer account. If this is workgroup, you can use net use command in backup script eg: https://www.schneider-electric.com/en/faqs/FA233914/ or make identical accounts (same username and password) on both computers and run MSSSQL on this account.
May 6, 2018 at 6:22 am
Thank you. Using Net Use solved the problem.
Also here https://www.mssqltips.com/sqlservertip/3499/make-network-path-visible-for-sql-server-backup-and-restore-in-ssms/ is a good example with an easy step by step explanation.
___________________________________
Computer Enterprise Masoud Keshavarz
I don't care about hell.
If I go there I've played enough Diablo to know how to fight my way out.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply