Error during configuring distribution wizard

TITLE: Configure Distribution Wizard

An error occurred configuring SQL Server Agent.

ADDITIONAL INFORMATION:

SQL Server blocked access to procedure 'dbo.sp_set_sqlagent_properties' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. (Microsoft SQL Server, Error: 15281)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15281&LinkId=20476

How do I solve this?

Thanks,

Frank

System Engineer

I think the solution is pretty clear inside the error message. Did you have problems following the instructions?|||

The worst part, as with many of the error messages, the link in the error takes you to a "sorry no information is available about this problem". Don't know what broke in that process, but I have seen that exact page come up several times while checking alerts in MOM. I hope it is something that will be fixed soon because it seems pretty sad that a link in internal help provides "No Help".

Allen

|||

Please execute

The following shows the available options

USE master;

GO

EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;

EXEC sp_configure;

The following enables the Agent XPs

EXEC sp_configure 'Agent XPs', '1';

|||

Hi,

Has anybody get the solution as I am getting the same error while installing sqlserver 2005 express on my window xp.

pls see below

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot add functional unit 'sp_sqlagent_get_startup_info' to component 'Agent XPs'. This unit has been already registered with the component.. Refer to the server error logs and Setup logs for detailed error information.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40sysdbupg.sql%40107%40x3bff

BUTTONS:

&Retry
Cancel

Thanks

|||

SQL Server 2005 Express does not have a SQL Server agent. Nor can it be configured as a distributor.

Exactly how are you attempting to configure it as a distributor?

From http://msdn2.microsoft.com/en-us/library/ms151819.aspx

SQL Server Express cannot serve as a Publisher or Distributor. However, merge replication allows changes to be replicated in both directions between a Publisher and Subscriber.

|||

try this :

Change the system date to cureent day

Error during configuring distribution wizard

TITLE: Configure Distribution Wizard

An error occurred configuring SQL Server Agent.

ADDITIONAL INFORMATION:

SQL Server blocked access to procedure 'dbo.sp_set_sqlagent_properties' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. (Microsoft SQL Server, Error: 15281)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15281&LinkId=20476

How do I solve this?

Thanks,

Frank

System Engineer

I think the solution is pretty clear inside the error message. Did you have problems following the instructions?|||

The worst part, as with many of the error messages, the link in the error takes you to a "sorry no information is available about this problem". Don't know what broke in that process, but I have seen that exact page come up several times while checking alerts in MOM. I hope it is something that will be fixed soon because it seems pretty sad that a link in internal help provides "No Help".

Allen

|||

Please execute

The following shows the available options

USE master;

GO

EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;

EXEC sp_configure;

The following enables the Agent XPs

EXEC sp_configure 'Agent XPs', '1';

|||

Hi,

Has anybody get the solution as I am getting the same error while installing sqlserver 2005 express on my window xp.

pls see below

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot add functional unit 'sp_sqlagent_get_startup_info' to component 'Agent XPs'. This unit has been already registered with the component.. Refer to the server error logs and Setup logs for detailed error information.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40sysdbupg.sql%40107%40x3bff

BUTTONS:

&Retry
Cancel

Thanks

|||

SQL Server 2005 Express does not have a SQL Server agent. Nor can it be configured as a distributor.

Exactly how are you attempting to configure it as a distributor?

From http://msdn2.microsoft.com/en-us/library/ms151819.aspx

SQL Server Express cannot serve as a Publisher or Distributor. However, merge replication allows changes to be replicated in both directions between a Publisher and Subscriber.

|||

try this :

Change the system date to cureent day

sql

Error during configuring distribution wizard

TITLE: Configure Distribution Wizard

An error occurred configuring SQL Server Agent.

ADDITIONAL INFORMATION:

SQL Server blocked access to procedure 'dbo.sp_set_sqlagent_properties' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. (Microsoft SQL Server, Error: 15281)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15281&LinkId=20476

How do I solve this?

Thanks,

Frank

System Engineer

I think the solution is pretty clear inside the error message. Did you have problems following the instructions?|||

The worst part, as with many of the error messages, the link in the error takes you to a "sorry no information is available about this problem". Don't know what broke in that process, but I have seen that exact page come up several times while checking alerts in MOM. I hope it is something that will be fixed soon because it seems pretty sad that a link in internal help provides "No Help".

Allen

|||

Please execute

The following shows the available options

USE master;

GO

EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;

EXEC sp_configure;

The following enables the Agent XPs

EXEC sp_configure 'Agent XPs', '1';

|||

Hi,

Has anybody get the solution as I am getting the same error while installing sqlserver 2005 express on my window xp.

pls see below

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot add functional unit 'sp_sqlagent_get_startup_info' to component 'Agent XPs'. This unit has been already registered with the component.. Refer to the server error logs and Setup logs for detailed error information.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40sysdbupg.sql%40107%40x3bff

BUTTONS:

&Retry
Cancel

Thanks

|||

SQL Server 2005 Express does not have a SQL Server agent. Nor can it be configured as a distributor.

Exactly how are you attempting to configure it as a distributor?

From http://msdn2.microsoft.com/en-us/library/ms151819.aspx

SQL Server Express cannot serve as a Publisher or Distributor. However, merge replication allows changes to be replicated in both directions between a Publisher and Subscriber.

|||

try this :

Change the system date to cureent day

Error during configuring distribution wizard

TITLE: Configure Distribution Wizard

An error occurred configuring SQL Server Agent.

ADDITIONAL INFORMATION:

SQL Server blocked access to procedure 'dbo.sp_set_sqlagent_properties' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. (Microsoft SQL Server, Error: 15281)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15281&LinkId=20476

How do I solve this?

Thanks,

Frank

System Engineer

I think the solution is pretty clear inside the error message. Did you have problems following the instructions?|||

The worst part, as with many of the error messages, the link in the error takes you to a "sorry no information is available about this problem". Don't know what broke in that process, but I have seen that exact page come up several times while checking alerts in MOM. I hope it is something that will be fixed soon because it seems pretty sad that a link in internal help provides "No Help".

Allen

|||

Please execute

The following shows the available options

USE master;

GO

EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;

EXEC sp_configure;

The following enables the Agent XPs

EXEC sp_configure 'Agent XPs', '1';

|||

Hi,

Has anybody get the solution as I am getting the same error while installing sqlserver 2005 express on my window xp.

pls see below

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot add functional unit 'sp_sqlagent_get_startup_info' to component 'Agent XPs'. This unit has been already registered with the component.. Refer to the server error logs and Setup logs for detailed error information.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40sysdbupg.sql%40107%40x3bff

BUTTONS:

&Retry
Cancel

Thanks

|||

SQL Server 2005 Express does not have a SQL Server agent. Nor can it be configured as a distributor.

Exactly how are you attempting to configure it as a distributor?

From http://msdn2.microsoft.com/en-us/library/ms151819.aspx

SQL Server Express cannot serve as a Publisher or Distributor. However, merge replication allows changes to be replicated in both directions between a Publisher and Subscriber.

|||

try this :

Change the system date to cureent day

Error connecting to localhost site to view SQL server Mobile Agent on Device

I have set up a locahost site in IIS using the "Configure Web Synchronization Wizard". One of the first test I was asked to do was to open a broweser and browse to http://localhost/MobileTest/sqlcesa30.dll

If all is well I should get a web page with the following line:

SQL Server Mobile Server Agent 3.0

But unfortunately I get an error stating :
"The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance."

I checekd the Event log and found this error related the IIS launch process on my machine.

DCOM got error "Logon failure: unknown user name or bad password. " and was unable to logon .\IWAM_Rataq in order to run the server:

where Rataq is the name of my machine. Could my IWAM_Rataq account be corrupted, my other sites on the machine work.

Infact if i put in a Test.htm page in the virtual directory MobileTest I am able to browse to the page.

Can the Account be re-set? is there another problem that I am not aware of. I have Norton Internet 2006 running could that be the reason? Could Norton be blocking the dll from loading? But the event log states it is a Account error.

Any ideas why this might occur? any help is always appreciated

It is unlikely to be that the account is corrupt. It is more likely to be a permissions issue somewhere between authenticating the user against the site (which from what you are saying is simply the anonymous user) and pulling data out of the database. I would suggest that in the "Configure Web Sync Wizard" that you select Windows authentication and see if that allows you to sync - this will use your current logon credentials (when you access the url) instead of the anoymous user.

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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+MailAccount&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?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=515&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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Add+MailAccount+to+MailProfile+MailProfile&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?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14607&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 {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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+MailAccount&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?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=515&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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Add+MailAccount+to+MailProfile+MailProfile&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?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14607&LinkId=20476
>|||found solution. There is a 'bug' in the wizard. used
dbo.sysmail_add_account_sp to add account.

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.

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.SQLiMa ilServer.
ADDITIONAL INFORMATION:
Create failed for MailAccount 'SQL Agent SMTP Account'.
(Microsoft.SqlServer.Smo)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Create+MailAccount&LinkId=20476[/url]
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:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=515&LinkId=20476[/url]
- 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:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Add+MailAccount+to+MailProfile+MailProfile&Lin kId=20476[/url]
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:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=14607&LinkId=20476[ /url]
Wild 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 {exchange
> server}(Error)
> Messages
> ? Unable to create new account SQL Agent SMTP Account for SMTP server
> Microsoft.SqlServer.Management.SqlManagerUI.SQLiMa ilServer.
> --
> ADDITIONAL INFORMATION:
> Create failed for MailAccount 'SQL Agent SMTP Account'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Create+MailAccount&LinkId=20476[/url]
> --
> 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:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=515&LinkId=20476[/url]
>
> - 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:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Add+MailAccount+to+MailProfile+MailProfile&Lin kId=20476[/url]
> --
> 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:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=14607&LinkId=20476[ /url]
>
|||found solution. There is a 'bug' in the wizard. used
dbo.sysmail_add_account_sp to add account.