Scenario:
DBMS: SQL Server 2000
OS: Windows Server 2003
Goal:
Enable SQLMAIL via Internet Mail
Problem:
How do I set up the MAPI profile for the SQL Server service account?
On Windows 2000 Server, I can use "Control Panel"/"Mail" to
create a MAPI profile for the SQL Server service account, and then
reference that profile for SQLMAIL in SQL Server and SQL Server Agent.
But on Windows Server 2003, there is no "Mail" applet in "Control Panel".
How do I create a MAPI profile, for the SQL Server service account,
on Windows Server 2003? 5 26697
You need to install a MAPI client like Outlook to get that icon and be
able to configure a mail profile.
Good luck,
Tony Sebion
"Larry Bertolini" <be*********@osu.edu> wrote in message
news:dg**********@charm.magnus.acs.ohio-state.edu: Scenario: DBMS: SQL Server 2000 OS: Windows Server 2003
Goal: Enable SQLMAIL via Internet Mail
Problem: How do I set up the MAPI profile for the SQL Server service account?
On Windows 2000 Server, I can use "Control Panel"/"Mail" to create a MAPI profile for the SQL Server service account, and then reference that profile for SQLMAIL in SQL Server and SQL Server Agent.
But on Windows Server 2003, there is no "Mail" applet in "Control Panel".
How do I create a MAPI profile, for the SQL Server service account, on Windows Server 2003?
Larry Bertolini wrote: Scenario: DBMS: SQL Server 2000 OS: Windows Server 2003
Goal: Enable SQLMAIL via Internet Mail
Problem: How do I set up the MAPI profile for the SQL Server service account?
On Windows 2000 Server, I can use "Control Panel"/"Mail" to create a MAPI profile for the SQL Server service account, and then reference that profile for SQLMAIL in SQL Server and SQL Server Agent.
But on Windows Server 2003, there is no "Mail" applet in "Control Panel".
How do I create a MAPI profile, for the SQL Server service account, on Windows Server 2003?
You need to install a MAPI client, like Outlook. http://support.microsoft.com/kb/263556/
See the Additional Information section of that article for other useful
links.
If you don't want to install a MAPI client (or if your organization's
build standards don't allow it), then this is a popular alternative: http://www.sqldev.net/xp/xpsmtp.htm
Simon
Ok, a dump question... This approach requires a seperate application
that provides the SMTP server or is that part of SQL Server 2000?
You need a separate SMTP server to handle the emails - MSSQL itself
doesn't do that; most email servers support SMTP, so you may be able to
use your organization's existing server. Many companies find it useful
to have SMTP available for applications (including MSSQL) to use, since
it's a well-established standard and there are plenty of client
libraries available.
Simon
Note that SQLMail and SQLAgentMail are two seperate (but similar)
processes. SQLMail can be replaced using xp_smtp_sendmail as described
by Simon below; however, there is no current replacement for the
SQLAgentMail functionaility. You'll have to use a MAPI client like
Outlook to build a mail profile.
Thankfully, this changes in SQL 2005.
Stu This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Adam Kinney |
last post by:
I have an ASP application that logs into Exchange server to send email. The
code looks like this:
Set objSession = CreateObject("MAPI.Session")
objSession.Logon "profileName"
strMsg = ".."...
|
by: Suganthi |
last post by:
Hi,
I have a specific problem while using MAPI for sending the emails from
my application.
My requirement is as follows.
My application will be running either as a service or a process in a...
|
by: Kurt |
last post by:
Hi
I am using CDO 1.21 from C# in order to iterate through the entries in a users outlook address book (as OOM was too slow). Basically I take the Name field from each "message" and insert it into...
|
by: Eric |
last post by:
When I use system.web.mail namespace in most of my integration programs
and in windows application programs it doesn't work.
it normally gives an exception "Could not access 'CDO.Message' object."...
|
by: Dennis |
last post by:
I am using the following code that I got from this newsgroup to start a
user's default e-mail editor and it works ok. However, I would like to
attach a file to the editor (like using word as...
|
by: mchi55 |
last post by:
I just read that if you use an exchange server...the account that you
start SQL with needs a mail on the exchange box.
Is this true?
I know I didn't need an account when I've set it up...
|
by: luc.saffre |
last post by:
Hello,
the simplest way to launch the user's standard mail client from a
Python program is by creating a mailto: URL and launching the
webbrowser:
def...
|
by: mrian84 |
last post by:
I am trying to use Outlook Redemption 4.5 from a window service running as LocalSystem but I seem to have problems
can anybody enlighten me on what to do?
-I did try creating some profiles...
|
by: awrightus |
last post by:
I want to develop an interface to create, edit, and delete Outlook
profiles. The system I want to do this on will Have Outlook 2003 on
it. I can use much of the Office Interop stuff to...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |