-- Step 1: Get the encrypted blob SELECT name, remote_user, encrypted_password FROM sys.linked_logins; -- Step 2: Decrypt it (requires sysadmin role) OPEN SYMMETRIC KEY SMK_KEY DECRYPTION BY CERTIFICATE SMK_Cert;
SELECT name, password_hash FROM sys.sql_logins WHERE name = 'sa'; sql server password decrypt
SELECT CAST(DecryptByKey(encrypted_password) AS varchar(100)) FROM sys.linked_logins; -- Step 1: Get the encrypted blob SELECT