Assigning one text box value to the other text box in the sql reporting services Form

Hi,

Can some one help me in this case,

I am manipulating a value for onetext.value , And I want to assign like this

seconetext.value = onetext.value in the SQl reporting services form,

Is it possible? if so can any one help me with the syntax?

-Thanks

Yes, this is possible.

In "seconetext", use this expression:

=ReportItems!onetext.Value

-Chris

Assign Cube User Access Without Being Admin?

Is it possible to set up a "low-level" administrator account in Analysis Services that only allows a user to assign other users to a particular Role?

We have an enterprise app where users in the field will need to call a help desk to gain access to the cube, but we only want the help desk people to be able to perform that one function. We would like to avoid building a custom admin tool that provides the proper restriction. Ideally, the help desk would use SQL Server Management Studio to perform this specific task while prohibiting any other admin abilities. Is this possible?

--
Joe

No, unfortunatelly this is not possible. If you already have tool by which helpdesk can assign users to existing NT groups, then you can include these groups into SSAS roles - and helpdesk personell won't need any access to SSAS.

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>

Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.

Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>

Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.

Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

|||I also have d same problem..can anybody tell me how to fix it?????

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>

Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.

Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>

Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.

Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

|||

I had a similar error, and it was some problems in c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rssrvpolicy.config, so check that that one looks correct.

Assembly access SQL DB don't work in Windows Server 2003

I try to get a custom assembly running with Reporting Services on Windows
Server 2003. The assembly must access a SQL Server database on the same SQL
Server as Reporting Services (localhost)
The assembly is written with VB .NET 2003. I have a assembly running
accessing a oracle db, this assembly works. So I know the security settings
etc. But the problem must be somewhere in detail. Therefore detailed answers
are appreciated.
The assembly works in the designer but not in Report Server on Windows
Server 2003. The assembly get accessed by the report server but obviously the
database connection failed.
Content bellow:
- rsvPolicy.config settings
- Code in assembly
- Additional information
Settings in the rsvPolicy.config:
<PermissionSet class="NamedPermissionSet"
version="1"
Name="MyNewFilePermissionSet"
Description="A special permission set that grants read access to my file.">
<IPermission class="System.Data.OleDb.OleDbPermission"
version="1"
Flags="Assertion, Execution"/>
</PermissionSet>
<PermissionSet class="NamedPermissionSet"
version="1"
Name="MyNewFilePermissionSet"
Description="A special permission set that grants read access to my file.">
<IPermission class="System.Security.PermissionSet"
version="1"
Flags="Assertion, Execution"/>
</PermissionSet>
Code in the assembly
' declaration of the security object in the header of the class
Private m_objSecurity As System.Security.PermissionSet
Private m_strConnString As String = _
"Provider=SQLOLEDB;Data Source=localhost;Initial
Catalog=MyDatabase;Integrated Security=SSPI;"
' function to open the db
<PermissionSet(SecurityAction.Assert, Unrestricted:=True)> _
Public Function OpenDBConn() As Boolean
m_objSecurity = New PermissionSet(PermissionState.Unrestricted)
m_objSecurity.Assert()
m_objDBConn = New
System.Data.OleDB.OleDbConnection(m_strConnString)
m_objDBConn.Open()
If m_objDBConn.State = ConnectionState.Open Then
InitSQLSRVConn = True
End IF
Addional information:
IDE: .net 2003
SQL Server 2000 SP3a
Windows Server 2003
Reporting Services Enterprise Edition + SP 2The assembly works on a Windows 2000 (SP4) Machine.
For this reason I assume that the problem is related to Windows 2003 Server,
or with SP2 from Reporting Services in relation with Windows 2003 Server.
Just for the sake of completnes bellowe the code meanwhile tried on both
Systems (W2K and W2K3 Srv)
--
In rssrvpoliciy.config:
--
<PermissionSet class="NamedPermissionSet"
version="1"
Name="MyNewFilePermissionSet"
Description="A special permission set that grants access to SQL Server
Database.">
<IPermission class="System.Data.OleDB.OleDbPermission"
version="1"
Flags="Assertion, Execution"/>
</PermissionSet>
'--
' In the Assembly
'--
Private m_objSecurity As System.Data.OleDB.OleDbPermission
Private m_strConnString As String = _
"Provider=SQLOLEDB;Data Source=localhost;Initial
Catalog=myDatabase;Integrated Security=SSPI;"
<PermissionSet(SecurityAction.Assert, Unrestricted:=True)> _
Public Function InitSQLSRVConn() As Boolean
m_objSecurity = New
System.Data.OleDb.OleDbPermission(PermissionState.Unrestricted)
m_objSecurity.Assert()
m_objDBConn = New
System.Data.OleDB.OleDbConnection(m_strConnString)
m_objDBConn.Open()
If m_objDBConn.State = ConnectionState.Open Then
InitSQLSRVConn = True
End if
"Dev Main" wrote:
> I try to get a custom assembly running with Reporting Services on Windows
> Server 2003. The assembly must access a SQL Server database on the same SQL
> Server as Reporting Services (localhost)
> The assembly is written with VB .NET 2003. I have a assembly running
> accessing a oracle db, this assembly works. So I know the security settings
> etc. But the problem must be somewhere in detail. Therefore detailed answers
> are appreciated.
> The assembly works in the designer but not in Report Server on Windows
> Server 2003. The assembly get accessed by the report server but obviously the
> database connection failed.
> Content bellow:
> - rsvPolicy.config settings
> - Code in assembly
> - Additional information
> Settings in the rsvPolicy.config:
> <PermissionSet class="NamedPermissionSet"
> version="1"
> Name="MyNewFilePermissionSet"
> Description="A special permission set that grants read access to my file.">
> <IPermission class="System.Data.OleDb.OleDbPermission"
> version="1"
> Flags="Assertion, Execution"/>
> </PermissionSet>
> <PermissionSet class="NamedPermissionSet"
> version="1"
> Name="MyNewFilePermissionSet"
> Description="A special permission set that grants read access to my file.">
> <IPermission class="System.Security.PermissionSet"
> version="1"
> Flags="Assertion, Execution"/>
> </PermissionSet>
>
> Code in the assembly
> ' declaration of the security object in the header of the class
> Private m_objSecurity As System.Security.PermissionSet
> Private m_strConnString As String = _
> "Provider=SQLOLEDB;Data Source=localhost;Initial
> Catalog=MyDatabase;Integrated Security=SSPI;"
> ' function to open the db
> <PermissionSet(SecurityAction.Assert, Unrestricted:=True)> _
> Public Function OpenDBConn() As Boolean
> m_objSecurity = New PermissionSet(PermissionState.Unrestricted)
> m_objSecurity.Assert()
> m_objDBConn = New
> System.Data.OleDB.OleDbConnection(m_strConnString)
> m_objDBConn.Open()
> If m_objDBConn.State = ConnectionState.Open Then
> InitSQLSRVConn = True
> End IF
>
> Addional information:
> IDE: .net 2003
> SQL Server 2000 SP3a
> Windows Server 2003
> Reporting Services Enterprise Edition + SP 2
>
>|||At least the version in my second post works correct. The reason for the
failure was a other mistake not related to reporting services at all.
"Dev Main" wrote:
> I try to get a custom assembly running with Reporting Services on Windows
> Server 2003. The assembly must access a SQL Server database on the same SQL
> Server as Reporting Services (localhost)
> The assembly is written with VB .NET 2003. I have a assembly running
> accessing a oracle db, this assembly works. So I know the security settings
> etc. But the problem must be somewhere in detail. Therefore detailed answers
> are appreciated.
> The assembly works in the designer but not in Report Server on Windows
> Server 2003. The assembly get accessed by the report server but obviously the
> database connection failed.
> Content bellow:
> - rsvPolicy.config settings
> - Code in assembly
> - Additional information
> Settings in the rsvPolicy.config:
> <PermissionSet class="NamedPermissionSet"
> version="1"
> Name="MyNewFilePermissionSet"
> Description="A special permission set that grants read access to my file.">
> <IPermission class="System.Data.OleDb.OleDbPermission"
> version="1"
> Flags="Assertion, Execution"/>
> </PermissionSet>
> <PermissionSet class="NamedPermissionSet"
> version="1"
> Name="MyNewFilePermissionSet"
> Description="A special permission set that grants read access to my file.">
> <IPermission class="System.Security.PermissionSet"
> version="1"
> Flags="Assertion, Execution"/>
> </PermissionSet>
>
> Code in the assembly
> ' declaration of the security object in the header of the class
> Private m_objSecurity As System.Security.PermissionSet
> Private m_strConnString As String = _
> "Provider=SQLOLEDB;Data Source=localhost;Initial
> Catalog=MyDatabase;Integrated Security=SSPI;"
> ' function to open the db
> <PermissionSet(SecurityAction.Assert, Unrestricted:=True)> _
> Public Function OpenDBConn() As Boolean
> m_objSecurity = New PermissionSet(PermissionState.Unrestricted)
> m_objSecurity.Assert()
> m_objDBConn = New
> System.Data.OleDB.OleDbConnection(m_strConnString)
> m_objDBConn.Open()
> If m_objDBConn.State = ConnectionState.Open Then
> InitSQLSRVConn = True
> End IF
>
> Addional information:
> IDE: .net 2003
> SQL Server 2000 SP3a
> Windows Server 2003
> Reporting Services Enterprise Edition + SP 2
>
>

