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 CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specifiedProbably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!sql

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

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.