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 |
|
chamberssh
Starting Member
6 Posts |
 Posted - 2010-09-07 : 14:01:29
|
| Hi,I have successfully created the neccessary encryption certifaicates/keys/master key on a local sql server instance.I would like now to export that same settings to a new client instance so that we can do the following:Make sure that only licensed users are able to log in to the system. So the way I thought I could do this was to create a master encrypted value on our main server and then export this certificate to the client db. Then I would store encrypted values (from our main server) in the client user table. Upon logging into the app the application would attempt to decrypt these values using the orginal installed certificate, upon successful decryot to a value that the application will recognise the user will then be able to log in.Is this sort of thing possible using sql server. I have succesfully restored the certificate onto a new instance but upon running the decrypt it does not recognise the encrytpted value.Any help/suggestions/linkswould be most most welcome/Thanks in advance |
|
|
|
|
|
Exporting Encryption Certificate