Wednesday, February 15, 2012

Error adding an Account to a Profile for 'Database Mail'

Configuring...
- Create new account 'SQL Agent SMTP Account' for SMTP server {exchange
server}(Error)
Messages
? Unable to create new account SQL Agent SMTP Account for SMTP server
Microsoft.SqlServer.Management.SqlManagerUI.SQLiMailServer.
ADDITIONAL INFORMATION:
Create failed for MailAccount 'SQL Agent SMTP Account'.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...nt&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Cannot insert the value NULL into column 'servername', table
'msdb.dbo.sysmail_server'; column does not allow nulls. INSERT fails.
The statement has been terminated. (Microsoft SQL Server, Error: 515) {
this
was filled in. Don't kow why it is saying it was NULL}
For help, click:
http://go.microsoft.com/fwlink?Prod...15&LinkId=20476
- Update profile 'Mail Profile For SQL Server Agent' (Success)
- Add account 'SQL Agent SMTP Account' to profile 'Mail Profile For SQL
Server Agent' with priority '1' (Error)
Messages
? Unable to add account SQL Agent SMTP Account to profile Mail Profile For
SQL Server Agent.
ADDITIONAL INFORMATION:
Add MailAccount to MailProfile failed for MailProfile 'Mail Profile For SQL
Server Agent'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...le&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
account name is not valid (Microsoft SQL Server, Error: 14607)
For help, click:
http://go.microsoft.com/fwlink?Prod...07&LinkId=20476Wild guess: What does below return:
SELECT @.@.SERVERNAME
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Buehler" <Buehler@.discussions.microsoft.com> wrote in message
news:39B595AE-DC22-4D4C-8921-EB67AAFD5B72@.microsoft.com...
> Configuring...
> - Create new account 'SQL Agent SMTP Account' for SMTP server {exchan
ge
> server}(Error)
> Messages
> ? Unable to create new account SQL Agent SMTP Account for SMTP server
> Microsoft.SqlServer.Management.SqlManagerUI.SQLiMailServer.
> --
> ADDITIONAL INFORMATION:
> Create failed for MailAccount 'SQL Agent SMTP Account'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...nt&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Cannot insert the value NULL into column 'servername', table
> 'msdb.dbo.sysmail_server'; column does not allow nulls. INSERT fails.
> The statement has been terminated. (Microsoft SQL Server, Error: 515)
3;this
> was filled in. Don't kow why it is saying it was NULL}
> For help, click:
> http://go.microsoft.com/fwlink?Prod...15&LinkId=20476
>
> - Update profile 'Mail Profile For SQL Server Agent' (Success)
> - Add account 'SQL Agent SMTP Account' to profile 'Mail Profile For SQL
> Server Agent' with priority '1' (Error)
> Messages
> ? Unable to add account SQL Agent SMTP Account to profile Mail Profile F
or
> SQL Server Agent.
> --
> ADDITIONAL INFORMATION:
> Add MailAccount to MailProfile failed for MailProfile 'Mail Profile For SQ
L
> Server Agent'. (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...le&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> account name is not valid (Microsoft SQL Server, Error: 14607)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
>|||found solution. There is a 'bug' in the wizard. used
dbo.sysmail_add_account_sp to add account.

No comments:

Post a Comment