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.
would be most most welcome/
Thanks in advance
View Complete Post