Sunday, 12 February 2012

Configuring Database Mail in Sept 05 version

I had no problems whatsoever configuring Database Mail in the April CTP.

In the September version, when I try to configure mail on a new (not an upgraded) server, I run into the following:

-- Set up Database Mail
-- trying to add profile, click on ADD to add an account, I get a:

Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. > System.Data.SqlClient.SqlException: Insert Error: Column name or number of supplied values does not match table definition.

I profiled it, and the setup tries to execute a script:
create table #tmp_sysmail_help_account(account_id int, name nvarchar(128), description nvarchar(256) null, email_address nvarchar(128) null, display_name nvarchar(128) null, replyto_address nvarchar(128) null, servertype nvarchar(128), servername nvarchar(128), port int, username nvarchar(128))

insert into #tmp_sysmail_help_account(account_id, name, description, email_address, display_name, replyto_address, servertype, servername, port, username) exec msdb.dbo.sysmail_help_account_sp

Which does not work since msdb.dbo.sysmail_help_account_sp returns 2 fields that are not accounted for in the temp table: user_default_credentials, and enable_ssl.

I altered the procedure to work, which gets me to the 'add account', but adding an will fail with:

TITLE: Microsoft SQL Server

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1187.07&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476


ADDITIONAL INFORMATION:

Object reference not set to an instance of an object. (DatabaseMailWizard)

So it seems like the database mail install is completely shot.... Is anyone else having this problem?

thanks.

ok -- found the problem.

was trying to configure Database Mail on the September version using client tools from the April version ( oops )

;)

No comments:

Post a Comment