March 17, 2008 at 1:22 pm
A user, only uses SQL 2005 client tools without any local access to the server box, has sa access (SQL Authentication) to the SQL SSMS. How to access SSIS from his client tools?
I clicked the connect from the client tools in SSMS using his account. But the login window only has Windows Authentication.
Is there any way to access SSIS from the client tools?
Any input will be greatly appreciated.
March 19, 2008 at 11:02 am
It only shows up as Windows Auth. ONLY, greyed out as well, for me.
I wonder if this has to do with how SSIS was installed to begin with. I forget how I installed mine, but could it be that Mixed Auth. was not picked during the install? If that's the case, you will not be able to use a SQL Auth. login to connect.
Any of the SSIS gurus willing to confirm this?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 12:05 pm
I confirm it. I can use either Windows authentication or SQL authentication in connecting database engine. But when trying to connect SSIS, I only have Windows authentication.
If my account and the database server are in the same domain, it will be fine. Otherwise, I cannot change anything.
But I am not a guru. 😛
March 19, 2008 at 12:21 pm
Not clear how this works. For me, SSIS is installed on the default instance (no instance name), whereas the database engine is installed on a named instance. Could it be that a different mode of auth. is used for each?
Thinking out loud...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 12:35 pm
SSIS is not instance aware, meaning you don't have multiple instances of SSIS on a server. One instance of SSIS is used by multiple instances of the SQL Server database engine.
😎
March 19, 2008 at 12:45 pm
Thank you.
The question still remains though as to whether SSIS can be accessed through SQL auth.
The auth. mode is greyed out on my conn dialog to SSIS.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 12:53 pm
Unfortunately, I'm not sure what context you are talking about. There is the ability to connect to SSIS from SSMS, but that is limited, and I am using Windows Authentication, so not much help there I guess.
The other access to SSIS is from BIDS, and again, we are using Windows authentication. Haven't had a requirement (yet) to even try using SQL authentication.
😎
March 19, 2008 at 12:59 pm
Same thing with me. Because I have sysadmin privileges I never had to worry about configuring access permissions to SSIS. The issue is allowing someone else to have that access to SSIS through SSMS.
Not sure how it's done. There is no Security node in the SSIS instance in Object Explorer on which one could configure permissions...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 1:15 pm
I guess i haven't figured out what kind of access you are trying to grant to others. That really hasn't been mentioned, or else i just have missed it.
I mean, there isn't much you can do when connected to SSIS using SSMS. You import and export packages, you run packages, that's about it.
😎
March 19, 2008 at 1:24 pm
Lynn Pettis (3/19/2008)
I mean, there isn't much you can do when connected to SSIS using SSMS. You import and export packages, you run packages, that's about it.
Agreed.
Precisely who has access to do this stuff and how can that be configured?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply