You will need to contact Ava for an SMS account which is provided by a third party. You will usually be given a number of free texts to start your account and text the service.
Because any email system needs to protect its self from being used illegally to send spam, setting this up is a task only for the technically minded.
In secure environments you may only be able to send emails from specific machines.
The most secure systems will only allow emails to be sent via specific accounts from specific machines. AvaPA addresses this by using a secure authenticated connection to send the contents of emails to the AvaPA database server, where they are then converted to emails acceptable to Email routing software such as MS Exchange server.
The mail server supplied by Microsoft with SQL2000 is acknowledged as less than reliable. AvaPA uses xp_mail an acknowledged reliable mechanism.
Install xp_mail on the database server
Download xp_mail and documentation
Enable exchange to SMTP relay from the Database server for the email account
Use the test script with it stored procedure to check that you can successfully send an email from the server, and then any client machine
The code (if required) is at the bottom of this article
With supervisor privileges:
For each database
Select Setup from the main menu
Select email
On the General Email routing tab
Select To database server and send option
On the “Email this PC” tab
Enter the server name in the POP3 box (It may be the name or IP)
Enter the server name in the SMTP box (It may be the name or IP)
Enter an (email) account name for your domain that has been set up on your email sever
Enter an (email) password for the account
Enter a from email address
Enter a from Name
Save
Ping the email server to check the name is correct
Send a test SMS message to your own mobile number
For each current user, on the email user, give them either their own email address and name or a generic one
Save
Once this is done, repeat on each pc for each database
On the General Email routing tab
Select To database server and send option
On the “Email this PC” tab
Select the server name in the POP3 box (It may be the name or IP) – this will then populate the rest of the information
< code>
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ap_SendEmailViaServer]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ap_SendEmailViaServer]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create procedure [dbo].ap_SendEmailViaServer
@ParamFromAddress varchar(128)
, @ParamFromName varchar(128)
, @ParamTo varchar(128)
, @ParamSubject varchar(128)
, @ParamMessage varchar(2000)
, @ParamServer varchar(128)
AS
declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = @ParamFromAddress
, @FROM_NAME = @ParamFromName
, @TO = @ParamTo
, @priority = N'HIGH'
, @subject = @ParamSubject
, @message = @ParamMessage
, @type = N'text/plain'
, @server = @ParamServer
select RC = @rc
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
/*
exec dbo.ap_SendEmailViaServer
'Clinical bank test',
'ava@icetrak.com',
'test sms proc from me',
'07??????????',
'ExchangeServerName'
*/
< code>