Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Problem logging on to Integration Services Expand / Collapse
Author
Message
Posted Monday, February 17, 2014 9:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:00 AM
Points: 11, Visits: 21
Hello,

I got a problem with a user who needs to log on to the integration services.

The user ist is "sysadmin" on the SQL Server and I granted him rights in the DCOM configuration for MSSQL Integration Services (remote and local log-on and remote and local execute and start).

But if the user trys to log-on to the integration services it says "Access denied" and I have no idea why.

Is anyone here who might have a clue what to do?

Many thanks

Yours

k.arkenau

P.S.: I attached screenshots of the settings I made, but they are in german. Perhaps someone can do something with then even though they are not in english.


  Post Attachments 
bild1.png (8 views, 13.03 KB)
bild2.png (10 views, 67.48 KB)
bild3.png (9 views, 68.80 KB)
Post #1542195
Posted Monday, February 17, 2014 10:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:28 AM
Points: 5,962, Visits: 12,849
k.arkenau (2/17/2014)
Hello,

I got a problem with a user who needs to log on to the integration services.

The user ist is "sysadmin" on the SQL Server and I granted him rights in the DCOM configuration for MSSQL Integration Services (remote and local log-on and remote and local execute and start).

But if the user trys to log-on to the integration services it says "Access denied" and I have no idea why.

Is anyone here who might have a clue what to do?

Many thanks

Yours

k.arkenau

P.S.: I attached screenshots of the settings I made, but they are in german. Perhaps someone can do something with then even though they are not in english.

Firstly, don't grant the user directly to the DCOM permissons in Component services. There is a local Windows group called "Distributed COM Users", use this local group to secure the required permissons and add domain users or groups to the local group.

On the Security tab you need to set permissions in the Launch and Activation Permissions and the Access Permissions. Restart the service after change these permissions


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1542229
Posted Wednesday, March 19, 2014 1:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:00 AM
Points: 11, Visits: 21
Ok, I changed that and added the User to the DCOM User group.

Nevertheless, the user still cannot logon to the information services.

Any idea?
Post #1552474
Posted Wednesday, March 19, 2014 1:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:28 AM
Points: 5,962, Visits: 12,849
k.arkenau (3/19/2014)
Ok, I changed that and added the User to the DCOM User group.

Nevertheless, the user still cannot logon to the information services.

Any idea?

If you used distributed com users group ensure the user is a member of this group.

Did you set both sets of permissions?
Do you still get the same error?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1552480
Posted Wednesday, March 19, 2014 2:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:00 AM
Points: 11, Visits: 21
Hello,

I just checked it once more:

Yes, the User is member of the group Distributed COM-User and the group has the permissions you talked about.

But if the user trys to log on to "Integration Services" it says "Access denied".
Post #1552484
Posted Thursday, March 20, 2014 8:11 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 17, 2014 8:20 AM
Points: 547, Visits: 1,126
In the properties of his login in Security in Management Studio, user mapping tab, msdb database, I think he should have one of the db_ssis..... roles ticked, probably db_ssisadmin.
Being sysadmin doesn't give it by default. Books Online will tell you more.
Post #1553031
Posted Thursday, March 20, 2014 8:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 21, 2014 8:16 AM
Points: 9, Visits: 10
I found this link helpful for that same scenario, the permission changes you need are defined in the section Eliminating the "Access is Denied" Error:

http://technet.microsoft.com/en-us/library/aa337083.aspx
Post #1553037
Posted Thursday, March 20, 2014 8:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:00 AM
Points: 11, Visits: 21
As the user did a lot of programming on the Database, he is sysadmin already.
Post #1553042
Posted Thursday, March 20, 2014 8:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:00 AM
Points: 11, Visits: 21
That is what I already did...als told above.
Post #1553043
Posted Thursday, March 20, 2014 8:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 21, 2014 8:16 AM
Points: 9, Visits: 10
This process worked for me:

Verify account is member of Distributed COM Users

@ Component services, My Computer, DCOM Config, Microsoft SQL Server Integration services 11.0, Properties, Security, add account


Edit <Install path; mine is D>:\Program Files\Microsoft SQL Server\110\DTS\Binn\MsDtsSrvr.ini.xml, add new instance(s)

Regedit HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\SSIS\ServiceConfigFile
<Installpath: mine is D>:\Program Files\Microsoft SQL Server\110\DTS\Binn\ MsDtsSrvr.ini.xml

Grant account db_ssisadmin permissions in MSDB

Restart IS

Post #1553063
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse