ALTER CREDENTIAL SYNTAX – SQL SERVER

ALTER CREDENTIAL SYNTAX

SYNTAX:
[sql]
ALTER CREDENTIAL credentialname WITH IDENTITY = ‘identityname’
, SECRET = ‘secret’
[/sql]

The IDENTITY and SECRET for a credential can be changed using ALTER CREDENTIAL.

Example of Alter Credential:
[sql]
USE [master]
GO
ALTER CREDENTIAL [credential1] WITH IDENTITY = N’username1′, SECRET = N’password1′
GO
[/sql]

USING SQL SERVER MANAGEMENT STUDIO (SSMS) TO ALTER CREDENTIAL:

  • Open SSMS and connect to the server in object explorer.
  • Expand server and Security
  • In Security Expand

    Alter Credential
    Double Click on the credential name
  • DoubleClick on the Credential name
  • Credential properties dailog will pop up

    Credential Properties
    Credential Properties
  • Now change the credential properties such as IDENTITY, Password and click on Ok