Folder Permision for SQL Server/ SQL SSIS
Posted on 2014-01-21
I'm upgrading to Window Server 2012 and I'm recreating some CLR assemblies (for SQL Server) that access an email account, saves and unzips the attachments then uploads these into a db. I can't seem to grant the folders where this occurs the right permissions for this to work.
To be clear, I can set the folder permission to 'Everyone' and it works (so it isn't an assembly problem), but I would like to throttle the access down so only Sql Server and/or SQL SSIS has permission. I'm running SQL Server 2012 on Windows Server 2012. SQL Server Agent logs on as [NT Authority/Network Service] and SQL Server logs on as [NT Service/MSQLServer].
I'm obviously not a network guy....dumbing down the explanations would be appreciated!!