ServiceMasterKey.Import Method (String, String)

Article
07/16/2015

Applies To: SQL Server 2016 Preview

Loads the service master key from the file located at the specified system path by using the specified password.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

public void Import(
    string path,
    string password
)

public:
void Import(
    String^ path,
    String^ password
)

member Import : 
        path:string *
        password:string -> unit

Public Sub Import (
    path As String,
    password As String
)

Parameters

path
Type: System.String

A String value that specifies the system path location of the file to which to save the service master key.

password
Type: System.String

A String value that specifies the password supplied when the service master key was saved to file.

Remarks

Recovers a service master key, in case the service master key has been changed outside of SQL Server. The master key will be decrypted with the supplied credentials, and re-encrypted with the current service account credentials.

Examples

Legacy Code Example

Using Encryption