AspNetSessionExpiredException - Your results may vary?

I have a custom reporting application that displays Sql Server Reporting Services reports on an ASP.NET page using Microsoft's report viewer control. The SSRS reports are local reports (they have an rdlc extension).

When a report is left inactive for a lengthy period of time it generates anAspNetSessionExpiredException when the user attempts to move to a new page. The thing that is surprising is that the formatted exception display is contained within the report viewer. The report document map remains visible as does the report toolbar. In the right pane where the report normally appears I see a standard, raw, ASP.NET exception display.

I'm surprised that the report viewer is "catching" the exception and displaying it within the report viewer. Standard events in the page that hosts the report viewer (PreInit, Init, PageLoad) are never invoked.

I have graceful error handling defined in a base page class but it does me no good because the exception never reaches the page code-behind. Puzzling.

Do any of you ASP.NET developers know if it is possible to catch theAspNetSessionExpiredExceptionso that I can handle it in my application code rather than having SSRS display a very ugly, very raw exception message.

I've included the exception message below.

Thanks.

BlackCatBone

...

Server Error in '/templatedemo' Application.

------------------------

ASP.NET session has expired

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: Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[AspNetSessionExpiredException: ASP.NET session has expired]

Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +683

Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +553

Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +10

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

------------------------

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

I am having exactly the same problem. If anyone knows the solution to this it would be fabulous to here from you.

|||

I had the same problem and I found the solution in this posthttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=170875&SiteID=1. See Brian Hartman's post regarding sessionState. I used his suggestion of using the out-of-process session state as StateServer mode and it fixed the issue for me. Good luck.

aspnet_wp.exe could not be started.

