We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Access to sql server to run ssis

Medium Priority
754 Views
Last Modified: 2013-11-08
Hi,

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?
 

Comment
Watch Question

You can allow registry access through group policy. Why do you want to get into registry? Did you configure users in SQL server and gave them permissions to access SSIS?

Author

Commented:
how please?
Sorry, but I didn't get you!!! What exactly do you want?

Author

Commented:
I want to create a H_KET_CURRENT_USER KEY that is accessible to everyone. You mentioned you can do it with a GPO but did not give any details.

The reason is that some of our SSIS packages access some connection strings that are stored in the registry.
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
thank you
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.