(system.security)' on registered server import (ssms) asked 6 years, 10 months ago modified 1 year, 9 months ago viewed 20k times My database is a sql server 2008r2, the ssis was developed in data tools 2008 I've been getting the key not valid for use in specified state message in both ssms versions 19 and 20
JAIDEANGEL.C0M | Instagram, Facebook | Linktree
My understanding is that this error comes from an encrypted password stored as part of a registered server.
Issue was likely caused by my domain password changing a few days ago while ssms was open
If you run into a similar problem and it doesn't go away with a simple restart, make sure you check control panel\user accounts\credential manager for cached account info and/or try a reboot. Check parameter names and initial values. It also says you can try phone call verification, or instead have users install the azure authenticator app. Key not valid for use in specified state what i already tried
I imported the certificate from the old server and it seems to be good/ 2 I checked the security permissions of the certificate, and they are the same as those on the old server 3 Also the machine key definitions on the iis seems to be the same Ssms 18.10 has no support for sql server 2022
Minimal support for it was added in 18.12, however, if you are using sql server 2022 you should be using ssms 19, which has full support for sql server 2022
Of course, this doesn't change my point on the edit top 200 rows feature I use a designated sql server login and password for the source database and integrated windows security for the target database Within ssis i am able to run each package without a problem To ensure this package ran on a schedule, i set up a ssms job on the same server as the ssis package.
Key not valid for use in specified state At system.security.cryptography.protecteddata.unprotect(byte[] encrypteddata, byte[] optionalentropy, dataprotectionscope scope) at microsoft.sqlserver.management.registeredservers.registeredserver.protectdata(string input, boolean encrypt) I have a ssis package deployed in my server