When I launch the reporting services report server on my sql server, I
recieve the following error:
"Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web browser
to retry your request.
Administrator Note: An error message detailing the cause of this specific
request failure can be found in the application event log of the web server.
Please review this log entry to discover what caused this error to occur."
In the event log, the details are...
"aspnet_wp.exe could not be started. The error code for the failure is
80004005. This error can be caused when the worker process account has
insufficient rights to read the .NET Framework files. Please ensure that the
.NET Framework is correctly installed and that the ACLs on the installation
directory allow access to the configured account. "
I have validated that ASPNET user account does have the appropriate
permissions.
I have ran "aspnet_regiis -i".
I have validated that ASPNET user account is not locked out.
Are there any other solutions that I can try to get my report server
functioning?Hi Rhonda,
Make sure 'ASP.Net Machine Account' has Full Control permissions to the
following folder:
"C:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files"
Eshoo
"Helpme Rhonda" <Helpme Rhonda@.discussions.microsoft.com> wrote in message
news:7AA4DA9E-232E-420D-A5A3-47F213B54975@.microsoft.com...
> When I launch the reporting services report server on my sql server, I
> recieve the following error:
> "Server Application Unavailable
> The web application you are attempting to access on this web server is
> currently unavailable. Please hit the "Refresh" button in your web
browser
> to retry your request.
> Administrator Note: An error message detailing the cause of this specific
> request failure can be found in the application event log of the web
server.
> Please review this log entry to discover what caused this error to occur."
> In the event log, the details are...
> "aspnet_wp.exe could not be started. The error code for the failure is
> 80004005. This error can be caused when the worker process account has
> insufficient rights to read the .NET Framework files. Please ensure that
the
> .NET Framework is correctly installed and that the ACLs on the
installation
> directory allow access to the configured account. "
> I have validated that ASPNET user account does have the appropriate
> permissions.
> I have ran "aspnet_regiis -i".
> I have validated that ASPNET user account is not locked out.
> Are there any other solutions that I can try to get my report server
> functioning?|||My 'ASP.Net Machine Account' does have full control of the directory
mentioned below. I also have a folder of
"C:\WINNT\Microsoft.NET\Framework\v1.0.3705\" from the original installation.
Could there be some conflict with that being there?
If not, are there any other suggestions? Thank you in advance.
"Eshoo" wrote:
> Hi Rhonda,
> Make sure 'ASP.Net Machine Account' has Full Control permissions to the
> following folder:
> "C:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files"
>
> Eshoo
> "Helpme Rhonda" <Helpme Rhonda@.discussions.microsoft.com> wrote in message
> news:7AA4DA9E-232E-420D-A5A3-47F213B54975@.microsoft.com...
> > When I launch the reporting services report server on my sql server, I
> > recieve the following error:
> >
> > "Server Application Unavailable
> > The web application you are attempting to access on this web server is
> > currently unavailable. Please hit the "Refresh" button in your web
> browser
> > to retry your request.
> >
> > Administrator Note: An error message detailing the cause of this specific
> > request failure can be found in the application event log of the web
> server.
> > Please review this log entry to discover what caused this error to occur."
> >
> > In the event log, the details are...
> >
> > "aspnet_wp.exe could not be started. The error code for the failure is
> > 80004005. This error can be caused when the worker process account has
> > insufficient rights to read the .NET Framework files. Please ensure that
> the
> > .NET Framework is correctly installed and that the ACLs on the
> installation
> > directory allow access to the configured account. "
> >
> > I have validated that ASPNET user account does have the appropriate
> > permissions.
> > I have ran "aspnet_regiis -i".
> > I have validated that ASPNET user account is not locked out.
> >
> > Are there any other solutions that I can try to get my report server
> > functioning?
>
>|||My agency is have this problem as well... I am exhaused from troubleshooting
SQL Reporting Services. Here are details of the problem:
I've been having a little trouble with an installation of SQL Reporting
Services. The installation is truly vanilla, but I can't seem to find a
resolution for the below noted problem. I have tried all of the fixes I can
find on MSDN and TechNet in the Knowledge Base that address the error
message. If you can help at all, I would greatly appreciate.
From Browser Requesting Reporting Services (http://{hostname}/Reports/ or
http://{hostname}/reportserver):
Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web browser to
retry your request.
Administrator Note: An error message detailing the cause of this specific
request failure can be found in the application event log of the web server.
Please review this log entry to discover what caused this error to occur.
Event Log Detail:
aspnet_wp.exe could not be started. The error code for the failure is
80070545. This error can be caused when the worker process account has
insufficient rights to read the .NET Framework files. Please ensure that the
.NET Framework is correctly installed and that the ACLs on the installation
directory allow access to the configured account.
Knowledge Base/MSDN/TechNet Attempted Fixes:
317012, 315158, 323292, 833444, 811320
In one situation there were errors in the security log regarding access,
this was resolved on that installation and now works. The only errors
produced in the event log is the one noted above.
"Eshoo" wrote:
> Hi Rhonda,
> Make sure 'ASP.Net Machine Account' has Full Control permissions to the
> following folder:
> "C:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files"
>
> Eshoo
> "Helpme Rhonda" <Helpme Rhonda@.discussions.microsoft.com> wrote in message
> news:7AA4DA9E-232E-420D-A5A3-47F213B54975@.microsoft.com...
> > When I launch the reporting services report server on my sql server, I
> > recieve the following error:
> >
> > "Server Application Unavailable
> > The web application you are attempting to access on this web server is
> > currently unavailable. Please hit the "Refresh" button in your web
> browser
> > to retry your request.
> >
> > Administrator Note: An error message detailing the cause of this specific
> > request failure can be found in the application event log of the web
> server.
> > Please review this log entry to discover what caused this error to occur."
> >
> > In the event log, the details are...
> >
> > "aspnet_wp.exe could not be started. The error code for the failure is
> > 80004005. This error can be caused when the worker process account has
> > insufficient rights to read the .NET Framework files. Please ensure that
> the
> > .NET Framework is correctly installed and that the ACLs on the
> installation
> > directory allow access to the configured account. "
> >
> > I have validated that ASPNET user account does have the appropriate
> > permissions.
> > I have ran "aspnet_regiis -i".
> > I have validated that ASPNET user account is not locked out.
> >
> > Are there any other solutions that I can try to get my report server
> > functioning?
>
>|||Me too. This is frustrating. Is this a bug? I had a perfectly operational
install of SQLRS SP1 until I installed SP2. Anyone with ideas?
"Helpme Rhonda" wrote:
> When I launch the reporting services report server on my sql server, I
> recieve the following error:
> "Server Application Unavailable
> The web application you are attempting to access on this web server is
> currently unavailable. Please hit the "Refresh" button in your web browser
> to retry your request.
> Administrator Note: An error message detailing the cause of this specific
> request failure can be found in the application event log of the web server.
> Please review this log entry to discover what caused this error to occur."
> In the event log, the details are...
> "aspnet_wp.exe could not be started. The error code for the failure is
> 80004005. This error can be caused when the worker process account has
> insufficient rights to read the .NET Framework files. Please ensure that the
> .NET Framework is correctly installed and that the ACLs on the installation
> directory allow access to the configured account. "
> I have validated that ASPNET user account does have the appropriate
> permissions.
> I have ran "aspnet_regiis -i".
> I have validated that ASPNET user account is not locked out.
> Are there any other solutions that I can try to get my report server
> functioning?|||Just as an FYI, as a work around, I added the ASP.NET user account to the
local server's Administrators group and it started working again:
NOTE: This completely defeats the purpose of having the ASP.NET account so
we still need to find a solution to why this "just happens".
"Helpme Rhonda" wrote:
> When I launch the reporting services report server on my sql server, I
> recieve the following error:
> "Server Application Unavailable
> The web application you are attempting to access on this web server is
> currently unavailable. Please hit the "Refresh" button in your web browser
> to retry your request.
> Administrator Note: An error message detailing the cause of this specific
> request failure can be found in the application event log of the web server.
> Please review this log entry to discover what caused this error to occur."
> In the event log, the details are...
> "aspnet_wp.exe could not be started. The error code for the failure is
> 80004005. This error can be caused when the worker process account has
> insufficient rights to read the .NET Framework files. Please ensure that the
> .NET Framework is correctly installed and that the ACLs on the installation
> directory allow access to the configured account. "
> I have validated that ASPNET user account does have the appropriate
> permissions.
> I have ran "aspnet_regiis -i".
> I have validated that ASPNET user account is not locked out.
> Are there any other solutions that I can try to get my report server
> functioning?

aspnet_regsql

Where's the sql script to generate "aspnet_regsql" application services database stored? Thanks.

We use ASP.NET SQL Server Registration tool (aspnet_regsql.exe) to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, and I haven't heard the corresponding SQL script. Are you sure there is a SQL script used to created database objects for use by application services?

For more information about the tool, you can refer to:

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

|||I read an article saying DBA can use a script provided by MS to generate the application services database on SQL server. Thanks.

ASPNET account permissions

I am new to Reporting Services and still learning, but it is a very nice exciting program. I built a new Report and was experimenting with Grouping in reports and using the parameters. Now I would like to Deploy the report to the Report Server so I can use this report on our intranet, however I get the error that the ASPNET account does not have the proper permissions. I am sure that I need to set up ASPNET to have "write" abilities.

What folder(s) do I need to make sure that ASPNET has this? Or should I be looking elsewhere to set up the ASPNET account on the Report Server?

Thanks for the information.

Will you post the exact error message you are seeing? Does it indicate which resource is not permissioned?|||

This is the exact error message when I try to deploy the report:

Error 1 The permissions granted to user 'BRAD\ASPNET' are insufficient for performing this operation. 0 0

|||The folder that needs permission is the root folder in the report server namespace. But running as the ASPNet account is usually not what you want, since all users will be connecting as the same user account. It looks like your report server config file has impersonation turned off. Is this something you changed intentionally?|||

Brian,

For now I did go into Report Services through the SQL Management Studios, went into properties and did see that ASPNET was unchecked. I checked it and now the reports deploy just fine.

Thanks for the great information.

ASP.Net Server Setup Exception (reqsql.exe)

I was attampting to add application services to a remote server to my ASP database and received and exception.

Setup failed.

Exception:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 8152 and the SqlException message is: String or binary data would be truncated.

-
Details of failure
-

SQL Server:
Database: [consecdevdb]
SQL file loaded:
InstallCommon.sql

Commands failed:

CREATE TABLE #aspnet_Permissions
(
Owner sysname,
Object sysname,
Grantee sysname,
Grantor sysname,
ProtectType char(10),
[Action] varchar(20),
[Column] sysname
)

INSERT INTO #aspnet_Permissions
EXEC sp_helprotect

IF (EXISTS (SELECT name
FROM sysobjects
WHERE (name = N'aspnet_Setup_RestorePermissions')
AND (type = 'P')))
DROP PROCEDURE [dbo].aspnet_Setup_RestorePermissions

SQL Exception:
System.Data.SqlClient.SqlException: String or binary data would be truncated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)

Can anyone help me with this?

The problem is that the "Action" column is defined as varchar(20) but it actually needs more space. Change the script to something like 200 and it should work...

Hope this helps!

-- Scott Whigham|||

Scott Whigham, This really help a lot, first I think is access problem, because i using sql to run the script, it give the error msg is

Cannot grant, deny, or revoke permissions to sa, dbo, information_schema, sys, or yourself.
Cannot grant, deny, or revoke permissions to sa, dbo, information_schema, sys, or yourself.

I keep on setting on the access right problem , still cannot solve it.

InstallCommon.SQL is default file in framework folder, how come got this kind of error?

hope microsoft can solve it....

-- Shiro Amada

ASP.Net Server Setup Exception (reqsql.exe)

I was attampting to add application services to a remote server to my ASP database and received and exception.

Setup failed.

Exception:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 8152 and the SqlException message is: String or binary data would be truncated.

-
Details of failure
-

SQL Server:
Database: [consecdevdb]
SQL file loaded:
InstallCommon.sql

Commands failed:

CREATE TABLE #aspnet_Permissions
(
Owner sysname,
Object sysname,
Grantee sysname,
Grantor sysname,
ProtectType char(10),
[Action] varchar(20),
[Column] sysname
)

INSERT INTO #aspnet_Permissions
EXEC sp_helprotect

IF (EXISTS (SELECT name
FROM sysobjects
WHERE (name = N'aspnet_Setup_RestorePermissions')
AND (type = 'P')))
DROP PROCEDURE [dbo].aspnet_Setup_RestorePermissions

SQL Exception:
System.Data.SqlClient.SqlException: String or binary data would be truncated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)

Can anyone help me with this?

The problem is that the "Action" column is defined as varchar(20) but it actually needs more space. Change the script to something like 200 and it should work...

Hope this helps!

-- Scott Whigham|||

Scott Whigham, This really help a lot, first I think is access problem, because i using sql to run the script, it give the error msg is

Cannot grant, deny, or revoke permissions to sa, dbo, information_schema, sys, or yourself.
Cannot grant, deny, or revoke permissions to sa, dbo, information_schema, sys, or yourself.

I keep on setting on the access right problem , still cannot solve it.

InstallCommon.SQL is default file in framework folder, how come got this kind of error?

hope microsoft can solve it....

-- Shiro Amada

ASP.Net ReportingServices & CPU Usage

I have a report (stored procedure) that I have set up in SQL 2005
Reporting Services. In a web app, I put a Reportviewer control on the
page, and call the report. After a lot of trial & error, it appears to
work.
Sort of.
What happens is when I open it on that tab (I am using AJAX Tab panels,
which had been working fine without this behavior prior to finally
getting the reportviewer working), and the report displays, the "e" on
Internet explorer at the top of the tab now flickers, like the page is
reloading. It also runs the CPU up to 100% on the computer and although
I can go from tab to tab in it (I am using AJAX tab panels in the page),
it will take like up to a minute to go to the next tab. I'm not doing
anything really data-intensive on those tabs, and they had been
functioning fine prior to putting in the report viewer (i.e. they
weren't flickering & clocking the CPU).
I eventually have to kill the page to do anything, because it has the
system up to 100%.
Any idea why reportviewer might make this act this way?
Thanks for the help,How much data are you churning in RS? The way to tell is look at how much
data is actaully returned from the sproc.
As much as possible, try to filter down your data and do calcs in the sproc,
not in RS. If you return large data sets to RS, you will churn the machine.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)
************************************************
Think outside the box!
************************************************
"Blasting Cap" <goober@.christian.net> wrote in message
news:%23GxNIeu0HHA.5884@.TK2MSFTNGP02.phx.gbl...
>I have a report (stored procedure) that I have set up in SQL 2005 Reporting
>Services. In a web app, I put a Reportviewer control on the page, and call
>the report. After a lot of trial & error, it appears to work.
> Sort of.
> What happens is when I open it on that tab (I am using AJAX Tab panels,
> which had been working fine without this behavior prior to finally getting
> the reportviewer working), and the report displays, the "e" on Internet
> explorer at the top of the tab now flickers, like the page is reloading.
> It also runs the CPU up to 100% on the computer and although I can go from
> tab to tab in it (I am using AJAX tab panels in the page), it will take
> like up to a minute to go to the next tab. I'm not doing anything really
> data-intensive on those tabs, and they had been functioning fine prior to
> putting in the report viewer (i.e. they weren't flickering & clocking the
> CPU).
> I eventually have to kill the page to do anything, because it has the
> system up to 100%.
> Any idea why reportviewer might make this act this way?
> Thanks for the help,
>|||That's just it - the data isn't that much.
I'm calling a stored procedure with 5 parameters, and it returns 1588
rows in Query Analyzer, and runs in 5 seconds there. The only
difference in QA and the Reportviewer is that I am subtotaling & grand
totaling 3 columns.
If I try to run this from within the ReportViewer, when launching that
web page, it will run the CPU up to 100% until I kill it. Pages are
extremely sluggish, and it'll take a minute or two to just go between
tabs on those 3 pages. I'm doing a Gridview on one tab, that returns
about 50 records, and a dropdown box on the second tab that returns
about 25 records, and then this one that I'm doing in the Reportviewer.
If I take out the reportviewer, the other two pages work as they should,
in next to no time at all.
Once I add back the reportviewer, the "e" on the Internet Explorer tab
flickers and I can watch the CPU usage on the computer go to 100% and
stay there until I kill the procedure. I can close it out using the X
on internet explorer, but it takes several minutes for the web browser
to detect that I've killed the window.
This is behavior beyond strange.
BC
Cowboy (Gregory A. Beamer) wrote:
> How much data are you churning in RS? The way to tell is look at how much
> data is actaully returned from the sproc.
> As much as possible, try to filter down your data and do calcs in the sproc,
> not in RS. If you return large data sets to RS, you will churn the machine.
>|||Try returning the aggregates from the stored procedure and see how that
changes things. It could be that your total calculations are causing issue.
I will have to mull over other possibilities.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)
************************************************
Think outside the box!
************************************************
"Blasting Cap" <goober@.christian.net> wrote in message
news:ecQXoO30HHA.4344@.TK2MSFTNGP03.phx.gbl...
> That's just it - the data isn't that much.
> I'm calling a stored procedure with 5 parameters, and it returns 1588 rows
> in Query Analyzer, and runs in 5 seconds there. The only difference in QA
> and the Reportviewer is that I am subtotaling & grand totaling 3 columns.
> If I try to run this from within the ReportViewer, when launching that web
> page, it will run the CPU up to 100% until I kill it. Pages are extremely
> sluggish, and it'll take a minute or two to just go between tabs on those
> 3 pages. I'm doing a Gridview on one tab, that returns about 50 records,
> and a dropdown box on the second tab that returns about 25 records, and
> then this one that I'm doing in the Reportviewer.
> If I take out the reportviewer, the other two pages work as they should,
> in next to no time at all.
> Once I add back the reportviewer, the "e" on the Internet Explorer tab
> flickers and I can watch the CPU usage on the computer go to 100% and stay
> there until I kill the procedure. I can close it out using the X on
> internet explorer, but it takes several minutes for the web browser to
> detect that I've killed the window.
> This is behavior beyond strange.
>
> BC
>
> Cowboy (Gregory A. Beamer) wrote:
>> How much data are you churning in RS? The way to tell is look at how much
>> data is actaully returned from the sproc.
>> As much as possible, try to filter down your data and do calcs in the
>> sproc, not in RS. If you return large data sets to RS, you will churn the
>> machine.|||What happens when you run the report from the web interface using Report
Manager. This will tell you if it is a report issue or an integration issue
with ReportViewer. My guess is that you are telling reportviewer over and
over again to get the report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blasting Cap" <goober@.christian.net> wrote in message
news:ecQXoO30HHA.4344@.TK2MSFTNGP03.phx.gbl...
> That's just it - the data isn't that much.
> I'm calling a stored procedure with 5 parameters, and it returns 1588 rows
> in Query Analyzer, and runs in 5 seconds there. The only difference in QA
> and the Reportviewer is that I am subtotaling & grand totaling 3 columns.
> If I try to run this from within the ReportViewer, when launching that web
> page, it will run the CPU up to 100% until I kill it. Pages are extremely
> sluggish, and it'll take a minute or two to just go between tabs on those
> 3 pages. I'm doing a Gridview on one tab, that returns about 50 records,
> and a dropdown box on the second tab that returns about 25 records, and
> then this one that I'm doing in the Reportviewer.
> If I take out the reportviewer, the other two pages work as they should,
> in next to no time at all.
> Once I add back the reportviewer, the "e" on the Internet Explorer tab
> flickers and I can watch the CPU usage on the computer go to 100% and stay
> there until I kill the procedure. I can close it out using the X on
> internet explorer, but it takes several minutes for the web browser to
> detect that I've killed the window.
> This is behavior beyond strange.
>
> BC
>
> Cowboy (Gregory A. Beamer) wrote:
>> How much data are you churning in RS? The way to tell is look at how much
>> data is actaully returned from the sproc.
>> As much as possible, try to filter down your data and do calcs in the
>> sproc, not in RS. If you return large data sets to RS, you will churn the
>> machine.|||Just for giggles, I did another report, basically taking a product
listing, that would return about 100 records, that had some numeric
fields on it, but I didn't do any summing or totalling.
This report performs the same way when I call it from the reportviewer.
If I go to the website, http://mycomputer/reports$sql2005, and run it,
it takes about 5 seconds to display & you don't get the "flickering" of
the "e" on Internet Explorer like you do when I try to run the same
report from within the report viewer.
How am I telling the reportviewer over & over again to get the report?
The fact that I have no totaling in the report tells me that it's not
the returning of the data that is the problem.
The code that calls the report:
<cc1:TabPanel ID="TabPanel3" runat="server" HeaderText="TabPanel3">
<ContentTemplate>
<rsweb:reportviewer id="ReportViewer1"
runat="server" font-names="Verdana" font-size="8pt"
height="90%" width="90%"
ProcessingMode="Remote">
<ServerReport ReportServerUrl="http://mycomputer/ReportServer$SQL2005/"
ReportPath="/BA10listing"></ServerReport>
</rsweb:reportviewer>
</ContentTemplate>
</cc1:TabPanel>
BC
Bruce L-C [MVP] wrote:
> What happens when you run the report from the web interface using Report
> Manager. This will tell you if it is a report issue or an integration issue
> with ReportViewer. My guess is that you are telling reportviewer over and
> over again to get the report.
>|||I have only used the winform version of the reportviewer control (I assume
you are using the reportviewer control that ships with VS 2005). Somewhere
you have to be responding to an event where you tell the control what report
to render. If you do this over and over again you could be causing it to
thrash.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blasting Cap" <goober@.christian.net> wrote in message
news:OD6qfF60HHA.5380@.TK2MSFTNGP04.phx.gbl...
> Just for giggles, I did another report, basically taking a product
> listing, that would return about 100 records, that had some numeric fields
> on it, but I didn't do any summing or totalling.
>
> This report performs the same way when I call it from the reportviewer.
> If I go to the website, http://mycomputer/reports$sql2005, and run it, it
> takes about 5 seconds to display & you don't get the "flickering" of the
> "e" on Internet Explorer like you do when I try to run the same report
> from within the report viewer.
> How am I telling the reportviewer over & over again to get the report?
> The fact that I have no totaling in the report tells me that it's not the
> returning of the data that is the problem.
> The code that calls the report:
> <cc1:TabPanel ID="TabPanel3" runat="server" HeaderText="TabPanel3">
> <ContentTemplate>
> <rsweb:reportviewer id="ReportViewer1"
> runat="server" font-names="Verdana" font-size="8pt"
> height="90%" width="90%"
> ProcessingMode="Remote">
> <ServerReport ReportServerUrl="http://mycomputer/ReportServer$SQL2005/"
> ReportPath="/BA10listing"></ServerReport>
> </rsweb:reportviewer>
> </ContentTemplate>
> </cc1:TabPanel>
> BC
>
>
> Bruce L-C [MVP] wrote:
>> What happens when you run the report from the web interface using Report
>> Manager. This will tell you if it is a report issue or an integration
>> issue with ReportViewer. My guess is that you are telling reportviewer
>> over and over again to get the report.|||Try the reportviewer control on a simple web page and see if the same thing
happens. I.e. no tabs, just a single simple web page.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blasting Cap" <goober@.christian.net> wrote in message
news:OD6qfF60HHA.5380@.TK2MSFTNGP04.phx.gbl...
> Just for giggles, I did another report, basically taking a product
> listing, that would return about 100 records, that had some numeric fields
> on it, but I didn't do any summing or totalling.
>
> This report performs the same way when I call it from the reportviewer.
> If I go to the website, http://mycomputer/reports$sql2005, and run it, it
> takes about 5 seconds to display & you don't get the "flickering" of the
> "e" on Internet Explorer like you do when I try to run the same report
> from within the report viewer.
> How am I telling the reportviewer over & over again to get the report?
> The fact that I have no totaling in the report tells me that it's not the
> returning of the data that is the problem.
> The code that calls the report:
> <cc1:TabPanel ID="TabPanel3" runat="server" HeaderText="TabPanel3">
> <ContentTemplate>
> <rsweb:reportviewer id="ReportViewer1"
> runat="server" font-names="Verdana" font-size="8pt"
> height="90%" width="90%"
> ProcessingMode="Remote">
> <ServerReport ReportServerUrl="http://mycomputer/ReportServer$SQL2005/"
> ReportPath="/BA10listing"></ServerReport>
> </rsweb:reportviewer>
> </ContentTemplate>
> </cc1:TabPanel>
> BC
>
>
> Bruce L-C [MVP] wrote:
>> What happens when you run the report from the web interface using Report
>> Manager. This will tell you if it is a report issue or an integration
>> issue with ReportViewer. My guess is that you are telling reportviewer
>> over and over again to get the report.|||I tried it in the following ways:
- I took an AJAX enabled web page, and added the reportviewer to it.
Brought up the report, did the same thing - the "flickering" of the "e"
on Internet explorer, acting like the page is loading.
I figured then that it could be that AJAX itself was causing the problem.
- I went in & created just a regular old ASP.NET page. (HTML follows).
It performed exactly the same way as the others, pegging the CPU at
100% until I killed it.
The report itself was a "nothing" report - returned 100 or so records,
no sums, no totals, no formatting.
HTML of the regular aspx page is:
<%@. Page Language="VB" AutoEventWireup="false"
CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div><rsweb:ReportViewer ID="ReportViewer1" runat="server"
Font-Names="Verdana" Font-Size="8pt" Height="400px"
ProcessingMode="Remote" Width="400px">
<ServerReport ReportPath="/BA10listing"
ReportServerUrl="http://mycomputer/ReportServer$SQL2005/" />
</rsweb:ReportViewer>
</div>
</form>
</body>
</html>
I've looked at the properties of it, too.
Under BEHAVIOR:
Enabled = True
EnableTheming = True
EnableViewState = True
Visible = True
Under MISC:
AsyncRendering = True
ExportContentDisposition = OnlyHTMLInline
under LocalReport
EnableExternal Images = False
EnableHyperlinks = False
Processingmode = Remote
Under SERVERREPORT - everything's in there - the report name, the
reportserverURL, that both work.
Under TOOLBAR:
DocumentMapCollapsed = False
ShowbackButton = False
ShowDocumentMapButton = True
ShowExportControls = True
ShowFindControls = True
ShowPageNavigationControls = True
ShowPrintButton = True
ShowPromptAreaButton = True
Show RefreshButton = True
ShowZoomControl = True
I don't see anything that "obviously" would make it refresh/hang like it
does.
Using VS 2005, Windows XP. It performs the same way whether I connect
to the local box(my computer) with both SQL 2000 & SQL 2005 on it, or to
a remote box with both on it too.
Any help, suggestions appreciated.
Thanks,
BC
Bruce L-C [MVP] wrote:
> Try the reportviewer control on a simple web page and see if the same thing
> happens. I.e. no tabs, just a single simple web page.
>|||Again, note that I have only used this with Winform control not webform
control. A couple of things to try. Try turning async off. Next, don't have
the report hardcoded. Instead, put a button that sets the report name and
other information (just as a test)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blasting Cap" <goober@.christian.net> wrote in message
news:%233ryDeE1HHA.5360@.TK2MSFTNGP03.phx.gbl...
>I tried it in the following ways:
> - I took an AJAX enabled web page, and added the reportviewer to it.
> Brought up the report, did the same thing - the "flickering" of the "e" on
> Internet explorer, acting like the page is loading.
> I figured then that it could be that AJAX itself was causing the problem.
> - I went in & created just a regular old ASP.NET page. (HTML follows).
> It performed exactly the same way as the others, pegging the CPU at 100%
> until I killed it.
> The report itself was a "nothing" report - returned 100 or so records, no
> sums, no totals, no formatting.
> HTML of the regular aspx page is:
> <%@. Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb"
> Inherits="_Default" %>
> <%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0,
> Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
> Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
> <html xmlns="http://www.w3.org/1999/xhtml" >
> <head runat="server">
> <title>Untitled Page</title>
> </head>
> <body>
> <form id="form1" runat="server">
> <div><rsweb:ReportViewer ID="ReportViewer1" runat="server"
> Font-Names="Verdana" Font-Size="8pt" Height="400px"
> ProcessingMode="Remote" Width="400px">
> <ServerReport ReportPath="/BA10listing"
> ReportServerUrl="http://mycomputer/ReportServer$SQL2005/" />
> </rsweb:ReportViewer>
> </div>
> </form>
> </body>
> </html>
>
> I've looked at the properties of it, too.
> Under BEHAVIOR:
> Enabled = True
> EnableTheming = True
> EnableViewState = True
> Visible = True
> Under MISC:
> AsyncRendering = True
> ExportContentDisposition = OnlyHTMLInline
> under LocalReport
> EnableExternal Images = False
> EnableHyperlinks = False
> Processingmode = Remote
> Under SERVERREPORT - everything's in there - the report name, the
> reportserverURL, that both work.
> Under TOOLBAR:
> DocumentMapCollapsed = False
> ShowbackButton = False
> ShowDocumentMapButton = True
> ShowExportControls = True
> ShowFindControls = True
> ShowPageNavigationControls = True
> ShowPrintButton = True
> ShowPromptAreaButton = True
> Show RefreshButton = True
> ShowZoomControl = True
> I don't see anything that "obviously" would make it refresh/hang like it
> does.
> Using VS 2005, Windows XP. It performs the same way whether I connect to
> the local box(my computer) with both SQL 2000 & SQL 2005 on it, or to a
> remote box with both on it too.
> Any help, suggestions appreciated.
> Thanks,
> BC
>
> Bruce L-C [MVP] wrote:
>> Try the reportviewer control on a simple web page and see if the same
>> thing happens. I.e. no tabs, just a single simple web page.|||I tried turning off Async, and it didn't make any difference.
On the page (plain old dot net aspx page), what I've found out is that
it will load and act normally, but as soon as the page has been
rendered, it starts the clocking behavior. When you try to move the
scrollbars on the report, etc. it takes a long time to get them to
respond. And when they do, they immediately go back to maxing out the
CPU.
I tried the suggestion of putting a button that sets the report name,
and it didn't make any difference. Code is below.
What happened was that when I ran the page, with the
reportviewer1.visible = false, only the button rendered and the web page
was fine - it wasn't hanging the CPU. I hit the button, and it performs
exactly as I indicated earlier. It displays the report, and it pegs the
CPU at 100% and stays that way until I kill the page.
Here's the code in the codefile:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
Me.ReportViewer1.Visible = False
End If
ReportViewer1.ServerReport.ReportPath = ""
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Button1.Click
ReportViewer1.Visible = True
ReportViewer1.ServerReport.ReportPath = "/BA10listing"
End Sub
The code in the aspx part of the page:
<%@. Page Language="VB" AutoEventWireup="false"
CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="Button1" runat="server" Text="Button" />
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
Font-Names="Verdana" Font-Size="8pt" Height="400px"
ProcessingMode="Remote" Width="400px" AsyncRendering="False"
ShowDocumentMapButton="False">
<ServerReport ReportPath="/BA10listing"
ReportServerUrl="http://mycomputer/ReportServer$SQL2005/" />
</rsweb:ReportViewer>
</div>
</form>
</body>
</html>
... so you can see there's a lot going on here. The report returns
~100 records or so, no calculations, no summation, no grand totals.
Basically a "nothing" report, just listing product info data. Both the
IIS and the reportserver are on my computer.
In SQL Reporting Services in the web browser, this report displays fine,
no problems. It's only when I call it from the Reportviewer inside a
web page that it hangs.
Any ideas? Anyone?
BC
Bruce L-C [MVP] wrote:
> Again, note that I have only used this with Winform control not webform
> control. A couple of things to try. Try turning async off. Next, don't have
> the report hardcoded. Instead, put a button that sets the report name and
> other information (just as a test)
>|||I suggest posting this to the web based forums. I know the other MVP hangs
out there and he has used this control a lot. I suggest putting reportviewer
control in the subject.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blasting Cap" <goober@.christian.net> wrote in message
news:eewpPgH1HHA.4652@.TK2MSFTNGP05.phx.gbl...
> I tried turning off Async, and it didn't make any difference.
> On the page (plain old dot net aspx page), what I've found out is that it
> will load and act normally, but as soon as the page has been rendered, it
> starts the clocking behavior. When you try to move the scrollbars on the
> report, etc. it takes a long time to get them to respond. And when they
> do, they immediately go back to maxing out the CPU.
> I tried the suggestion of putting a button that sets the report name, and
> it didn't make any difference. Code is below.
> What happened was that when I ran the page, with the reportviewer1.visible
> = false, only the button rendered and the web page was fine - it wasn't
> hanging the CPU. I hit the button, and it performs exactly as I indicated
> earlier. It displays the report, and it pegs the CPU at 100% and stays
> that way until I kill the page.
> Here's the code in the codefile:
> Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles MyBase.Load
> If Not Page.IsPostBack Then
> Me.ReportViewer1.Visible = False
> End If
> ReportViewer1.ServerReport.ReportPath = ""
> End Sub
> Protected Sub Button1_Click(ByVal sender As Object, ByVal e As
> System.EventArgs) Handles Button1.Click
> ReportViewer1.Visible = True
> ReportViewer1.ServerReport.ReportPath = "/BA10listing"
> End Sub
> The code in the aspx part of the page:
> <%@. Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb"
> Inherits="_Default" %>
> <%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0,
> Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
> Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
> <html xmlns="http://www.w3.org/1999/xhtml" >
> <head runat="server">
> <title>Untitled Page</title>
> </head>
> <body>
> <form id="form1" runat="server">
> <div>
> <asp:Button ID="Button1" runat="server" Text="Button" />
> <rsweb:ReportViewer ID="ReportViewer1" runat="server"
> Font-Names="Verdana" Font-Size="8pt" Height="400px"
> ProcessingMode="Remote" Width="400px" AsyncRendering="False"
> ShowDocumentMapButton="False">
> <ServerReport ReportPath="/BA10listing"
> ReportServerUrl="http://mycomputer/ReportServer$SQL2005/" />
> </rsweb:ReportViewer>
>
> </div>
> </form>
> </body>
> </html>
>
> ... so you can see there's a lot going on here. The report returns ~100
> records or so, no calculations, no summation, no grand totals. Basically a
> "nothing" report, just listing product info data. Both the IIS and the
> reportserver are on my computer.
> In SQL Reporting Services in the web browser, this report displays fine,
> no problems. It's only when I call it from the Reportviewer inside a web
> page that it hangs.
> Any ideas? Anyone?
> BC
>
>
> Bruce L-C [MVP] wrote:
>> Again, note that I have only used this with Winform control not webform
>> control. A couple of things to try. Try turning async off. Next, don't
>> have the report hardcoded. Instead, put a button that sets the report
>> name and other information (just as a test)

ASP.NET Problem installing SQL Server 2000 Reporting Services

I am trying to install SQL Server 2000 Reporting Services on a machine with Windows Server 2003. It keeps telling me ASP.NET is not installed or not configured with the web server. I have registered it with IIS using "C:\Windows\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.ex
e -i" and I have installed all necessary updates and restarted the server. I've even set ASP.NET version 1.1.4322 as the default version on the Default Web Site. It is still claiming that it's not installed or not configured.

I checked the help and it says:

Report Manager is an ASP.NET application. If you are installing Report Manager, you must have ASP.NET installed and configured. Setup requires that version 1.1.4322 of ASP.NET be registered with IIS. If you are installing Reporting Services on Windows Server 2003, ASP.NET must be running as Network Service. For information about installing and configuring ASP.NET, see the setup documentation

As far as I can tell, ASP.NET 1.1.4322 is installed and configured and running as the user Network Service. Am I missing anything?

If you have not done actual Asp.net development in this box you are missing a lot because Win2003 comes with IIS not installed and when you install it IIS comes to just render HTML which means all components needed to run Asp.net are disabled. Now to how you fix it first remove IIS if it is installed, then you go to add it in add/remove Windows component add IIS then click on details in that box you will see all the sub components needed to run Asp.net that are disabled. When you have finished that, go into IIS and remove all the security restrictions that makes IIS to run only HTML.

