March 1, 2011 at 6:38 am
Hi guy, after the sysadmin update sql server for sp2-->sp4. I got this error when trying to send mail.
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.IndexOutOfRangeException: timeout
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)
--- E)
Any explication and solution ?
March 1, 2011 at 11:04 am
My [sysmail_help_admin_account_sp] are not the same on DEV/PROD server for SQL Server 2005 sp4 do u think I can update this or another script for update this sp ?
On SQL Server 2005 SP4
The system table sysmail_server have a [timeout] Column on your server ?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply