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

Cannot connect to SSIS from SSMS Expand / Collapse
Author
Message
Posted Friday, June 6, 2008 11:13 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 18, 2014 11:20 AM
Points: 88, Visits: 364
I am using SP2 and cant connect to SSIS from SSMS. Also, I have another problem. I try to connect to Integration services using SSMS and want to connect using sql server authentication. Its not even allowing me to go to that option. Its like disabled. Though I can connect to database services using sql server authentication. Any help would be a lot of help.

Thanks in advance,
NIkhil Parsi
Post #513095
Posted Friday, June 6, 2008 11:38 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 4:51 PM
Points: 4,065, Visits: 5,298
See reply here:
http://www.sqlservercentral.com/Forums/Topic512974-148-1.aspx#bm513016


Greg
Post #513109
Posted Friday, June 6, 2008 11:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 18, 2014 11:20 AM
Points: 88, Visits: 364
Thanks for the reply,

But if that is the case, why do they even have it in SSMS? I thought it is there for a reason. I mean I could login and execute it as a sysadmin but cant do it without that permission. If you guys know anything else, it will be helpful.

N
Post #513116
Posted Friday, June 6, 2008 2:24 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Monday, August 18, 2014 8:24 AM
Points: 6,634, Visits: 1,871
You can connect if you have a Windows account with the correct permissions (and that's the account you start up SSMS with). So you can manage SSIS from SSMS, you just must do so with a Windows account.


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #513217
Posted Thursday, June 12, 2008 3:23 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, October 26, 2012 2:14 PM
Points: 402, Visits: 598
For connecting remotely using SSMS you need to have configured permissions to the DCOM config node and provide access permissions to connect to SSIS. Refer this link for more info,
http://deepakrangarajan.blogspot.com/2008/03/connecting-to-integration-service-on.html


- Deepak
Post #515741
Posted Tuesday, October 6, 2009 3:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 22, 2011 4:13 AM
Points: 1,149, Visits: 603
Thanks Deepak

Just had the same problem on one of our servers and your blog fixed it for me
Post #798372
Posted Tuesday, September 3, 2013 1:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 1:20 AM
Points: 58, Visits: 105
Deepak ,Kindly provide alternative link for your blog ,bcz older one is no more active
Post #1490788
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse