Send SMS using SQL Server 2008

B

BlackWasp

Senior Member
Joined
Mar 28, 2006
Messages
654
Reaction score
0
Location
Pretoria
Hi guys,

Apologies if wrong thread.

We are currently receiving alert from SQL Server 2008 via email if jobs fail etc.

I need to change these email messages to SMS for mobile phones on main networks (MTN/Vodacom).

What is the easiest to achieve this? I found a lot of Email to SMS gateway sites online, where you still use the SMTP inside the SQL code, sending to a cellno: 0831112222@<specificaddress>.co.za. This seems the easiest route, but I have no idea which service to choose, or is there another native way?

Please help.
 
In my experience, grapevine is great for this.

2way is similar, and offers bundles ( prepaid )

Both of them offer email to SMS conversion, you just need to authenticate by way of a "password" in the email subject or something.
 
Used the email to sms route couple years back. Vodacom bundles of some sort but mweb were the client's ISP. Basically structured the email to contain the recipients cell number and message. The rest happened on vodacom's side I think. Bundles weren't cheap as I got quite a bit of flack from the client for my err... bulk testing.
 
MartyMarts said:
Used the email to sms route couple years back. Vodacom bundles of some sort but mweb were the client's ISP. Basically structured the email to contain the recipients cell number and message. The rest happened on vodacom's side I think. Bundles weren't cheap as I got quite a bit of flack from the client for my err... bulk testing.
Click to expand...

Thanks, I was really hoping in this day and age there would be a better way to send a simple SMS.
 
BlackWasp said:
Thanks, I was really hoping in this day and age there would be a better way to send a simple SMS.
Click to expand...

Yeah that was a couple years back. Worked great but needed third parties to make it happen. As other's have posted, there's more options available now...

Btw, what did you end up doing?
 
MartyMarts said:
Yeah that was a couple years back. Worked great but needed third parties to make it happen. As other's have posted, there's more options available now...

Btw, what did you end up doing?
Click to expand...

Client ended up cancelling SMS development and stuck to email. You know how it goes.
 
gkm said:
You can directly send SMS's using a 3G modem, but I also think the mail gateways are by far the easiest, especially since you are already sending mail.

Another option if your recipients have smart phones is to use push notifications, for example by using http://aws.amazon.com/sns/ or http://azure.microsoft.com/en-us/documentation/services/notification-hubs/

However, in your case I really think the mail gateway is the way to go. Other solutions will be overkill.
Click to expand...

But what is the reliability of a modem sitting on a server in a data centre ? I rate the signal would be really bad!
 
froot said:
Mweb didn't stop us from taking in anything when we went there.
Click to expand...

Seriously?

I would not host any critical stuff in MWeb's DC then.

Shared DC's with corporate clients should have ridiculous levels of security in my opinion. Nothing in, nothing out.
 
Nerfherder said:
But what is the reliability of a modem sitting on a server in a data centre ? I rate the signal would be really bad!
Click to expand...

The OP did not indicate that their server was in a shared DC. Not that I really recommended it. Just mentioned it because the OP was looking for other options. I agree in a shared DC it is a not-starter.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X