![]() If you have other data that is encrypted with an old Service Master Key, or any of its descendants, you could lose that data entirely. This can be synchronized with the Backup Service Master Key command, but you should take great care before changing the keys on any server. At a minimum, i would expect the two database servers do not share the same Service Master Key. Opening a key means the Database master key is opened, which in turn requires the Service Master Key to be opened to decrypt the Database Master Key, so the user's key can be used. All Symmetric, and Asymmetric keys keys created in a database are further encrypted with this Master key. This key is stored encrypted in the sys.symmetric_keys table in each database that a Master Key has been created in. All lower keys are encrypted with this key. First is the Service Master Key, which is a server key. There are several levels of encryption on SQL Server. Each morning we perform a database copy (in addition to our standard overnight backup).Each time the copy is performed we get an error on our web site as follows:"Please create a master key in the database or open the master key in the session before performing this operation."This is resolved with the following SQL:OPEN MASTER KEY DECRYPTION BY PASSWORD = 'SQLAuthority'ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEYBut why is this necessary? Is the action of copying causing the Master Key to close? Any comments would be appreciated.We are using SQL Server 2005 Standard edition SP2 on a Windows Server 2003 platform.Thanks and because something doesn't do what you planned it to do doesn't mean it's useless. Hi,A strange problem is occurring and I wonder if anyone has some information on it.I have password encryption on a field in a database table which works fine using a Master Key. We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |