Error during deploy

Hi,
I am publishing my reports to a server and for 2 out of 7 reports I receive
the following error message:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was
thrown.
On my machine the reports worked fine.
The server does process the other reports correctly.
The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
These two failing reports don't seem to have anything special compared to
the others.
Any suggestions what might be causing this? (And how to solve it?)
Thanks a lot for your help,
Edgar
--
Message posted via http://www.sqlmonster.comCheck the log files for more details.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Edgar Walther via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:ee24db616d0849f59f74c0c0f1ef3f9d@.SQLMonster.com...
> Hi,
> I am publishing my reports to a server and for 2 out of 7 reports I
> receive
> the following error message:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was
> thrown.
> On my machine the reports worked fine.
> The server does process the other reports correctly.
> The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
> These two failing reports don't seem to have anything special compared to
> the others.
> Any suggestions what might be causing this? (And how to solve it?)
> Thanks a lot for your help,
> Edgar
> --
> Message posted via http://www.sqlmonster.com|||Where can I find these log files?
I've looked in the windows application event log for ReportingServices
events, but there were no events (except report server started).
Thanks,
Edgar
"Jeff A. Stucker" wrote:
> Check the log files for more details.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Edgar Walther via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
> news:ee24db616d0849f59f74c0c0f1ef3f9d@.SQLMonster.com...
> > Hi,
> >
> > I am publishing my reports to a server and for 2 out of 7 reports I
> > receive
> > the following error message:
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was
> > thrown.
> >
> > On my machine the reports worked fine.
> > The server does process the other reports correctly.
> > The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
> >
> > These two failing reports don't seem to have anything special compared to
> > the others.
> >
> > Any suggestions what might be causing this? (And how to solve it?)
> >
> > Thanks a lot for your help,
> >
> > Edgar
> >
> > --
> > Message posted via http://www.sqlmonster.com
>
>|||In a default installation, here:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Edgar" <Edgar@.discussions.microsoft.com> wrote in message
news:32D4111D-7B88-47A3-830D-257BF001587E@.microsoft.com...
> Where can I find these log files?
> I've looked in the windows application event log for ReportingServices
> events, but there were no events (except report server started).
> Thanks,
> Edgar
>
> "Jeff A. Stucker" wrote:
>> Check the log files for more details.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Edgar Walther via SQLMonster.com" <forum@.SQLMonster.com> wrote in
>> message
>> news:ee24db616d0849f59f74c0c0f1ef3f9d@.SQLMonster.com...
>> > Hi,
>> >
>> > I am publishing my reports to a server and for 2 out of 7 reports I
>> > receive
>> > the following error message:
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException
>> > was
>> > thrown.
>> >
>> > On my machine the reports worked fine.
>> > The server does process the other reports correctly.
>> > The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
>> >
>> > These two failing reports don't seem to have anything special compared
>> > to
>> > the others.
>> >
>> > Any suggestions what might be causing this? (And how to solve it?)
>> >
>> > Thanks a lot for your help,
>> >
>> > Edgar
>> >
>> > --
>> > Message posted via http://www.sqlmonster.com
>>sql

Error deploying report with SQL Server (Visual Studio) 2005

Hi All,
I'm trying to deploy a report that have just been created in Visual
Studio 2005 (for Microsoft CRM) I'm getting an error message
******************************
The project cannot be deployed because no target server is specified.
Provide a value for the TargetServerURL property in the property page
of this project.
******************************
I'm sorry I'm new with this Visual Studio 2005 ... I'm not finding the
place to put the TargetServerURL value in that property page ... The
worst thing is that it is probably right under my nose ... ;-)
Anybody can help a dummy ? ... ThanksProject -> your Project Name Properties (Last Menu Item) on the pop up
window you'll find what you're looking for.
Manny
Frank wrote:
>Hi All,
>I'm trying to deploy a report that have just been created in Visual
>Studio 2005 (for Microsoft CRM) I'm getting an error message
>******************************
>The project cannot be deployed because no target server is specified.
>Provide a value for the TargetServerURL property in the property page
>of this project.
>******************************
>I'm sorry I'm new with this Visual Studio 2005 ... I'm not finding the
>place to put the TargetServerURL value in that property page ... The
>worst thing is that it is probably right under my nose ... ;-)
>Anybody can help a dummy ? ... Thanks
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200701/1

Error deploying managed stored proc

When I try to deploy this managed stored proc assembly on SQL Server 2005 I get this error:

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x8007000e. You may fix the problem and try again later

I looked on the net but found no documentation about it. I know the CLR v2.0 is working as I have some ASP.NET apps running from this server that use it. Any ideas?

Try the simple code to get a .dll file:

using System.Data;
using System.Data.SqlClient;
using Microsoft.SqlServer.Server;

