Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 26 of 212

16 C H A P T E R 2 | Better security Figure 2-2: New Column Master Key dialog box. Note You should perform these steps on a trusted machine, but not on the computer hosting your SQL Server instance. That way, the data remains protected in SQL Server even if the host computer is compromised. After creating the certificate and configuring it as a column master key, you must then export and distribute it to all computers hosting clients requiring access to the data. If a client application is web- based, you must load the certificate on the web server. If it is an application installed on users' computers, then you must deploy the certificate to each user's computer individually. You can find applicable instructions for exporting and importing certificates for your operating system at the following URLs: Exporting certificates Windows 7 and Windows Server 2008 R2: https://technet.microsoft.com/en- us/library/cc730988.aspx. Windows 8 and Windows Server 2012: https://technet.microsoft.com/en- us/library/hh848628(v=wps.620).aspx. Windows 8.1 and Windows Server 2012 R2: https://technet.microsoft.com/en- us/library/hh848628(v=wps.630).aspx. Windows 10 and Windows Server 2016: https://technet.microsoft.com/en- us/library/hh848628(v=wps.640).aspx. Importing certificates Windows 7 and Windows Server 2008 R2: https://technet.microsoft.com/en- us/library/cc754489.aspx. Windows 8 and Windows Server 2012: https://technet.microsoft.com/en- us/library/hh848630(v=wps.620).aspx.

Articles in this issue

Links on this page

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016