Now to what you need to get SQL Server to install Reporting services 2000 make sure you are running SQL Server 2000 and have at least service pack 3a or 4 and please don't answer questions Windows ask you during the installation only answer questions relevant to you. Post again if you still need help but follow my instructions and you will get through I just helped two people with similar problems.

|||I tried that and didn't quite get there. I uninstalled the .net framework 2.0 as that was the default version on IIS and I don't think anything was using it. I also ran aspnet_ regiis.exe -i -enable.

It would have installed this morning but for the fact that SQL Server needed SP4 installing and everyone got in to work before I could get stuff installed!

ASP.NET 2.0 and SQL Reporting Services

I am running SQL Server 2000 and would like to utilize the SQL Server Reporting services I have heard so much about. How can I do this in Visual Studio 2005? If you install the 2000 Reporting Services it says the Report Designer requires 2003 of VS. I would like to use it in 2005 though. Anyone do this? I can't imagine I am the only one. ;)Yes, I'm having the same need. I'm using the VS 2005 Beta2.|||

You can add RS reports to an existing project; Select "Add New Item" to the project then select "Report" they now have a file ext of RDLC.
btw, it is only available on VS 2005 Developer and up, read more...http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

asp.net 2.0 / RS update

Is there a reporting services for asp.net 2.0?
We recently converted our web app to .NET 2.0 and the reportserver runs as a
subweb.
Can the 2 reportserver subwebs run as 2.0 or is there an upgrade available
from Microsoft?
Thanks.RS 2000 is a 1.1 app. You can run both 1.1 and 2.0 on the same web server.
However, if you want everything using the 2.0 framework then upgrade to RS
2005 (requires the SQL Server 2005 license). When upgrading you can leave
the database as 2000 and just upgrade Reporting Services if you want to
(still need the license though). I found noticeable performance improvement
(probably because of being based on the 2.0 framework) when I upgraded.
Definitely snappier.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <cmill575@.hotmail.com> wrote in message
news:ehH1QuxFGHA.724@.TK2MSFTNGP10.phx.gbl...
> Is there a reporting services for asp.net 2.0?
> We recently converted our web app to .NET 2.0 and the reportserver runs as
> a subweb.
> Can the 2 reportserver subwebs run as 2.0 or is there an upgrade available
> from Microsoft?
> Thanks.
>|||Thanks for your response.
I'll probably just view reports within my webapp using the VS 2005 tools to
open the .rdl directly instead of using the reportserver/reportmanager
subwebs.
I never liked the subweb approach anyway.
Thanks again.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OMnUl1yFGHA.2084@.TK2MSFTNGP09.phx.gbl...
> RS 2000 is a 1.1 app. You can run both 1.1 and 2.0 on the same web server.
> However, if you want everything using the 2.0 framework then upgrade to RS
> 2005 (requires the SQL Server 2005 license). When upgrading you can leave
> the database as 2000 and just upgrade Reporting Services if you want to
> (still need the license though). I found noticeable performance
> improvement (probably because of being based on the 2.0 framework) when I
> upgraded. Definitely snappier.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chris" <cmill575@.hotmail.com> wrote in message
> news:ehH1QuxFGHA.724@.TK2MSFTNGP10.phx.gbl...
>> Is there a reporting services for asp.net 2.0?
>> We recently converted our web app to .NET 2.0 and the reportserver runs
>> as a subweb.
>> Can the 2 reportserver subwebs run as 2.0 or is there an upgrade
>> available from Microsoft?
>> Thanks.
>>
>|||Before you decide to abandon the server based product, do a test. It is not
as simple as you might think. Subreports get more complicated, jump to
report, etc. There is a lot you have to handle yourself.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <cmill575@.hotmail.com> wrote in message
news:%23p3INy2FGHA.2084@.TK2MSFTNGP09.phx.gbl...
> Thanks for your response.
> I'll probably just view reports within my webapp using the VS 2005 tools
> to open the .rdl directly instead of using the reportserver/reportmanager
> subwebs.
> I never liked the subweb approach anyway.
> Thanks again.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OMnUl1yFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> RS 2000 is a 1.1 app. You can run both 1.1 and 2.0 on the same web
>> server. However, if you want everything using the 2.0 framework then
>> upgrade to RS 2005 (requires the SQL Server 2005 license). When upgrading
>> you can leave the database as 2000 and just upgrade Reporting Services if
>> you want to (still need the license though). I found noticeable
>> performance improvement (probably because of being based on the 2.0
>> framework) when I upgraded. Definitely snappier.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Chris" <cmill575@.hotmail.com> wrote in message
>> news:ehH1QuxFGHA.724@.TK2MSFTNGP10.phx.gbl...
>> Is there a reporting services for asp.net 2.0?
>> We recently converted our web app to .NET 2.0 and the reportserver runs
>> as a subweb.
>> Can the 2 reportserver subwebs run as 2.0 or is there an upgrade
>> available from Microsoft?
>> Thanks.
>>
>>
>

