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 converting data type varchar to numeric.

Hello,
I cannot get the following Insert Command work. I get the error:
Error converting data type varchar to numeric.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Error converting
data type varchar to numeric.
However 'rate' and 'maximum' variables are declared as Decimal
Dim rate As Decimal
Dim maximumAs Decimal
SqlDataSource1.InsertCommand = "INSERT INTO Example(userName, rate,
maximum, ticket) VALUES('blabla','" & rate & "','" & maximum & "','" &
RadioButtonList1.SelectedValue & "')"
SqlDataSource1.Insert()
CREATE TABLE Example(
userName nvarchar(50),
rate decimal(2, 2),
maximum decimal(6, 2),
ticket nchar(1)
)Try dropping the string delimiters (single quotes). Something like;
"INSERT INTO Example(userName, rate,
maximum, ticket) VALUES('blabla'," & rate & "," & maximum & ",'" &
RadioButtonList1.SelectedValue & "')"
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Dot Net Daddy" wrote:
| Hello,
|
| I cannot get the following Insert Command work. I get the error:
|
|
| Error converting data type varchar to numeric.
| Description: An unhandled exception occurred during the execution of
| the current web request. Please review the stack trace for more
| information about the error and where it originated in the code.
|
|
| Exception Details: System.Data.SqlClient.SqlException: Error converting
|
| data type varchar to numeric.
|
|
| However 'rate' and 'maximum' variables are declared as Decimal
|
|
| Dim rate As Decimal
| Dim maximumAs Decimal
|
|
| SqlDataSource1.InsertCommand = "INSERT INTO Example(userName, rate,
| maximum, ticket) VALUES('blabla','" & rate & "','" & maximum & "','" &
| RadioButtonList1.SelectedValue & "')"
|
|
| SqlDataSource1.Insert()
|
|
| CREATE TABLE Example(
| userName nvarchar(50),
| rate decimal(2, 2),
| maximum decimal(6, 2),
| ticket nchar(1)
| )
||||Hi,
Already tried that. But this time I got the error:
There are fewer columns in the INSERT statement than values specified
in the VALUES clause. The number of values in the VALUES clause must
match the number of columns specified in the INSERT statement.
Dave Patrick wrote:
> Try dropping the string delimiters (single quotes). Something like;
> "INSERT INTO Example(userName, rate,
> maximum, ticket) VALUES('blabla'," & rate & "," & maximum & ",'" &
> RadioButtonList1.SelectedValue & "')"
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Dot Net Daddy" wrote:
> | Hello,
> |
> | I cannot get the following Insert Command work. I get the error:
> |
> |
> | Error converting data type varchar to numeric.
> | Description: An unhandled exception occurred during the execution of
> | the current web request. Please review the stack trace for more
> | information about the error and where it originated in the code.
> |
> |
> | Exception Details: System.Data.SqlClient.SqlException: Error converting
> |
> | data type varchar to numeric.
> |
> |
> | However 'rate' and 'maximum' variables are declared as Decimal
> |
> |
> | Dim rate As Decimal
> | Dim maximumAs Decimal
> |
> |
> | SqlDataSource1.InsertCommand = "INSERT INTO Example(userName, rate,
> | maximum, ticket) VALUES('blabla','" & rate & "','" & maximum & "','" &
> | RadioButtonList1.SelectedValue & "')"
> |
> |
> | SqlDataSource1.Insert()
> |
> |
> | CREATE TABLE Example(
> | userName nvarchar(50),
> | rate decimal(2, 2),
> | maximum decimal(6, 2),
> | ticket nchar(1)
> | )
> ||||I'm not dotnet savvy but you might try something to the effect of;
MsgBox SqlDataSource1.InsertCommand
to see the actual SQL being passed.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Dot Net Daddy" wrote:
| Hi,
|
| Already tried that. But this time I got the error:
|
| There are fewer columns in the INSERT statement than values specified
| in the VALUES clause. The number of values in the VALUES clause must
| match the number of columns specified in the INSERT statement.|||thank you so much.. that helped..
silly me.. I was passing the logon name to the database, which was
causing the problem..
thanks for your help...
Dot Net Daddy wrote:[vbcol=seagreen]
> Hi,
> Already tried that. But this time I got the error:
> There are fewer columns in the INSERT statement than values specified
> in the VALUES clause. The number of values in the VALUES clause must
> match the number of columns specified in the INSERT statement.
>
>
> Dave Patrick wrote:|||Good to hear. You're welcome.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Dot Net Daddy" wrote:
| thank you so much.. that helped..
|
| silly me.. I was passing the logon name to the database, which was
| causing the problem..
|
| thanks for your help...|||I see you have found a resolution to your immediate problem but I want to
point out that this code has a serious vulnerability to SQL injection. I
strongly recommend that you use command parameters instead of string
concatenation and perhaps also use only stored procedures so that direct
table permissions are not needed.
Google "SQL injection" find many discussions on the topic.
Hope this helps.
Dan Guzman
SQL Server MVP
"Dot Net Daddy" <cagriandac@.gmail.com> wrote in message
news:1156041975.673742.64030@.h48g2000cwc.googlegroups.com...
> Hello,
> I cannot get the following Insert Command work. I get the error:
>
> Error converting data type varchar to numeric.
> Description: An unhandled exception occurred during the execution of
> the current web request. Please review the stack trace for more
> information about the error and where it originated in the code.
>
> Exception Details: System.Data.SqlClient.SqlException: Error converting
> data type varchar to numeric.
>
> However 'rate' and 'maximum' variables are declared as Decimal
>
> Dim rate As Decimal
> Dim maximumAs Decimal
>
> SqlDataSource1.InsertCommand = "INSERT INTO Example(userName, rate,
> maximum, ticket) VALUES('blabla','" & rate & "','" & maximum & "','" &
> RadioButtonList1.SelectedValue & "')"
>
> SqlDataSource1.Insert()
>
> CREATE TABLE Example(
> userName nvarchar(50),
> rate decimal(2, 2),
> maximum decimal(6, 2),
> ticket nchar(1)
> )
>

Error after installing SQL 2005 sp2

After installing this, when I try to open a backup maintenance plan in
Management Studio, I get this error:
Error 1 Error loading 'MSAAFullBackup' : Unable to cast COM object of type
'Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass' to interface type
'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSApplication90'. This operation
failed because the QueryInterface call on the COM component for the interfac
e
with IID '{7591CC39-276A-4973-97C7-4EFEA5A5788F}' failed due to the fol
lowing
error: No such interface supported (Exception from HRESULT: 0x80004002
(E_NOINTERFACE)).. server=CLAUDIA;package=Maintenance
Plans\MSAAFullBackup; 1 1
Any suggestions as to how I can fix this?
ThanksHi,
To let me better understand your issue, could you please confirm with me
the following questions:
1. What is your SQL Server edition?
2. Has SQL Server 2005 SP2 been installed on your computer?
3. What is your Windows OS edition?
4. Does the error occur even if you just create a new BACKUP maintenance
plan?
For now, you may try manually running:
regsvr32 C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll
to see if this issue persists.
Please feel free to let me know if you have any other questions or
concerns. Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Charles,
1. Standard
2. Yes, sp2 (the version after March 5) has been installed
3. Windows 2003 Server Standard
4. Yes
I can also tell you that when I was installing the sp, I got these messages,
which I have been unable to correct:
1. The Application data folder for Visual Studio Macros could not be created
2. The Application data folder for Microsoft Document Explorer could not be
created
Thanks,
Tom
"Charles Wang[MSFT]" wrote:

> Hi,
> To let me better understand your issue, could you please confirm with me
> the following questions:
> 1. What is your SQL Server edition?
> 2. Has SQL Server 2005 SP2 been installed on your computer?
> 3. What is your Windows OS edition?
> 4. Does the error occur even if you just create a new BACKUP maintenance
> plan?
> For now, you may try manually running:
> regsvr32 “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll”
> to see if this issue persists.
> Please feel free to let me know if you have any other questions or
> concerns. Have a good day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ========================================
=============
> Get notification to my posts through email? Please refer to:
> [url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif[/ur
l]
> ications
> If you are using Outlook Express, please make sure you clear the check box
> "Tools/Options/Read: Get 300 headers at a time" to see your reply promptly
.
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscript...t/default.aspx.
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>
>
>|||Hi Tom,
Thanks for your response.
I am applying for a test environment as yours to check if this is a common
issue.
For now, I recommend that you mail me the following files for further
research:
%PROGRAMFILES%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
%PROGRAMFILES%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
The Hotfix folder may be large. I would like to create a workspace for your
uploading the files; however the process need your email address. Could you
please first send me (changliw_at_microsoft_dot_com) a email response now?
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Hi Tom,
After checked the hotfix logs, I found that SQL 2005 SP2 failed to be
installed on client tools . Please refer to the following errors:
Product : Client Components
Product Version (Previous): 2153
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB
921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and
configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The transaction has aborted.
From my research from our internal libraries, there are some similar issues
there but the root cause seems various and the troubleshooting steps were
complex.
You may try reinstalling COM+ and .NET Framework or check if your MSDTC was
disabled under your computer. Please refer to the following articles:
How to: Work Around COM+ System Configuration Check Failure in SQL Server
Setup
http://msdn2.microsoft.com/en-us/library/ms143690.aspx
How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/kb/817064
Also you may try uninstalling SQL Server 2005 client components from Add
Remove Programs and reinstall it from Tools folder of your SQL Server 2005
setup CD, and then apply SQL 2005 SP2 again.
If this issue persists, effectively and immediately I recommend that you
contact Microsoft Customer Support Service (CSS) via telephone for the best
support. Please be advised that contacting phone support will be a charged
call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/defaul...US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Please feel free to let me know if you have any other questions or
concerns.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============