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

SSIS and SQL Server Security Options Expand / Collapse
Author
Message
Posted Friday, June 6, 2008 8:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 31, 2008 10:45 AM
Points: 18, Visits: 36
We use SQL 2005 Enterprise 32 bit.
SSQL Service and BI Services are running on the same Windows Server.
SQL Server 2005 is operating in the mixed secutrity mode.

I can easily connect to SQL 2005 from VS.NET 2005/BIDS using SQL
Server account and then build SSIS project in VS.NET 2005/BIDS.

Yet, if I try to connect to SSIS Server from SQL Server Management
Studio, the option "Connect with SQL Server account" is disabled.

"SQL Server Active Directory Helper" service is so far disabled on the
server. SSIS service is running under default Windows Network Account.

Thanks in advance for your help!


Post #512974
Posted Friday, June 6, 2008 9:25 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 7, 2014 3:54 PM
Points: 4,065, Visits: 5,296
Integration Services is not part of SQL Server, but runs as a seperate service. Thus, it doesn't know anything about SQL Server logins. You can use SQL Server logins in connection managers for databases in a package, but you can't manage or execute packages from a SQL Server login. This is the same behaviour as DTS in SQL 2000.

Greg
Post #513016
Posted Friday, June 6, 2008 12:07 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 31, 2008 10:45 AM
Points: 18, Visits: 36
Greg,

Thanks for your response.

Yet, could you further clarify the issue with establishing a connection to SSIS from SQL Server management Studio:
- Could this connection be established at all?
- What are major prerequisites?

Thanks for your help again.

Alex

Post #513125
Posted Friday, June 6, 2008 2:23 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
Yes, you can connect to SSIS from SSMS. However, you must do so using a Windows account. SQL Server logins don't work. Hence the reason you can't change the login type for the Connection dialog window.


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 #513216
Posted Friday, June 6, 2008 2:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 31, 2008 10:45 AM
Points: 18, Visits: 36
Brian,

Thank you for the precise response.

That's just what I was looking for.

Regards,

Alex
Post #513232
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse