Shared folder access

Jack Pennypacker 1 Reputation point
2022-04-11T18:14:48.03+00:00

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?

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,400 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Riaan-VS 351 Reputation points
    2022-04-11T19:33:03.74+00:00

    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"

    0 comments No comments