Access to sql server to run ssis
Posted on 2009-07-01
I have a sql server 2008 machine and I am trying to set it up so that the workload for SSIS packages is run on the server rather than a client (when you run a package in management studio remotely the workload seems to be run on the client).
Anyway I thought the best action would be to allow RDP access to the server but I wanted to lock the system down so that they only could run sql server on this machine. Anyway I took all normal User rights (read,list, read+exe, modify, list folders, write) away from drives and made a local profile for the user. anyway when I login to sql server 2008 with this user I get a .NET error HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\shell is denied.
Anyway I cannot see this registry value in the registry unless I give the user administrator priviledges- which I obviously do not want to do. In the registry I have given full access permission to the Microsoft sql server key for the user I want to use but when I login as this user I cannot see the registry key. Can someone help?