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:

ALTERSERVICEMASTERKEYFORCE REGENERATE

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

Thank you very much indeed!

Jerome Smith