public partial class StoredProcedures
{
[Microsoft.SqlServer.Server.SqlProcedure()]
public static void SampleSP(string connstring, out int spid)
{
using (SqlConnection conn = new SqlConnection(connstring))
{
conn.Open();

SqlCommand cmd = new SqlCommand("SELECT @.@.SPID", conn);
spid = (System.Int16)cmd.ExecuteScalar();
}
}
}

And then let's manually create assmebly from the dll file in Management Studio:

1. Login to SQL2005 as 'sa', locate a database->new query->execute following command:

alter database yourdb set trustworthy on

go

sp_configure 'clr enabled',1
reconfigure with override

go

2. create an assembly from the dll file

3. create a stored procedure which references the assembly:

create procedure testCLR @.conn nvarchar(max),@.i int output as
external name ClassLibrary2.[StoredProcedures].SampleSP

4. Test the procedure:

declare @.i int

exec testCLR 'Data Source=.;Integrated Security=SSPI;Database=master',@.i output

select @.i

And here is a good torturial for using CLR in SQL2005:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/mandataaccess.asp

Error deploying Analysis Service Project

Hi,

We are following the Analysis Service Tutorial and when we tried to deploy we got these errors:

Error 1 OLE DB error: OLE DB or ODBC error: Login failed for user 'PASCAL\CEZAR$'.; 42000. 0 0
Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW', Name of 'Adventure Works DW'. 0 0
Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 4 Errors in the OLAP storage engine: An error occurred while the 'CalendarYear' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0
Error 5 OLE DB error: OLE DB or ODBC error: Login failed for user 'PASCAL\CEZAR$'.; 42000. 0 0
Error 6 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW', Name of 'Adventure Works DW'. 0 0
Error 7 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 8 Errors in the OLAP storage engine: An error occurred while the 'CalendarSemester' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0

We hope someone can help us.

Thanks a lot.

Hi Cezar. Your problem looks like the user PASCAL\CEZAR$ doesn't have access rights to the SQL Server source data, 'Adventure Works DW'. Check the access rights for 'Adventure Works DW' in SQL Server Manager, and verify that the user PASCAL\CEZAR$ has rights to the database.

Hope this helps - Paul Goldy

|||

Hi,

Thanks for your answer. The user error has been solved, but we got other error messages:

Error 1 OLE DB error: OLE DB or ODBC error: SELECT permission denied on object 'DimTime', database 'AdventureWorksDW', schema 'dbo'.; 42000. 0 0
Error 2 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 3 Errors in the OLAP storage engine: An error occurred while the 'EnglishMonthName' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0
Error 4 OLE DB error: OLE DB or ODBC error: SELECT permission denied on object 'DimTime', database 'AdventureWorksDW', schema 'dbo'.; 42000. 0 0
Error 5 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 6 Errors in the OLAP storage engine: An error occurred while the 'CalendarSemester' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0
Error 7 Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure. 0 0
Error 8 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 9 Errors in the OLAP storage engine: An error occurred while the 'CalendarYear' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0
Error 10 OLE DB error: OLE DB or ODBC error: Opera??o cancelada; HY008. 0 0
Error 11 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0
Error 12 Errors in the OLAP storage engine: An error occurred while the 'CalendarQuarter' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0

What can we do?

Yours, Cezar

|||

Hi Cezar. The error you received, "SELECT permission denied on object 'DimTime', database 'AdventureWorksDW', schema 'dbo'.; 42000. 0 0", is saying you do NOT have read permission for the AdventureWorksDW database. In SQL manager 2005 you must manage the permission for the AdventureWorksDW database and allow the user (I assume CEZAR\PASCAL$) db_datareader permission for the database. Here is a link which discusses more about setting permissions for SQL Server:

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

Paul Goldy

Error Deploying An unexpected error occurred while compiling expressions. Native compiler re

When attempting to deploy a series of reports I am receiving the error:

An unexpected error occurred while compiling expressions. Native compiler return value: ‘128’.

The datasources deploy fine, but each report results in the same error. I can build the project and preview each report without issue, it is only on the deploy that the error occurs.

Any help would be appreciated

Jason

just wanted to share the "solution" to the issue.

I attempted to login to the reporting services manager so I could try and upload the reports that way rather than deploying through visual studio and I received an error: Could not find file 'C:\WINDOWS\TEMP\xw1mue_7.dll' The dll changed each time, but I found a post in google groups that suggested restarting the app pool to resolve this issue. Seems to have solved both problems.

I would still like to know why the app pool needed to be restarted....

|||Restart IIS to solve that problem.

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 between local development and production in a textbox

