MS SQL Server - SQL Mail & Outlook 2000!

Author

SQL Mail & Outlook 2000!

Arpan

2005-06-29, 8:23 pm

I have recently installed MS-Outloook 2000 in my Win 2000 Professional
system. I want Outlook to be the default mail client so that I can send
mails from SQL Server 7 but when I start Outlook for the 1st time after
installing it, I am facing problems.

As soon as I start Outlook, the 1st step gives 2 options to select from
-Microsoft Exchange Server & Internet Email.Since I want to use Outlook
solely for sending mails from SQL Server, I select the former. The next
step prompts me to enter the MS-Exchange Server & the Mailbox. This is
where I am getting stuck. What do I enter as the MS-Exchange Server &
the Mailbox? How or where from do I get these 2 bits of information?

If I select Internet E-mail instead of Microsoft Exchange Server at the
first step, the next step requires me to enter the POP3 & SMTP servers
apart from other details. Now Outlook Express 6 in my m/c is configured
to my Hotmail account but the same can't be done in Outlook coz Hotmail
uses HTTP, not POP3 & Outlook doesn't support the HTTP protocol.

How do I configure Outlook 2K so that I can use it to send emails from
SQL Server 7?

Thanks,

Arpan

Mike Epprecht \(SQL MVP\)

2005-06-30, 3:23 am

Hi

You need an Exchange Server, or if you want to use SMTP, someone has to
always be logged into the SQL Server machine so that outlook can process
mails. Even then you need a full SMTP mail server.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Arpan" <arpan_de@hotmail.com> wrote in message
news:1120094805.025301.256720@g43g2000cwa.googlegroups.com...
>I have recently installed MS-Outloook 2000 in my Win 2000 Professional
> system. I want Outlook to be the default mail client so that I can send
> mails from SQL Server 7 but when I start Outlook for the 1st time after
> installing it, I am facing problems.
>
> As soon as I start Outlook, the 1st step gives 2 options to select from
> -Microsoft Exchange Server & Internet Email.Since I want to use Outlook
> solely for sending mails from SQL Server, I select the former. The next
> step prompts me to enter the MS-Exchange Server & the Mailbox. This is
> where I am getting stuck. What do I enter as the MS-Exchange Server &
> the Mailbox? How or where from do I get these 2 bits of information?
>
> If I select Internet E-mail instead of Microsoft Exchange Server at the
> first step, the next step requires me to enter the POP3 & SMTP servers
> apart from other details. Now Outlook Express 6 in my m/c is configured
> to my Hotmail account but the same can't be done in Outlook coz Hotmail
> uses HTTP, not POP3 & Outlook doesn't support the HTTP protocol.
>
> How do I configure Outlook 2K so that I can use it to send emails from
> SQL Server 7?
>
> Thanks,
>
> Arpan
>

Yogish

2005-06-30, 3:23 am

Hi,

Your system admin or exchange admin should have this information. You need
to create an SQL mail profile by using either exhange server or smtp/pop3
address.
And after you restart your server, SQL server will be able to recognize this
mail profile (sql agent), which can be used to send and receive mails.

--
- - - - - - - - -
Thanks
Yogish

"Arpan" wrote:

> I have recently installed MS-Outloook 2000 in my Win 2000 Professional
> system. I want Outlook to be the default mail client so that I can send
> mails from SQL Server 7 but when I start Outlook for the 1st time after
> installing it, I am facing problems.
>
> As soon as I start Outlook, the 1st step gives 2 options to select from
> -Microsoft Exchange Server & Internet Email.Since I want to use Outlook
> solely for sending mails from SQL Server, I select the former. The next
> step prompts me to enter the MS-Exchange Server & the Mailbox. This is
> where I am getting stuck. What do I enter as the MS-Exchange Server &
> the Mailbox? How or where from do I get these 2 bits of information?
>
> If I select Internet E-mail instead of Microsoft Exchange Server at the
> first step, the next step requires me to enter the POP3 & SMTP servers
> apart from other details. Now Outlook Express 6 in my m/c is configured
> to my Hotmail account but the same can't be done in Outlook coz Hotmail
> uses HTTP, not POP3 & Outlook doesn't support the HTTP protocol.
>
> How do I configure Outlook 2K so that I can use it to send emails from
> SQL Server 7?
>
> Thanks,
>
> Arpan
>
>

Arpan

2005-06-30, 3:23 am

Thanks, Mike, for your input. I have done my best to set up SQL Mail
with Exchange Server but have failed. I came across this article on how
to setup SQL Mail with Exchange at
http://support.microsoft.com/defaul...122120121120120
but couldn't follow most of the steps required to setup SQL Mail with
Exchange Server under the sub-topic "How to setup SQL Mail with
Exchange".

