Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS and SQL Server Security Options RE: SSIS and SQL Server Security Options
K. Brian Kelley
SSC Guru
Points: 114562
More actions
June 6, 2008 at 2:23 pm
#825715
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@kbriankelley