<div>
Is the MS Outlook profile you set up set as Default?
</div>


Is the MS Outlook profile you set up set as Default?

<div>
First I must correct the Question. &nbsp;This is SQL Server 2000 and not 2005. &nbsp;In answer to your question, when I right click the SQL Mail setting the profile setting is Outlook. &nbsp;On this server the only Outlook user configured is the Administrator.
</div>


First I must correct the Question.  This is SQL Server 2000 and not 2005.  In answer to your question, when I right click the SQL Mail setting the profile setting is Outlook.  On this server the only Outlook user configured is the Administrator.

<div>
Think my mail client is ok. &nbsp;This command runs fine on my server:<br />
<br />
exec xp_test_mapi_profile outlook
</div>


Think my mail client is ok.  This command runs fine on my server:

exec xp_test_mapi_profile outlook

<div>
<div class="content wysiwyg-content">
Trying to setup sqlmail on SQL Server 2005. &nbsp;Both the sql service and the agent service are running using the Administrator account. &nbsp;I setup Outlook 2003 on the server machine with an account for Administrator. &nbsp;I can both send from and receive into this Outlook accont.<br />
<br />
Defined a sql operator named Administrator which uses the new email account created. &nbsp;However when I look at the Sql agent properties the Mail Session box is greyed out. &nbsp;Also when I try to send a Test email to the Operator the message displayed is &quot;The Sql Server Agent Mail session is not running&quot;.
</div>
</div>


Trying to setup sqlmail on SQL Server 2005.  Both the sql service and the agent service are running using the Administrator account.  I setup Outlook 2003 on the server machine with an account for Administrator.  I can both send from and receive into this Outlook accont.

Defined a sql operator named Administrator which uses the new email account created.  However when I look at the Sql agent properties the Mail Session box is greyed out.  Also when I try to send a Test email to the Operator the message displayed is "The Sql Server Agent Mail session is not running".

Configure SQLMAIL Problem

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.