«

Hi-

I have been trying to configure SQL Server 2000 to send
Alerts to Mail Box. The following I have used.

1. Windows 2000 SP2
2. MS Exchange 2000 Evaluation copy
3. MS Outlook 2000 Evaluation copy.

Server1-
Only Windows 2000 with AD- Nwtraders.msft configured

Server2-
Member Server of Nwtraders.msft. The steps followed to
configure Server 2 are:-
a) Run MSExchange Setup/Forestprep
b) Run MSExchange Setup/Domainprep
c) Run MSExchanmge Setup and install MS Exchange 2000
d) Install MS SQL Server 2000
e) Install MS Outlook
f) Configure Outlook and check the email deliveries
between 2 Accounts. Works perfectly.
g) Run Enterprise Manager of SQL Server/ Management /
Right Click Properties
And in the General Tab we need to provide the mail session
configuration(mail profile) - Which according to SQL Server
Training Kit is "MS Exchange Settings"- But for some
reason I don't get this settings even thought my Exhange
Server is working fine and I can send email etc.


I have tried 2 different Server but for some reason the MS
SQL is not able to see the Mail Profile Settigs which are
configured in Outlook.


Help please.


Aibak

IIRC, you need to have SQL server service running under
the domain account that the mailbox is associated with.

>-----Original Message-----
>Hi-
>
>I have been trying to configure SQL Server 2000 to send
>Alerts to Mail Box. The following I have used.
>
>1. Windows 2000 SP2
>2. MS Exchange 2000 Evaluation copy
>3. MS Outlook 2000 Evaluation copy.
>
>Server1-
>Only Windows 2000 with AD- Nwtraders.msft configured
>
>Server2-
>Member Server of Nwtraders.msft. The steps followed to
>configure Server 2 are:-
>a) Run MSExchange Setup/Forestprep
>b) Run MSExchange Setup/Domainprep
>c) Run MSExchanmge Setup and install MS Exchange 2000
>d) Install MS SQL Server 2000
>e) Install MS Outlook
>f) Configure Outlook and check the email deliveries
>between 2 Accounts. Works perfectly.
>g) Run Enterprise Manager of SQL Server/ Management /
>Right Click Properties
>And in the General Tab we need to provide the mail
session
>configuration(mail profile) - Which according to SQL
Server
>Training Kit is "MS Exchange Settings"- But for some
>reason I don't get this settings even thought my Exhange
>Server is working fine and I can send email etc.
>
>
>I have tried 2 different Server but for some reason the
MS
>SQL is not able to see the Mail Profile Settigs which
are
>configured in Outlook.
>
>
>Help please.
>
>
>Aibak
>.
>

<> wrote in news:1885201c41af7
$85af02a0$:

> IIRC, you need to have SQL server service running under
> the domain account that the mailbox is associated with.
>

you also need to log on as the service account used to start SQL agent
and fire up outlook on the SQL server box. this will create the profile
that you will use in the properties in SEM. (the default name is MS
Exchange settings but you can call this anything you want) If you are
using a local system account for the SQL Agent, no mail.


--
Neil
"you'd do what, to who, for how many biscuits?"

Thanks-

But the thing I was missing was that in MS SQL Server
Properties - You need to go and enable "Active Directory
Integerated"
After that things worked smoothly.

>-----Original Message-----
><> wrote in
news:1885201c41af7
>$85af02a0$:
>
>> IIRC, you need to have SQL server service running under
>> the domain account that the mailbox is associated with.
>>
>
>you also need to log on as the service account used to
start SQL agent
>and fire up outlook on the SQL server box. this will
create the profile
>that you will use in the properties in SEM. (the default
name is MS
>Exchange settings but you can call this anything you
want) If you are
>using a local system account for the SQL Agent, no mail.
>
>
>--
>Neil
>"you'd do what, to who, for how many biscuits?"
>.
>