Configuring SQLMail on Standalone PC

Hi,
I want to try some programs using SQL Mail on my Local/Standalone PC.
I do not have a network connection and only have a dialup connection.
How do I setup/configure SQLMail in SQL2000? When I read about it, it
says that I need to have mailbox/profile setup. But I don't have
Exchange Server too.
Somehow I got hold of Exchange Server 2000 120-Eval edition. But I am
unable to install the same, because it says that it needs Active
Directory to be setup first.
Now my Win2K Server is already installed and I don't have Active
Directory setup. Is it possible to setup Active Directory on a
Local/Standalone PC which doesn't have Network card.
Please let me know if there is any possible way to write and test some
programs on a Standalone Win2K Server with is not connected to any
server. What will be the prerequisites of Standalone PC to use
SQLMail locally for testing purpose.
Thanks,
KamleshCan you use SMTP instead? http://www.aspfaq.com/2403
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Kamlesh" <kamlesh2000@.yahoo.com> wrote in message
news:2644c0f6.0311212150.7bba5122@.posting.google.com...
> Hi,
> I want to try some programs using SQL Mail on my Local/Standalone PC.
> I do not have a network connection and only have a dialup connection.
> How do I setup/configure SQLMail in SQL2000? When I read about it, it
> says that I need to have mailbox/profile setup. But I don't have
> Exchange Server too.
> Somehow I got hold of Exchange Server 2000 120-Eval edition. But I am
> unable to install the same, because it says that it needs Active
> Directory to be setup first.
> Now my Win2K Server is already installed and I don't have Active
> Directory setup. Is it possible to setup Active Directory on a
> Local/Standalone PC which doesn't have Network card.
> Please let me know if there is any possible way to write and test some
> programs on a Standalone Win2K Server with is not connected to any
> server. What will be the prerequisites of Standalone PC to use
> SQLMail locally for testing purpose.
> Thanks,
> Kamlesh

Configuring SQLMAIL

Hi
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
OS : windows xp with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuring
Hi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:

> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>
|||Hi,
I think information on this link will help, especially on the step by step:
http://msdn.microsoft.com/library/de...rverE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>

Configuring SQLMAIL

Hi
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
---
OS : Windows XP with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuringHi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:

> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : Windows XP with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>|||Hi,
I think information on this link will help, especially on the step by step:
ServerE-mail.asp" target="_blank">http://msdn.microsoft.com/library/d...erverE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : Windows XP with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>

Configuring SQLMAIL

Hi
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
---
OS : windows xp with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuringHi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>|||Hi,
I think information on this link will help, especially on the step by step:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba01/html/SQLServerE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>