Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2008 express DB Mail


SQL 2008 express DB Mail

Author
Message
pakwichek
pakwichek
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 174
I have SQL 2008 Express installed and running under windows 2008, with smtp service running as well.

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2012-09-09T09:27:59). Exception Message: Cannot send mails to mail server. (Service not available, closing transmission channel. The server response was: Downstream server error). )

Any help with this will be appreciated

Thanks
Peter


pa
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9452 Visits: 9517
The error message seems pretty clear. There's a problem with the SMTP service or connecting to it. You should talk to whoever supports your SMTP server.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
pakwichek
pakwichek
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 174
Hello RBarryYoung,

Thanks for your quick reply. I will like to add that, I have purchased the Virtual Private Server (VPS) from ToggleBox.com and using it to run my SQL express edition under windows 2008. I own the VPS and can carry any administration of the Server as I wish. Unfortunately I am not Windows Server admin or knowledgeable enough to install and configure SMTP service. My VPS provider will not provide me such administrative service either.
Can you possibly help me with this? I can give you access to this server desktop for this reason. I really appreciate any help from anyone family with this challenge.

Thanks
Peter


pa
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9452 Visits: 9517
pakwichek (9/9/2012)
Hello RBarryYoung,

Thanks for your quick reply. I will like to add that, I have purchased the Virtual Private Server (VPS) from ToggleBox.com and using it to run my SQL express edition under windows 2008. I own the VPS and can carry any administration of the Server as I wish. Unfortunately I am not Windows Server admin or knowledgeable enough to install and configure SMTP service. My VPS provider will not provide me such administrative service either.
Can you possibly help me with this? I can give you access to this server desktop for this reason. I really appreciate any help from anyone family with this challenge.


Um, no.

Reasons:

1. Accessing your server would be "doing it for you", not "helping you with this". I am a professional consultant and I charge my customers a lot of money to do this kind of thing for them,

2. I am not qualified to setup, configure, or troubleshoot SMTP anyway, and

3. Asking a stranger you met over the Internet, but have no other relationship with, to connect to your desktop or server to perform admin tasks is a really, really bad idea. Both for you (because of the potential damage that could be done, whether intentional or accidental), and for me also (because as a professional, anything that went wrong would automatically be my responsibility).

Instead, I would encourage to follow the path you were already on, just find a site or forum or other resource that can tell you how to setup your SMTP and follow their directions.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
pakwichek
pakwichek
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 174
Thanks for the advise and I will do just that


pa
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search