Cannot create Database Mail Account

Hello all,

I get a strange error message when I try to create a Database Mail account. I know the script is OK because it works fine on another SQL 2005 Server. This script is as follows:

exec msdb.dbo.sysmail_add_account_sp

@.account_name = 'SMTPAccount01' ,

@.email_address = 'someone@.somecompany.com' ,

@.display_name = 'Sales System - Company Name' ,

@.replyto_address = ''someone@.somecompany.com' ,

@.description = 'SMTPAccount01' ,

@.mailserver_name = 'somecompany.com' ,

@.port = 25 ,

@.username = 'someone+somecompany.com' ,

@.password = '1234'

The error message I get is:

Msg 15466, Level 16, State 2, Line 1

An error occurred during decryption.

I tried installing SP2 and that didn't help.

Someone help please!

Thanks in advance.

Jerome Smith

For starters, you have back to back quotes in the @.replyto_address operand.

Has this database been restored from another box?

|||

Hi.

No, that's just a typo in this message. The real script has single quotes.

Yes, the user database has been restored from another box. However, this script just updates the msdb database; therefore it shouldn't be affected by the user database.

Jerome

|||

You most likely have a problem with the SMK.

Check out:

http://blogs.msdn.com/lcris/archive/2005/07/08/437048.aspx

|||

Thank you Dale.

I'll try regenerating the SMK and give you feedback on how it goes.

Jerome

|||

Hi Dale,

I solved the problem with the knowledge from the article you gave me. I regenerated the SMK with the following instruction:

ALTER SERVICE MASTER KEY FORCE REGENERATE

After that I was able to create the Database Mail account.

Thank you very much indeed!

Jerome Smith