I have a textbox with the following:
=Fields!Distribution_Percentage.Value & "%"
It works fine on my local reportserver.
I deploy it to production and I get #Error instead.
I change it to
=Fields!Distribution_Percentage.Value
and it works fine on both except I want the % sign.
Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
result if I select the Percent format for the textbox, 100,000%.
Any clues what is happening?
NeilUse the custom format and put in 0% I think that would do it. I used 0
instead of # because I assume that if it is 0 you want to show 0% instead of
just %
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> I have a textbox with the following:
> =Fields!Distribution_Percentage.Value & "%"
> It works fine on my local reportserver.
> I deploy it to production and I get #Error instead.
> I change it to
> =Fields!Distribution_Percentage.Value
> and it works fine on both except I want the % sign.
> Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
> result if I select the Percent format for the textbox, 100,000%.
> Any clues what is happening?
> Neil|||Thanks for replying but I didn't explain it well. At first I didn't have any
formatting specified. The # is part of the #Error displayed.
The real issue appears to be mixing field values.
In the header for this report, I have:
="From Fiscal " & Parameters!startdate.Value & " to " &
Parameters!enddate.Value
This also shows #Error on the prod server and shows the results expected
results locally. It sems to be complaining about mixing text and numeric
values.
The format for these textboxes is 'Default'. I wonder if there is some
configuration setting somewhere.
Thanks,
Neil
"Bruce L-C [MVP]" wrote:
> Use the custom format and put in 0% I think that would do it. I used 0
> instead of # because I assume that if it is 0 you want to show 0% instead of
> just %
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
> news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> > I have a textbox with the following:
> > =Fields!Distribution_Percentage.Value & "%"
> > It works fine on my local reportserver.
> > I deploy it to production and I get #Error instead.
> > I change it to
> > =Fields!Distribution_Percentage.Value
> > and it works fine on both except I want the % sign.
> > Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
> > result if I select the Percent format for the textbox, 100,000%.
> >
> > Any clues what is happening?
> > Neil
>
>|||This should be working for you. I do this all the time. As a matter of fact,
you should also have no problems with appending a % on too.
When doing a string like this you do not need any formatting specified.
Ahh, just thought of something. Report parameters are case sensitive. What I
do is use the expression builder when doing this sort of thing.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
news:F810CF36-FF22-4679-BAB1-82E26D6DE67C@.microsoft.com...
> Thanks for replying but I didn't explain it well. At first I didn't have
any
> formatting specified. The # is part of the #Error displayed.
> The real issue appears to be mixing field values.
> In the header for this report, I have:
> ="From Fiscal " & Parameters!startdate.Value & " to " &
> Parameters!enddate.Value
> This also shows #Error on the prod server and shows the results expected
> results locally. It sems to be complaining about mixing text and numeric
> values.
> The format for these textboxes is 'Default'. I wonder if there is some
> configuration setting somewhere.
> Thanks,
> Neil
>
> "Bruce L-C [MVP]" wrote:
> > Use the custom format and put in 0% I think that would do it. I used 0
> > instead of # because I assume that if it is 0 you want to show 0%
instead of
> > just %
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
> > news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> > > I have a textbox with the following:
> > > =Fields!Distribution_Percentage.Value & "%"
> > > It works fine on my local reportserver.
> > > I deploy it to production and I get #Error instead.
> > > I change it to
> > > =Fields!Distribution_Percentage.Value
> > > and it works fine on both except I want the % sign.
> > > Since my numbers are like 100 or 25 instead of 1 or .25, I get the
wrong
> > > result if I select the Percent format for the textbox, 100,000%.
> > >
> > > Any clues what is happening?
> > > Neil
> >
> >
> >

Error after installing sp1

I started getting this after installing sp1 on my workstation and trying to deploy to rtm machines. The components giving this error are the data readers in the data flow.

TITLE: Microsoft Visual Studio

Component with name "<name>" and class ID "{BF01D463-7089-41EE-8F05-0A6DC17CE633}" could not be created because an error was encountered during its upgrade to the current version.
Contact information:
Extracts data from a relational database by using a .NET provider.;Microsoft Corporation;Microsoft SqlServer v9; ? 2004 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;2

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=ComponentUpgradeFailed&LinkId=20476

BUTTONS:

OK

See Component Changes - http://wiki.sqlis.com/default.aspx/SQLISWiki/SP1.html|||That's just wonderful considering I installed it on my workstation as a test and now I can't roll out a lot of my packages. Ugh, I didn't think they could make management and deployment any more of a headache but they succeeded. How about they let you write the release notes from now on :)|||As a side note, it appears that even if I edit the xml as you suggest I still cannot deploy it from my workstation or it will readd those properties.|||Maybe you are using the built in deployment utility? I'm working in a file copy style deployment so it works fine as a workaround. Failing that roll out SP1!|||

Yeah I am. I suppose it calls that upgrade method before it uploads it to the server. *sigh*

We'd like to roll out sp1 if the install would quit crashing :)