First of all, please tell me whether Outlook 2000 can be used as an
Exchange Server? I guess yes, it can be but I can't figure out how to
create a mail profile.in Outlook. The examples 'Account:
DOMAIN1\SQLServerAcc
ount' & 'Mailbox: SQL1' cited in the KB article -
on what basis are the examples of Account & Mailbox given?

I logon to my Win2K Pro system using 'Administrator' as the login name
& use 'SQL Server & Windows NT' authentication. I run SQL Server using
this 'Administrator' account. When I start Outlook, I set the MS
Exchange Server as well as the Mailbox to 'Administrator' but when I
click the 'Check Name' button, I get the following error:

The name could not be resolved. Network problems are preventing
connection for the Microsoft Exchange Server computer. Contact your
system administrator if the condition persists.

Now how do I resolve the name? Please help me out to resolve this
problem. It's driving me crazy!!

Thanks once again,

Regards,

Arpan

Tibor Karaszi

2005-06-30, 3:23 am

Outlook is a mail client. Not a mail server. Exchange is a separate product (just like SQL server
is). Consider using xp_smtp_sendmail from www.sqldev.net.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"Arpan" <arpan_de@hotmail.com> wrote in message
news:1120108571.986315.232610@g43g2000cwa.googlegroups.com...
> Thanks, Mike, for your input. I have done my best to set up SQL Mail
> with Exchange Server but have failed. I came across this article on how
> to setup SQL Mail with Exchange at
> http://support.microsoft.com/defaul...122120121120120
> but couldn't follow most of the steps required to setup SQL Mail with
> Exchange Server under the sub-topic "How to setup SQL Mail with
> Exchange".
>
> First of all, please tell me whether Outlook 2000 can be used as an
> Exchange Server? I guess yes, it can be but I can't figure out how to
> create a mail profile.in Outlook. The examples 'Account:
> DOMAIN1\SQLServerAcc
ount' & 'Mailbox: SQL1' cited in the KB article -
> on what basis are the examples of Account & Mailbox given?
>
> I logon to my Win2K Pro system using 'Administrator' as the login name
> & use 'SQL Server & Windows NT' authentication. I run SQL Server using
> this 'Administrator' account. When I start Outlook, I set the MS
> Exchange Server as well as the Mailbox to 'Administrator' but when I
> click the 'Check Name' button, I get the following error:
>
> The name could not be resolved. Network problems are preventing
> connection for the Microsoft Exchange Server computer. Contact your
> system administrator if the condition persists.
>
> Now how do I resolve the name? Please help me out to resolve this
> problem. It's driving me crazy!!
>
> Thanks once again,
>
> Regards,
>
> Arpan
>

John Bell

2005-06-30, 7:23 am

Hi

You may want to look at:

http://msdn.microsoft.com/library/d...rverE-mail.asp.

You will need to know what account your SQL Server service is running as,
and then log into the server as that account to create the MAPI profile. It
is not a good idea to run the SQL Server service under Administrator as this
account may change (password etc) and has higher privileges than is necessary.

HTH

John

"Arpan" wrote:

> Thanks, Mike, for your input. I have done my best to set up SQL Mail
> with Exchange Server but have failed. I came across this article on how
> to setup SQL Mail with Exchange at
> http://support.microsoft.com/defaul...122120121120120
> but couldn't follow most of the steps required to setup SQL Mail with
> Exchange Server under the sub-topic "How to setup SQL Mail with
> Exchange".
>
> First of all, please tell me whether Outlook 2000 can be used as an
> Exchange Server? I guess yes, it can be but I can't figure out how to
> create a mail profile.in Outlook. The examples 'Account:
> DOMAIN1\SQLServerAcc
ount' & 'Mailbox: SQL1' cited in the KB article -
> on what basis are the examples of Account & Mailbox given?
>
> I logon to my Win2K Pro system using 'Administrator' as the login name
> & use 'SQL Server & Windows NT' authentication. I run SQL Server using
> this 'Administrator' account. When I start Outlook, I set the MS
> Exchange Server as well as the Mailbox to 'Administrator' but when I
> click the 'Check Name' button, I get the following error:
>
> The name could not be resolved. Network problems are preventing
> connection for the Microsoft Exchange Server computer. Contact your
> system administrator if the condition persists.
>
> Now how do I resolve the name? Please help me out to resolve this
> problem. It's driving me crazy!!
>
> Thanks once again,
>
> Regards,
>
> Arpan
>
>

Sponsored Links