SSIS - package encryption

Hi Experts:

I have been having constant problems with this SSIS Package.It is related to this question :
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_25614904.html
rrejan had helped me solve the problem then.

I created this SSIS package with my SQL login and it was working perfectly fine.I was able to run the package from any windows account,but last week we decommisioned our old SQL server and moved data to a new SQL server(both are SQL 2008) and moved all the data to the new server.now when i try to execute the package it does not work,i get a ton of errors.So when I go into the package and change link to my windows account-it works but now other than me noone else can run this package-so basically I am back to square one.

Someone please help!
kmgingeeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BodestoneCommented:
You need to ensure all the user accound have been properly migrated to the new server and have rights on the relevant databases in the user mappings.

It may be as siple as re-publishing the reports though so that the keys are re-published for the new server.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kmgingeeAuthor Commented:
Bodestone:

I think you are right.the error i get says invalid key and something about checking encryption settings.Can you kindly eloborate on  your solution? please note I am a DBA novice.
Thanks again
0
BodestoneCommented:
You would need to open the the report project(s) in BI development studio or whatever the tools was that was used to create it.

Look in the Project menu\Properties and ensure the TargetServerURL is pointign to the new location if it has changed.

You should then be able to deploy the project from the Build menu.
0
BodestoneCommented:
Now you have that of course use the Reporting Services Configuration Manager from the SQL server start menu entry.

From there you can back up the keys to a password protected file.

They can be corrupted if the server restarts unexpectedly and that will save you having to re-publish everything.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.