question

takara59 avatar image
takara59 asked

SQL Agent Unable to refresh Database Mail profile, mail configuration could not be read.

Everything was working fine till last week when we had issues with our mail server. I was instructed my our admin to change from the ip address in the dbmail provile to and smtp address. Since then I have been having issues. Right now it is just with SQL agent , which is still pretty important. Here is what I have:

In Database Mail, I have a profile with an account. If I use this profile in using sp_send_dbmail, I get the email.

My issue is with SQL Server Agent. I have gone to properties , alerts and have the database mail profile specified.

If I stop and start the SQL server agent I get the message

[474] Unable to refresh Database Mail profile XXprofilenameXX. (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)

)


sql-server-agent
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.