Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

Folder Permision for SQL Server/ SQL SSIS

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!!

Any suggestions?
0
badrhino
Asked:
badrhino
  • 3
2 Solutions
 
Surendra NathCommented:
if the call to the DLL is initiated through the SQL Server (a stored procedure), then you need to give it the SQL Server user name, if it is the SQL agent then the SQL agents.

but to be on the safe side, I will add both the SQL agent's and SQL Server's logins access to the folder...
0
 
badrhinoAuthor Commented:
I can't seem to find the log on name for sql server in this folder.  SQL Server logs on as [NT Service/MSSQLServer] and this isn't available in the Group or User Names section of the secutrity tab.  I added SERVICE and that works and is much better than 'everyone', but would like to throttle it down a little more.
0
 
badrhinoAuthor Commented:
Ended up just setting the security to service.
0
 
badrhinoAuthor Commented:
The question was never quite answered like I needed it, but do appreciate Ganti's help....
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now