New-SqlCredential
Creates a SQL Server credential object.
In this article
Syntax
New-SqlCredential
-Identity
[-Secret ]
[-ProviderName ]
[-Name]
[[-Path] ]
[-Script]
[-WhatIf]
[-Confirm]
[]
New-SqlCredential
-Identity
[-Secret ]
[-ProviderName ]
[-Name]
[-InputObject]
[-Script]
[-WhatIf]
[-Confirm]
[]
Description
The New-SqlCredential cmdlet creates a new SQL Server credential object.
A SQL Server credential object is used to store authentication information.
The SQL Server credential is required when backing up to or restoring from the
Windows Azure storage service, and is used to store the Windows Azure storage
account name and access key information.
Examples
Example 1: Create a SQL credential for the current instance of SQL Server
PS C:\> cd SQLServer:\SQL\Computer\Instance
PS SQLServer:\SQL\Computer\Instance> New-SqlCredential -Name "MySqlCredential" -Identity "MyWindowsAzureStorageAccount" -Secret "P4ssw0rd"
The first command changes the directory to SQLServer:\SQL\Computer\Instance.
Example 2: Create a SQL credential for all instances of SQL Server
PS C:\> cd SQLServer:\SQL\Computer\Instance
PS SQLServer:\SQL\Computer\Instance> $SecureString = ConvertTo-SecureString "P4ssw0rd" -AsPlainText -Force
PS SQLServer:\SQL\Computer\Instance> $Instances = Get-ChildItem
PS SQLServer:\SQL\Computer\Instance> $Instances | New-SqlCredential -Name "MySqlCredential" -Identity "MyWindowsAzureStorageAccount" -Secret $SecureString
The first command changes the directory to SQLServer:\SQL\Computer\Instance.
The forth command uses the pipeline to pass the instances to the New-SqlCredential to create a SQL Credential
named MySqlCredential on all the instances of SQL Server.
Parameters
-Confirm
Prompts you for confirmation before running the cmdlet.
Type:SwitchParameter
Aliases:cf
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False
-Identity
Specifies the name of user or account.
For Windows Azure storage service authentication, this is the name of the Windows Azure storage account.
Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-InputObject
Specifies the Server object where the credential should be created.
Type:Server
Position:2
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-Name
Specifies the name of the credential.
Type:String
Position:1
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Path
Specifies the path of the instance of SQL Server for which this cmdlet runs the operation.
If you do not specify a value for this parameter, the cmdlet uses the current working location.
Type:String
Position:2
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ProviderName
Specifies the cryptographic provider name for the Enterprise Key Management Provider (EKM).
Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Script
Indicates that this cmdlet returns a Transact-SQL script that performs the task that this cmdlet performs.
Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Secret
Specifies the password for the user or account.
For Windows Azure storage service authentication, this is the storage account access key value.
Type:SecureString
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Type:SwitchParameter
Aliases:wi
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False
Inputs
Microsoft.SqlServer.Management.Smo.Server
Related Links