Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sekharad
Starting Member
1 Post |
 Posted - 2011-11-16 : 11:00:58
|
| Hi,I am new to SQL server 2005. I have two SQL server 2005 servers and communicate by using linked servers. The data in the second server (let`s say SERVER 2) is encrypted by symmetric key using "TRIPLE_DES" and I need to access this information from a stored procedure from SERVER 1. What are the minimum rights required to access the information? Any help will be greatly appreciated.Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-16 : 11:15:50
|
| Need to decrypt it on the remote server 1st. |
 |
|
|
|
|
|
Access linked server encrypted data