Solved

Hosting Company that supports Database Mail for SQL Server 2008

Posted on 2010-11-17
5
394 Views
Last Modified: 2012-05-10
I am currently with Discountasp.net and they provide SQL Server as an add on. But when sending a question to Tech Support, I was informed that they don't offer Database Mail for SQL Server and that you can only send mail using a web application.  If this is the case then I wouldn't be able to provide an email notification system using SQL Server with this company.  Can anyone recommend a Hosting Company that allows Configuration of Database Mail? Or is there another possible way to implement a email notification system on the .Net platform.  Thanks for any help in advance!!
0
Comment
Question by:encoredatas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 41

Expert Comment

by:graye
ID: 34157252
I think you're stuck.... By reading between the lines, I hear them saying that they block outgoing port 25 on their hosting server.   If so, that means you won't be able to send SMTP email from *any* application.

I guess you could write a simple web-interface application that hooks up to their web email, and performs all of the steps to get you logged in, create an email, and send it... kinda like scripting the web page.
0
 
LVL 16

Expert Comment

by:MikeMCSD
ID: 34157566
Careful with  Discountasp.net:
If you send more than 1000 emails a day, they will shut your site down
for a day or 2 as "the warning" you violated the rules.

If you need mass email sending, you'll have to use one of those companies
that charge a fortune for it.

If you need code to send emails using asp.net, let me know.
I have code that I have used with  Discountasp.net for sending emails.



0
 
LVL 10

Expert Comment

by:itcouple
ID: 34163744
Hi Mike,

I have discountasp.net as well and just want to ask if your code can be scheduled? Without user having to click anything on the page??

Unfortunatelly SQL Express edition (which discountaso.net uses) has schedule restrictions.

Regards
Emil
0
 

Author Comment

by:encoredatas
ID: 34164903
I have code using asp.net but if it can be scheduled some how that would be useful.
0
 
LVL 10

Accepted Solution

by:
itcouple earned 500 total points
ID: 34171014
Hi

In the past I used CDO with VBscript / Windows scheduler but with discount asp.net you can't do that so I looked this on internet and it seems there is SP which uses CDO http://support.microsoft.com/kb/312839 but it seems it requires some settings on the server itself.

I cannot find one which allows you to specify SMTP etc.

I've also tried to find anything about executing asp.net page from SQL Server but couldn't find anything which isn't suprise as security in both cases is top priority.

Regarding scheduling sql server express doesn't have sql agent.... but in the past i have come across something that managed to do that using a stored procedure.

So it seems for the price you pay you will not get that.....

Hope that clarifies your question a little bit
Emil
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question