Wednesday, February 18, 2009

Unable to start mail session Microsoft SQL errors

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} h3 {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:3; font-size:13.5pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} span.EmailStyle16 {mso-style-type:personal; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:windowtext;} span.google-src-text {mso-style-name:google-src-text;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style>Below is an Englsih Google Translation from Turkish of Ekrem Önsoy's blog post with a solution to fix an "Unable to start mail session" error message in Microsoft SQL.  I wanted to re-post it here in English in case and save someone the leg work.  Anyone else have better suggestions for a fix?  Anyone suffering from other SQL woes?  Chew it up in the comments!


"Unable to start mail session (reason:Mail configuration information could not b
Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: ERROR MESSAGE:
"Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database.> System.Data.SqlClient.SqlException: profile name is not valid"

EXPLANATION:
Receive this error, I saw a user habergrubundan and I wanted to archive. The user has created a Mail Profile and Account. Says it can send a test mail. But this account to SQL Server Agent 'ta get this error is when you want to use.

SQL Server Agent 's properties Alert System' from the Mail Profile 's advice was to Enable. We have checked and this setting was also full. Solution of the problem is very interesting.

SOLUTION:
The person experiencing the problem in Microsoft 's in a "Case" was open and it was suggested that as a solution:
- Surface Area Configuration from Database Mail 'i Disable the state,
- Stop SQL Server Agent Service, and start again,
- Surface Area Configuration from Database Mail 'i bring to the state of Enable.

Solution of this and it worked.

You or I would be a day or can it help me.

Not sure what that last line is but Google Translate isn't perfect yet.  Hope this helps!

--

Brian M. Bufalo
http://blog.bmbufalo.com