SQL Mail Not Working in SQL 2005

Question

SQL Mail Not Working in SQL 2005

cbarnes-607341

SSC Rookie

Points: 26
More actions
January 18, 2008 at 1:35 pm

#182205

I've looked everywhere but still can’t solve this issue. For legacy application reasons, we still need to use SQL Mail and have a new SQL 2005 install. We set up an Exchange account and an Outlook profile for the user that the SQL Server services run as (domain user) but are still getting the error below when right-clicking on the ‘Properties’ of SQL Mail in the SQL Management Studio:
TITLE: Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION:
If a stored procedure could not be found, SQL Mail may not be installed in the instance. (SqlManagerUI)
xp_get_mapi_profiles: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. (Microsoft SQL Server, Error: 17930)
SQL Mail is installed per the Surface Area Configuration. Outlook is our default mail client--I checked Internet Explorer. We stopped and restarted SQL Server Agent and we even rebooted the server. Does SQL Mail really work with SQL Server 2005?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Adam Angelini SSCrazy Eights Points: 8548 More actions · Answer 1

we use SQLMail for some of our legacy stuff. there are a couple of test instances that we never could get it working on. It can be done though, wish I had more info for you on your error.

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

You can try DATABASE MAIL instead of SQL Mail in SQL Server 2005. I guess DATABASE MAIL is more reliable than SQL Mail.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

philcart SSC-Forever Points: 47795 More actions · Answer 3

The usual culprit in this sort of scenario is that you haven't created the Outlook profile using the same credentials that the SQL Server services are using.

Try logging in to the console as the same user and then create a profile.

--------------------
Colt 45 - the original point and click interface

cbarnes-607341 SSC Rookie Points: 26 More actions · Answer 4

I figuired it out. We found this post:

How to: Configure Mail Profiles for Use by SQL Mail (Windows)

This topic describes how to configure a mail profile for SQL Mail. Before you can use SQL Mail, you must also enable SQL Mail using the Surface Area Configuration tool.

Note:

SQL Mail will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use the feature.

To configure mail profiles to use to use for SQL Mail

1.On the Microsoft Exchange server, set up a mailbox for the user that SQL Server runs as. This account must be a domain account.

2.Install an Exchange client on the computer that runs SQL Server. For Microsoft SQL Server 2005, supported Microsoft Exchange clients are Microsoft Outlook XP and Outlook 2003.

3.Log on to the computer that runs SQL Server. Use the name and password used to start SQL Server.

We had Outlook 2000 installed. We installed Outlook 2003, removed and re-created our Mail Profile (excluding spaces this time), restarted SQL Server and SQL Agent services and it worked! It didn't work until we created the new profile and restarted the services though.

Scott Arendt SSCrazy Eights Points: 8218 More actions · Answer 5

That was exactly the answer that I needed this past weekend.

I ended up solving it by switching everything to Database Mail.

martin.graves Old Hand Points: 361 More actions · Answer 6

thanks for info.

FYI. By my research, Database mail does not support reading from Inbox, and/or deleting mail. I have read on MS Forum site that thru SQL 2008 this will be true, and that SQL Mail (as it is found in SQL 2005) will be in SQL 2008 as well.