February 20, 2020 at 10:19 am
I have an RDS issue with a linked server (I know its not good, but I've inherited it)
I keep loosing my linked server and we get the error "an error occurred during encryption"
according to my google assistant and a few hours research every time... this occurs when Amazon switch us onto new hardware and the master key does not match the hardware.
the fix is to recreate the linked server
so for a short term fix I planned on creating a little proc that did a simple select from the linked server then if it failed in the try catch block then it recreated the linked server
here's the problem - I can log in and run the proc and it works fine, but I want it in SQL agent and run every hour, but sql agent doesn't have the permissions to create a linked server. It's so locked down by amazon that i'm fighting an uphill battle.
I've tried using "execute as" and every trick I know. the only way I can see is to create a c# service on our local infrastructure that calls the code
Any Ideas??
MVDBA
February 21, 2020 at 11:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
June 8, 2020 at 10:01 am
Getting an AWS Certified Associate Certification on your resume might be hard but nothing is impossible when you have the backing of valid and proved Practice Test Questions. Dumpspedia has prepared a brilliant set of all-important SAA-C02 Dumps 2020. They are prepared with only one aim and that is to draw top results in Amazon Web Services AWS Certified Solutions Architect - Associate (SAA-C02) Exam. Get these awesome SAA-C02 Practice Test Questions Answers at affordable prices and you can download or print them too.
In this world of ever developing Technology, an IT-Based Certification is a basic demand of the organizations and you'll need a certification such as CompTIA, Cisco, Microsoft, Oracle, HP, IBM, etc, to land your dream job with a promising future. Apply for these exams and leave the preparation for vendor exam to Dumpspedia. We have the best Test Questions to draw satisfactory grades in just one attempt. Our Practice Questions leave no room for the failure. Even the Professionals claimed that after testing Practice Exam Questions themselves. Get your set of PDF Questions from our website now!
August 23, 2022 at 12:00 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply