DBMAIL error unable to start mail session

• ERIC CRUDELI

  SSCommitted

  Points: 1786

  More actions

  June 3, 2016 at 12:31 am

  #310925

  Hello Guys,

  I got a strange error.

  When I start SQL Agent service, I got this error :

  Date03/06/2016 08:19:00

  JournalAgent SQL Server (Actuel(le) - 03/06/2016 08:19:00)

  Message

  [260] Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. ---> System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.

  at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)

  --- End of inner exception stack trace ---

  at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)

  )

  The version of SQL is : Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

  Well ...

  Everything works fine I can send mail and receive it on mailbox.

  Basically, I change the account who start the SQL Agent Service. I used AD Service account. Initially I was local account and it was declared in Admin Group and sysadmin.

  When I go back to the original account the error message disappears.

  Do you have a idea ? It's look like the account doesn't enought right to read in database and started mail session (I supposed MSDB)

  I hope I'm enought clear.

  Thanks for your help,

  Eric