November 5, 2008 at 8:44 am
The following code is to configure the Database account:
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'MyMailAccount',
@description = 'Mail account for Database Mail',
@email_address = 'makclaire@optonline.net',
@display_name = 'MyAccount',
@username='makclaire@optonline.net',
@password='abc123',
@mailserver_name = 'mail.optonline.net'
on my server, how do I know what the emailaddress and the password are.
Does it matter if the server name is not a web address?
Thanks
faye
November 13, 2008 at 7:09 am
From Books online:
[ @username = ] 'username'
The username to use to log on to the e-mail server. username is nvarchar(128), with a default of NULL.
[ @password = ] 'password'
The password to use to log on to the e-mail server. password is nvarchar(128), with a default of NULL.
So you should know the username you want to be used in the profile and the password. If you don't know ask your mailserver administrator. In case your mailserver does not require authentification you can leave both values NULL, but most mailservers require authentification.
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply