Manually adding a mail account to SQL2005/2008
I was having trouble adding configuring Database Mail on a SQL2005 server today.
I followed the wizard just like I had done on the previous 6 servers, but this one just didn’t want to add it. It was giving me an error about not being able to insert a NULL into the server name field, although I was giving it a server name.
I tried manually adding the data into the table, but of course that didn’t work. You have to use a stored procedure.
You need to use msdb.dbo.sysmail_add_account_sp with options like below,
msdb.dbo.sysmail_add_account_sp @account_name=’company.com mail server’,@email_address=’firstname.lastname@example.org’,@display_name=’John Doe’,@replyto_address=’email@example.com’,@mailserver_name=’mail.company.com’,@port=25;