ASP.NET 1.1 Component for creating pivote tables with MS SQL Server and with MS SQL Server

Превед!

Prompt me please some asp.net 1.1 pivote table component that can use both SQL Server database (SQL queries) and Analyse Services database (MDX queries).

Thanks.

I have two links one is for 1.1 or 2.0 and the other is 2.0 and 3.0. Hope this helps.

http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en
http://sqljunkies.com/WebLog/mosha/archive/2006/10/08/xaml_pivottable.aspx

|||

Thanks, but this links about Windows components. And I need asp.net component.

|||

Try these.

http://www.microsoft.com/downloads/details.aspx?familyid=4599B793-B3C6-4ED5-ACB3-820D0E832151&displaylang=en

http://www.mosha.com/msolap/util.htm#ExcelAddIns

ASP.NET 1.1 & Authz

Hi,
At the begining of SQL Reporting Services Installation, windows let me know
that it left have ASP.NET 1.1 and Authz installed.
Can somebody tell me please the links to downloads them, as i can´t find
them in the microsoft web.
Regards & Thank youASP.NET 1.1 Redistributable Package can be found here:
http://www.microsoft.com/downloads/details.aspx?familyid=262d25e3-f589-4842-8157-034d1e7cf3a3&displaylang=en
Regards
Kevin Weir
"Claudio" wrote:
> Hi,
> At the begining of SQL Reporting Services Installation, windows let me know
> that it left have ASP.NET 1.1 and Authz installed.
> Can somebody tell me please the links to downloads them, as i can´t find
> them in the microsoft web.
> Regards & Thank you
>|||...and i got my Authz.dll from here:
http://www.dll-files.com/dllindex/dll-files.shtml?authz
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4925
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=01afe39f8a3a4e0c83286fceeae170e0
*****************************************|||Hi Kevin,
I have already installed the last Framework version.
I still having the same problem when i try to install SQL Services reporting.
Regards,
Claudio
"Kevin Weir" wrote:
> ASP.NET 1.1 Redistributable Package can be found here:
> http://www.microsoft.com/downloads/details.aspx?familyid=262d25e3-f589-4842-8157-034d1e7cf3a3&displaylang=en
> Regards
> Kevin Weir
>
> "Claudio" wrote:
> > Hi,
> > At the begining of SQL Reporting Services Installation, windows let me know
> > that it left have ASP.NET 1.1 and Authz installed.
> > Can somebody tell me please the links to downloads them, as i can´t find
> > them in the microsoft web.
> >
> > Regards & Thank you
> >
> >|||Jared,
Before your advise i already downloaded & installed the Authz from
www.dll-files
and getting the same message when i tried to install SQL Server Reporting.
Regards,
Claudio
"Jared Smith via SQLMonster.com" wrote:
> ...and i got my Authz.dll from here:
> http://www.dll-files.com/dllindex/dll-files.shtml?authz
> *****************************************
> * A copy of the whole thread can be found at:
> * http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4925
> *
> * Report spam or abuse by clicking the following URL:
> * http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=01afe39f8a3a4e0c83286fceeae170e0
> *****************************************
>|||Hi Claudio,
Claudio wrote:
> At the begining of SQL Reporting Services Installation, windows let
> me know that it left have ASP.NET 1.1 and Authz installed.
> Can somebody tell me please the links to downloads them, as i can´t
> find them in the microsoft web.
If you are running Windows 2000 Server, make sure you have the latest SP
installed. If you do have the latest SP installed, you should reapply it
(and reapply any patches since that SP). Once you (re)apply the SP, authz
should be available.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Hi there,
Where did you put the authz.dll file? You need to copy it across to the C:\WINDOWS\system32 folder...
If this doesn;t work, I am out of ideas...
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4925
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=be5885cc4f204998adc0cdc65f958d09
*****************************************|||Hi Jake,
I am running Windows 2000 profesional, with SQL Developer and SQL Service
pack 3a, it´s the same configuration that i had in my old laptop that worked
ok.
I will try installing patches again and see.
Regards & Thank you
Claudio
"Jake Marx" wrote:
> Hi Claudio,
> Claudio wrote:
> > At the begining of SQL Reporting Services Installation, windows let
> > me know that it left have ASP.NET 1.1 and Authz installed.
> > Can somebody tell me please the links to downloads them, as i can´t
> > find them in the microsoft web.
> If you are running Windows 2000 Server, make sure you have the latest SP
> installed. If you do have the latest SP installed, you should reapply it
> (and reapply any patches since that SP). Once you (re)apply the SP, authz
> should be available.
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>|||Claudio I believe you need to have the latest Win 2000 service pack installed
as well.
"Claudio" wrote:
> Hi Jake,
> I am running Windows 2000 profesional, with SQL Developer and SQL Service
> pack 3a, it´s the same configuration that i had in my old laptop that worked
> ok.
> I will try installing patches again and see.
> Regards & Thank you
> Claudio
> "Jake Marx" wrote:
> > Hi Claudio,
> >
> > Claudio wrote:
> > > At the begining of SQL Reporting Services Installation, windows let
> > > me know that it left have ASP.NET 1.1 and Authz installed.
> > > Can somebody tell me please the links to downloads them, as i can´t
> > > find them in the microsoft web.
> >
> > If you are running Windows 2000 Server, make sure you have the latest SP
> > installed. If you do have the latest SP installed, you should reapply it
> > (and reapply any patches since that SP). Once you (re)apply the SP, authz
> > should be available.
> >
> > --
> > Regards,
> >
> > Jake Marx
> > MS MVP - Excel
> > www.longhead.com
> >
> > [please keep replies in the newsgroup - email address unmonitored]
> >
> >|||Kevin,
Even that i have installed W2K SP4 i will reinstall again, let you know.
Regards
Claudio
"Kevin Weir" wrote:
> Claudio I believe you need to have the latest Win 2000 service pack installed
> as well.
>
> "Claudio" wrote:
> > Hi Jake,
> > I am running Windows 2000 profesional, with SQL Developer and SQL Service
> > pack 3a, it´s the same configuration that i had in my old laptop that worked
> > ok.
> >
> > I will try installing patches again and see.
> >
> > Regards & Thank you
> >
> > Claudio
> >
> > "Jake Marx" wrote:
> >
> > > Hi Claudio,
> > >
> > > Claudio wrote:
> > > > At the begining of SQL Reporting Services Installation, windows let
> > > > me know that it left have ASP.NET 1.1 and Authz installed.
> > > > Can somebody tell me please the links to downloads them, as i can´t
> > > > find them in the microsoft web.
> > >
> > > If you are running Windows 2000 Server, make sure you have the latest SP
> > > installed. If you do have the latest SP installed, you should reapply it
> > > (and reapply any patches since that SP). Once you (re)apply the SP, authz
> > > should be available.
> > >
> > > --
> > > Regards,
> > >
> > > Jake Marx
> > > MS MVP - Excel
> > > www.longhead.com
> > >
> > > [please keep replies in the newsgroup - email address unmonitored]
> > >
> > >|||Claudio wrote:
>> Claudio I believe you need to have the latest Win 2000 service pack
>> installed as well.
> Even that i have installed W2K SP4 i will reinstall again, let you
> know.
Yes. I ran into this on one server that already had SP4 installed.
Refreshing that SP and reinstalling hotfixes/patches did the trick.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]]