Post reply

Database Mail Credential Name Change

  • November 29, 2011 at 9:57 am

    #251248

    We have a Database Mail account configured for SMTP mail to send out emails using Basic Authentication. With this a new Credential is created. Unfortunately the Credential Name is displayed as a GUID instead of an easily recognizable name. When you open the Cred in the UI the Name is disabled so it can't be modified. In looking at the ALTER CREDENTIAL cmd there doesn't appear to be any options to modify this either. Does anyone know of a way to alter the Cred Name?

  • November 29, 2011 at 10:09 am

    #1414231

    can't you easily see the credential_identity column from select * from sys.credentials?

    why do you want to rename the name column if the credential_identity column has the clearer description?

    anyway, you are right, it looks like you'll have to drop the crednetial and create it with an explicit name instead...but i don't know how to tie it in to make sure THAT new credential is used for the SMTP AUTH command.

    CREATE CREDENTIAL credential_name WITH IDENTITY = 'identity_name'

    [ , SECRET = 'secret' ]

    [ FOR CRYPTOGRAPHIC PROVIDER cryptographic_provider_name ]

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 29, 2011 at 10:15 am

    #1414235

    Some of our "admins" are not very savvy (i.e. SQL is not a language they know). So they use SSMS the majority of the time. When they refresh our Test environment with databases from Prod they continually neglect to do simple things like set up security for Test or remap user SIDs to the database instance.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply