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

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

Cannot create a connection to the datasource 'DataSource1'

Hello, I Created a report with reportbuilder, after clicking on Run Report I got this message, Its very strange it seems that its trying to generate or create a datasource.

Para obtener más información acerca de este error, vaya al servidor de informes en el equipo del servidor local o habilite los errores remotos
-
No se puede crear una conexión al origen de datos 'dataSource1'.
-
Error al procesar el informe.

Hello,

This error means that the connection could not be established with the information provided in the data source element, named 'dataSource1', which is in the RDL that report builder creates.

There should be more information regarding why this error occurred in the log files. See the following link on how to locate the log files.

http://msdn2.microsoft.com/en-us/library/ms157403.aspx

Ian