SQL SERVER Database mail Problem “Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)” How to resolve ?

Dear All,

Sometimes it happened when this kind of issue came you did everything according to basic rules for database mail setting in SQL Server and when you try to send the mail through SQL server you got error

"Exception Type: System.NullReferenceException

Message: Object reference not set to an instance of an object.

Data: System.Collections.ListDictionaryInternal

TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)”

When you tried to resolve it you search a lot of google you did not get a proper result.

I faced this problem with SQL Server 2005 edition with SQL Server Service Pack1.

Here I am sharing how simple to resolve this.  Simplest step is to Update SQL server service Pack 2 &  SQL server service pack 3.

You can download  SQL server service pack 2 with link http://www.microsoft.com/en-us/download/details.aspx?id=9969

and SQL server Service pack 3 with link http://www.microsoft.com/en-us/download/details.aspx?id=14752

Once you install it and after restart your SQL server mail function started Isn’t it simple.

I hope this resolve the problem of my friends who searched a lot on Google but could not get a proper solution.

Enjoy.

Thanks & Best Regards,

Rajat Jaiswal

Advertisements

One thought on “SQL SERVER Database mail Problem “Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)” How to resolve ?

  1. hello sir, i want to learn andriod application in dot net. pls. if possible send me tutorial for that. Thanks in advance.

    On Thu, Apr 18, 2013 at 8:38 AM, Asp.net & Sql server fundas with Raj

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s