Hi all,
I have a non-sysadmin SQL-user with sufficient permissions to create a job that executes a SSIS package. When that SQL-user is browsing to a SSIS config file (from within the job-step) the browser window shows no available drives.
I've searched the internet and found this browser window executes the XP_FIXEDDRIVES stored procedure in the background. When this stored procedure is executed by a non-sysadmin it returns an empty result. When executed by a sysadmin it shows all available drives.
When I (for testing purposes) elevate the permissions of this SQL user to be a sysadmin, all available drives show up in the browser window. But I don't want to give him sysadmin permissions!!
So, what do I need to do to show the available drives in the browser window (i.e. let him execute XP_FIXEDDRIVES and get the correct resultset) without assigning him SYSADMIN permissions?
P.S. I'm working with SQL 2008 R2 SP1 (64-bit).
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **