November 12, 2009 at 7:59 am
SSIS 2005 - can I change the author of my package to be the same login as the proxy uses to run on a job?
It seems from my research that the login the company has created to run jobs is not set to run
SSIS in packages becasue it needs to be the package author to be that same login and not the person who logged in and created the package ,which was me(my login).
November 12, 2009 at 10:10 am
You can't change the package owner. What you should do is change the protection level of the package so it can be run by a login other than the author. By default it's set to EncryptAllWithUserKey. Change it to EncryptAllWithPassword or EncryptSensitiveWithPassword and provide the password in the job step.
You could also change protection level to ServerStorage and save the package to msdb in SQL Server. You could then use the Integration Services fixed database roles in msdb to control who can run the package.
Greg
November 12, 2009 at 1:22 pm
Thanks Greg. I am stuck between 2 rocks and a hard space.
I save in server storage , error,can't save.
So I tried micosfts next method for getting a package to run in a job.
ANd yes I have been follwing examples on using the proxy with the credential for the SSIS subsystem and I go to my job and put
the Proxy_User in the step to run the package and i get an error telling me to look in the log. That is why I am trying this method.
By the way can have an idea why the credntial proxy method did not work .
I am the author login Domain/AdamSpencer , the user my IT guys created and use for other jobs has all the right MSDB permissions and he is the login for my Credential. But I am confused, he still did not author the package. In the proxy I use the credential thta is using his login. But where is the author in all this. According to what I read , I should be the
I in my development instance connected to IS services > right click msdb and tried to import >
everything was going so great since i saved my package encryptsensUsingpassword > so in my import window >
i selected it from the file system and hit the elipse for 'Encrypt sensitive data with password' > but after I type in the password and hit ok I get this error
has anyone seen it and i changed my config file as micosoft specified and got the same. Do I need to install something
like IS serverices support files from the cd. Anyone got rid of this message before?
TITLE: Import Package
------------------------------
The SQL server specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in Server 2005 Books Online.
Client unable to establish connection
Encryption not supported on SQL Server. (MsDtsSrvr)
------------------------------
ADDITIONAL INFORMATION:
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
------------------------------
BUTTONS:
OK
------------------------------
November 13, 2009 at 9:51 am
Hi Adam,
I haven't seen that error message. Is it possible that the SQL Server instance name specified in the config file is misspelled or doesn't exist on the server where you're trying to import the package?
Greg
November 13, 2009 at 10:02 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply