Solved

Access to sql server to run ssis

Posted on 2009-07-01
6
691 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?
 

0
Comment
Question by:david_32
  • 3
  • 3
6 Comments
 
LVL 11

Expert Comment

by:Abhay Pujari
ID: 24760774
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?
0
 

Author Comment

by:david_32
ID: 24761159
how please?
0
 
LVL 11

Expert Comment

by:Abhay Pujari
ID: 24761488
Sorry, but I didn't get you!!! What exactly do you want?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:david_32
ID: 24768646
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.
0
 
LVL 11

Accepted Solution

by:
Abhay Pujari earned 500 total points
ID: 24770087
Ok. What I said that you can give read and write permissions through group policy, but can not create the key through it. To assign read and write rights through group policy, you should have a Domain controller in place and follow the steps if you have it

1) Open the GPO you want to use for implementing registry permissions.
2) Expand Computer Configuration | Windows Settings | Security Settings | Registry.
3) Right click the Registry and select Add Key.
4) Locate the Registry key you want to configure permissions for. Select the Registry key and Click OK.
5) Configure the appropriate permissions and Click OK.
6) Make the appropriate selection from the Add Object dialog box and Click OK.
0
 

Author Closing Comment

by:david_32
ID: 31599013
thank you
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQl query 19 14
Task with PowerShell Script is failing with 0x41301 7 41
Sql query for filter 12 23
Sql query 34 22
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now