Shared folder access

Question

We have SQL query that pulls data from a database and then needs to write a text file to a windows folder. We currently do this on a Windows 2012 with 2014 SQL. On that server, we gave MSSQLServer access rights to the folder. In the 2019 server, it is not allowing me to do that, how do I give a SQL account permissions to write to a windows folder?

Answer 1

This might help?

For named instances, the virtual account that needs the folder permissions depends on the named instance name. For example if the maned instance is Test, add permissions to following virtual account:

"NT SERVICE\MSSQL$TEST"