asked on

sql mail profile sql 2005

i have a mail profile created when i am trying to send a test message this is the error i am getting in mail log

Exception Type: Microsoft.SqlServer.Management.SqllMail.Server.Common.BaseException Message:Could not retrieve item from the queue. reason. the list of accounts which could send this mail is empty (probably dude to use of invalid profile).

can some one help me to fix this,

ymiossec

how did you define the profile you use to send that email ?
Give more details...

romeiovasu

ASKER

i have created the profile in sql server itself.

Brad Howe

DId you restart the SQL Agent after configuring the mail profile for it.

There are two mail systems, SQL Mail, run by the SQL Server database engine used to send applicaiton emails etc , and SQL Agent Mail, run by SQL Agent which uses Database Mail set up with a profile for the SQL Agent to send alerts/ notifications.

Do you have Database Mail and SQL Mail both defined to use the profile?

- Hades666

ASKER CERTIFIED SOLUTION

Brad Howe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

romeiovasu

ASKER

how to configure gmail server as an smtp mail component for sql server.

Brad Howe

Hi,

START \ add remove windows components and install IIS with SMTP Services.
I don't know what verion OS you have.

2003
http://msdn.microsoft.com/en-us/library/8b83ac7t.aspx

2008
Windows 2008 Server Manager Features right-click Add Feature SMTP Server

To manage the SMTP service on Windows Server 2008, you must use Internet Information Services (IIS) 6.0 Manager. Ensure that you install IIS 6.0 Management tools in Server Manager.

Cheers,
- Hades666

Brad Howe

Sorry for GMAIL, yuo can only authenticate as one person.
See this link on how to configure it. - http://www.codingbliss.com/cb/?p=38
Cheers,
Hades666