SQL Server 2005 SP2 64bit Database Mail Setup Problems.

• Peacob00

  SSC Veteran

  Points: 205

  More actions

  July 17, 2009 at 5:08 am

  #136359

  Hi,

  I'm having a problem setting up the database mail on an SQL Server 2005 SP2 64bit Standard Edition.

  I have turned on the Database Mail feature in the surface area configuration manager.

  When on the last page of the wizard and it's trying to apply my settings, 2 errors are displayed:

  1. Unable to create a new account, cannot insert the value NULL into column 'servername'. table 'msdb.dbo.sysmail_server'

  2. Add Mail Account to MailProfile failed.

  Any help would be greatly appreciated.

  Thanks.

• sql_lock

  SSCrazy Eights

  Points: 9373

  More actions

  July 17, 2009 at 9:07 am

  #1026240

  What does SELECT @@SERVERNAME return?

  You could also try added it manually (from BOL)

  EXECUTE msdb.dbo.sysmail_add_account_sp

  @account_name = 'AdventureWorks Administrator',

  @description = 'Mail account for administrative e-mail.',

  @email_address = 'dba@Adventure-Works.com',

  @display_name = 'AdventureWorks Automated Mailer',

  @mailserver_name = 'smtp.Adventure-Works.com' ;

• LeeM

  Right there with Babe

  Points: 733

  More actions

  July 17, 2009 at 9:11 am

  #1026244

  When you setup the Mail Account you did not specify a server name in the Outgoing mail server section.

• Peacob00

  SSC Veteran

  Points: 205

  More actions

  July 17, 2009 at 11:00 am

  #1026330

  Hi,

  thanks for the reply.

  Running the command (SELECT @@SERVERNAME) returns NULL

  I have run a modified version of the command:

  EXECUTE msdb.dbo.sysmail_add_account_sp

  @account_name = 'AdventureWorks Administrator',

  @description = 'Mail account for administrative e-mail.',

  @email_address = 'dba@Adventure-Works.com',

  @display_name = 'AdventureWorks Automated Mailer',

  @mailserver_name = 'smtp.Adventure-Works.com' ;

  And the command completed ok, but when I run the command(SELECT @@SERVERNAME) I still get NULL.

  When I try and configure the mail accounts through the wizard the account is not there.

  Is it something to do with me running 64bit as I have successfully configured database mail on a 32bit SQL Server 2005 SP3 Standard edition.

  We are looking at trying to implement the legacy SQL Mail too see if we can get that to work..

  Any other advice would be greatly appreciated, otherwise thanks for the advice you have given...

  Regards.

• matt stockham

  SSCrazy Eights

  Points: 9942

  More actions

  July 17, 2009 at 3:31 pm

  #1026466

  Look at http://msdn.microsoft.com/en-us/library/ms174411(SQL.90).aspx and set the server name. That may resolve your problem.