question

shusta avatar image
shusta asked

SQL 2016 SMS issue

New SQL 2016 server has no issues sending email on my domain but none of the test emails to a cell phone reach me. I have confirmed SMS email settings 1234567@vtext.com and this is working on a SQL 2008 server currently so I don't think this is a network issue. Wondering what I'm missing or what changed since I documented this during 2008 setup.

sql2016
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image
anthony.green answered

database mail setup and tested to an internal email address?

exchange connectors put in place for connect and relay

what is the state of the items sent already (select * from msdb.dbo.sysmail_allitems)

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

shusta avatar image
shusta answered

Anything in particular you would like to know from this? Under sent_status the ressult for all is sent.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·

Well then database mail is working, I would speak to your email techs and see why they where not sent outside the boundary.

SQL has sent them on so everything working SQL side, so nothing any SQL person can help you with, you need to speak with your sysadmins and figure out whats going on.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.