August 25, 2009 at 2:18 am
Hello,
I have a strange problem.
It seems some of you had a similar problem, but it looks mine is different for whatever reason.
I created a package onmy laptop that just creates a table in an excell sheet.
It works perfectly, when the excell file does not exist, it is created and the table is created in the excell file as a sheet.
Now, when deployed on a server and executed from a sql job, it fails with following error.
"Connection may not be configured correctly or you may not have the right permissions on this connection"
Yes, it is a 64 bit server (windows server 64 standard), but with 32 bit sqlserver (standard edition).
So, the SSIS is already running in 32 bit mode.
It runs with a proxy user, when i change the proxyuser which is a user on windows, to an administrator account of the server, it works, as i figured out when running the package manually.
So, my guess is that there is a security problem, but which ?
I would not like to use the administrator account being used as a proxy.
Does anybody know what the problem is, and how to solve it ?
regards and thanks for any ,help.
Jurgen
August 25, 2009 at 2:36 am
Just find out that adding the user to the windows administrator group helps, but is shouldn't be an administrator of the server.
Question is what sort of priviliges does that user need to access excell via SSIS ?
August 25, 2009 at 7:36 am
not quite sure what what you are asking. The windows ID must be able to access the folder and read the file.
It looks like this os only the case when the user is added as an administrator. Would suggest the file permissions for that folder need to be changed to include the windows user and then remove the administrator privelages from that windows account and try again.
Ells
😎
August 26, 2009 at 2:51 am
"not quite sure what what you are asking. The windows ID must be able to access the folder and read the file."
Well, it has access, read, write, execute, change.
"It looks like this os only the case when the user is added as an administrator. Would suggest the file permissions for"
"that folder need to be changed to include the windows user and then remove the administrator privelages from that "
"windows account and try again."
Done that, does not work.
August 26, 2009 at 6:19 am
You are executing the SSIS package from a SQL job. Are you executing the SQL Job on your laptop or on the server?
What is the package protection level in the SSIS Package?
When you run the package on your laptop did you run it as you or the proxy account?
HTH
Ells.:cool:
August 26, 2009 at 7:23 am
The SSIS package is always run as a job on the server.
The excell file is located on the server itself.
The protectionlevel is EncryptSensitiveWithUserKey.
I have not been able to run the the package manually with the proxy account (security ...)
Thanks for your reply.
regards,
Jurgen
August 26, 2009 at 7:56 am
EncryptSensitiveWithUserKey -
I have just built some packages so have been looking at the security level. I can not find written proof that this is true but I suspect that the poroxy account may not be able to open \ edit or execute the package.
I wish I could say that as a fact but I cant it is just a feeling I have and I am prepared for criticism if I am wrong. I sent one of our guys some packages and he was able to execute as an administrator and edit them with this permission. I believe as a normal user thats not true.
Hope the above is true and helps you out.
Ells
(crossed fingers)
August 26, 2009 at 8:46 am
The package is ok, all code is executed, links to other sqlservers work (authenticated, sqlserver connections, usage of configuration files, etc, works fine, just the connection to the excell file fails.
August 26, 2009 at 9:06 am
Thanks.
Are you using any expressions or package configurations that would affect where you think the Excel file will be?
:w00t:
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply