Solved

sql2008 sys.symmetrics_keys

Posted on 2013-01-28
2
326 Views
Last Modified: 2013-02-22
Hi,
I wonder what is use of this key when we installed sql 2008 ? it seems there in Master db ##MS_ServiceMasterKey##  and for ##MS_DatabaseMasterKey##   is the user db is encrypted ? but I don't think it use for TDE.

name                          principal_id symmetric_key_id key_length  key_algorithm algorithm_desc                                               create_date             modify_date             key_guid                             key_thumbprint                                                                                                                                                                                                                                                   provider_type                                                cryptographic_provider_guid          cryptographic_provider_algid
----------------------------- ------------ ---------------- ----------- ------------- ------------------------------------------------------------ ----------------------- ----------------------- ------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ------------------------------------ ------------------------------
##MS_ServiceMasterKey##       1            102              128         D3            TRIPLE_DES                                                   2012-01-07 06:24:00.507 2012-02-09 06:33:59.060 CE72EE2E-F077-4B64-B803-D11FD12E4BC6 NULL                                                                                                                                                                                                                                                             NULL                                                         NULL                                 NULL

(1 row(s) affected)









name                          principal_id symmetric_key_id key_length  key_algorithm algorithm_desc                                               create_date             modify_date             key_guid                             key_thumbprint                                                                                                                                                                                                                                                   provider_type                                                cryptographic_provider_guid          cryptographic_provider_algid
----------------------------- ------------ ---------------- ----------- ------------- ------------------------------------------------------------ ----------------------- ----------------------- ------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ------------------------------------ ------------------------------
##MS_DatabaseMasterKey##      1            101              128         D3            TRIPLE_DES                                                   2012-09-18 14:51:21.077 2012-09-18 14:51:21.080 8EAD9200-E2C1-4668-815F-C68F5AAF8ABA NULL                                                                                                                                                                                                                                                             NULL                                                         NULL                                 NULL

(1 row(s) affected)
0
Comment
Question by:motioneye
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
deviprasadg earned 500 total points
ID: 38830041
MS_DatabaseMasterKey is used for database encryption and is different for each database.

MS_ServiceMasterKey is a symmetric key  used for saving linked server login passwords , credential secrets etc..

Refer:
http://www.kodyaz.com/articles/sql-server-2005-database-encryption-step-by-step.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/f4d292c0-72d5-4075-adf3-03427542567e/
0
 

Author Comment

by:motioneye
ID: 38830069
so,
when we installed sql 2008 and have the lnked  server, credential saved, we should have this backup, is it correct ?
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question