Forms Authentication in RS 2005
Hello,
Does forms authentication in RS 2005 require Enterprise edition like RS 2000
or will the Standard edition work now?
I heard that RS 2000 SP2 would allow forms auth with the Standard edition,
but still get this message when trying to use it. "This operation is not
supported in this edition of Reporting Services (rsOperationNotSupported)"
Thanks in advance for any info you can provide. Tag: Q: deploying report into a folder Tag: 45083
Upgrade to 2005, linked reports fail?
I just upgraded my SSRS server to version 2005. Then, I converted my
report project in Visual Studio 2005, and re-deployed. Everything works
fine except for linked reports.
In the Report Manager, I have a directory that contains several reports
for our end-users. This directory is only available to me. I link each
report to the My Reports directory for those users who can access any
given report. In SQL RS 2000, this was working perfectly.
After the upgrade, the user cannot run any of the linked reports in his
My Reports directory, and he gets this error message:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'MyDB'.
(rsErrorOpeningConnection)
For more information about this error navigate to the report server on
the local server machine, or enable remote errors
Now, obviously this error message is telling me that the linked report
cannot find the datasource MyDB, which is my database. Yet, if I run
the report directly from the original folder, it runs correctly.
I have tried deleting the linked report and then re-adding it, but I
get the same error message. Is there something different you have to do
in SQL RS 2005 to link a report? Tag: Q: deploying report into a folder Tag: 45080
chart inside table header
I would like to have a chart be placed on every page of a report. When
I place the chart in a table header and set the header to be displayed
on everypage it halfway works.
The web display is broken with an error from DundasWebChart saying
cannot add chart area because it already exists.
Exporting works perfectly and the chart is displayed correctly on
everypage.
Thoughts? Ideas? Tag: Q: deploying report into a folder Tag: 45077
Report filtered on User
Hi,
In reporting services is it possible to filter tables on logonUser in a
query?
Like : select * from adress where LastName = longonuser
What is the syntax exactly ?
In my example, longonuser is the login of the user who logged Report server
on HTTP (Login and Password)
Thanks for your help
Bertrand Burquier Tag: Q: deploying report into a folder Tag: 45073
Rowcount as global variable
Hi,
Does anybody know how can we get the total row counts like TotalPages global
variable in SSRS 2005 STD? I need to print report total rows on first page
of report.
Thanks Tag: Q: deploying report into a folder Tag: 45070
RS Reinstall Problem
Hi All:
I recently had to rebuild a server that had a functioning version of RS
running on it because we ran out of space on our C Drive. We rebuilt the
server and installed RS on it and point the virtual directories to the proper
locations.
When I try to browse the site from within IIS, I get an ASP page error
indicating a problem on line 16.
Here is the body of the message.
Line 14: <compilation defaultLanguage="c#" debug="true"/>
Line 15: <customErrors mode="Off"/>
Line 16: <authentication mode="Windows"/>
Line 17: <identity impersonate="true"/>
Line 18: <trace enabled="false" requestLimit="10" pageOutput="false"
traceMode="SortByTime" localOnly="true"/>
It looks like there is some type of permissions issue. I checked the
permissions on the website, the virtual directories and the RS directories
and they all seem ok.
Our path to the RS home page is //IPADDress of server/reports.
If anyone can shed some light on this issue, I'd appreciate it. Tag: Q: deploying report into a folder Tag: 45067
Group by Month/Week/Day in DateTime Field?
Crystal Reports has the ability to group by datetime based on
month/week/daily basis in DateTime field. Can Reporting Server do this? Tag: Q: deploying report into a folder Tag: 45066
Subreport running totals
I have a report comfigured to pull a sub report. This report is unique in
that it is going into 2 seperate databases on different servers to grab
data. When my report loads, ceratin customer numbers are loaded into the
dataset. In my table I have a subreport with an input parameter which loads
additional data. My boss asked that I have totals at the end. I cannot do
this in the subreport as it gets included many times in the report. Is there
a way to pull values out of a subreport such as using output parameters?
There are 5 items in each sub report that I need to total at the end. If
data can be taken out using output parameters can I store that in a global
variable or somewhere else? Tag: Q: deploying report into a folder Tag: 45064
RS2005 Local/Remote SMTP for report attachments
Sending report without attachments works fine. However, when sending reports
with attachments, failure occures.
It has been several weeks attempting to get support on this matter. Could
someone direct me to an online or phone support for this matter.
Thank you very much for your assistance.
EVENT LOG INFORMATION:
==========================================
Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 529
Date: 11/30/2005
Time: 10:49:03 AM
User: NT AUTHORITY\SYSTEM (how do I extend this user access to the
report services database?)
Computer: REPORTSERV
Description:
Logon Failure:
Reason: Unknown user name or bad password
User Name:
Domain:
Logon Type: 3
Logon Process: Authz
Authentication Package: Kerberos
Workstation Name: REPORTSERV
Caller User Name: NETWORK SERVICE
Caller Domain: NT AUTHORITY
Caller Logon ID: (0x0,0x3E4)
Caller Process ID: 5928
Transited Services: -
Source Network Address: -
Source Port: -
RS LOG:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
9.00.1314.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Standard Time</TimeZone>
<Path>E:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\LogFiles\ReportServerService__12_01_2005_10_54_17.log</Path>
<SystemName>WARDTESERV</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
MemoryLimit to '70' percent as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
MaximumMemoryLimit to '90' percent as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
because it was not specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
WatsonDumpOnExceptions to
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/1/2005-10:54:19:: i INFO: Initializing
WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!12/1/2005-10:54:20:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!4!12/1/2005-10:54:20:: i INFO:
Evaluation copy: 300 days left
ReportingServicesService!runningjobs!4!12/1/2005-10:54:20:: i INFO: Database
Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600
seconds
ReportingServicesService!runningjobs!4!12/1/2005-10:54:20:: i INFO: Running
Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!12/1/2005-10:54:20:: i INFO: Running
Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!12/1/2005-10:54:20:: i INFO:
Execution Log Entry Expiration timer enabled: Next Event: 54339 seconds.
Cycle: 86400 seconds
ReportingServicesService!runningjobs!4!12/1/2005-10:54:20:: i INFO: Memory
stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!12/1/2005-10:54:20:: i INFO: SQM
timer timer enabled: Next Event: 57939 seconds. Cycle: 86400 seconds
ReportingServicesService!library!8!12/1/2005-10:54:23:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!crypto!8!12/1/2005-10:54:23:: i INFO: Initializing
crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!8!12/1/2005-10:54:23:: i INFO: Exporting
public key
ReportingServicesService!crypto!8!12/1/2005-10:54:23:: i INFO: Performing
sku validation
ReportingServicesService!crypto!8!12/1/2005-10:54:23:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!8!12/01/2005-10:54:23:: EventPolling
polling service started
ReportingServicesService!dbpolling!8!12/01/2005-10:54:23::
NotificationPolling polling service started
ReportingServicesService!dbpolling!8!12/01/2005-10:54:23:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!8!12/01/2005-10:54:23:: UpgradePolling
polling service started
ReportingServicesService!dbpolling!a!12/1/2005-10:54:23:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!b!12/1/2005-10:54:23::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!c!12/1/2005-10:54:23:: Polling started
ReportingServicesService!library!4!12/1/2005-11:04:26:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!12/1/2005-11:14:25:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs, 0 persisted streams Tag: Q: deploying report into a folder Tag: 45060
PDF Export Fails with HTTP Compression On
I have an issue where my users are unable to export to PDF using reporting
services. After selecting PDF and clicking the export link, it appears that
the process is working but the PDF is never returned. After some trial and
error we discovered that by turning off HTTP Compression we were able to get
the PDFs to generate correctly. Has anyone else run across this and
determined a root cause or some way we can have HTTP compression turned back
on and still generate PDFs with reporting services? Thanks.
--
Richard T. Henry
Lewisberry, PA, USA Tag: Q: deploying report into a folder Tag: 45059
The report server installation is not initialized
We have two web servers which are the part of Clustering (Network load
balancing is running on these servers) and a database server.
All the systems are in the same Domain. On the target SQL Server, We
have created a new domain User named "WebFarmUser" and gave the
User permission to login to the Reporting Services database. We have
assigned that user to the RSExec User Role.
During Reporting Services Installation we specified this SQL Server
instance with the WebFarmUser Account. After this we were prompted to
join the web farm in which we have specified the IP address of existing
Reporting Server.
We have also tried to reconfigure the existing Reporting Services
configuration. For this we have use the RSConfig Utility as follows
RSConfig -c -s <Server Hosting RS DB> -d <RS Database Name> -a
Windows -u <Domain\User Name> -p <Password>.
We enabled the account we just specified to login to Server with
access to the Report Server and ReportServerTempDB Databases. We also
made this account a member of RS Exec Role in both the ReportServer &
ReportServerTempDB databases
After this we restarted the IIS and Report Server Windows Service on
the Machine running on the second Instance of Reporting Service. We
then tried to call up the Report Server in the Browser which gave the
error of "Report Server installation is not initialized". We tried
to activate this machine in the Web Farm by executing the command from
Web Server 1 RSActivate -m <Machine To Be Added > - u <Administrator
User> -p <Password>
Even after this, trying to access the Report Server in the Browser did
not solve the error.
The logs are appended at the end.
Thanks
- Sankalp
PS:
On Web Server 1 we have installed the Reporting Service successfully.
But when we install the Reporting Service on the Web Server 2, it is
giving error after the completion of setup
"Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivated
Exception: - The report server installation is not initialized".
We have used RSActivate tool, "RSActivate -c "Path of Report
Service" -t,
RSKeyMgmt tool, "RSKeyMgmt -r <InstallationId>"
Added the Report Server User in the Report Server database and granted
the RSExec permission to that User.
ReportServerWebApp_Timestamp.log:
w3wp!library!d90!12/5/2005-07:35:54:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
w3wp!library!d90!12/5/2005-07:35:54:: i INFO: Initializing
MaxScheduleWait to default value of '1' second(s) because it was not
specified in Configuration file.
w3wp!library!d90!12/5/2005-07:35:54:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was
not specified in Configuration file.
w3wp!library!d90!12/5/2005-07:35:54:: i INFO: Initializing InstanceName
to default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!d90!12/5/2005-07:35:54:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not
specified in Configuration file.
w3wp!library!d90!12/5/2005-07:35:54:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s)
because it was not specified in Configuration file.
w3wp!library!d90!12/5/2005-07:35:54:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!d90!12/5/2005-07:35:54:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was
not specified in Configuration file.
w3wp!library!d90!12/5/2005-07:35:54:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was
not specified in Configuration file.
w3wp!library!d90!12/5/2005-07:35:54:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not
specified in Configuration file.
w3wp!library!d90!12/5/2005-07:35:54:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!ui!d90!12/5/2005-07:36:14:: e ERROR:
System.Web.Services.Protocols.SoapException: The report server
installation is not initialized. Check the documentation for more
information. --->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information. --->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
mainError, Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
Int32 clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
--- End of inner exception stack trace ---
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at
Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at
Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
pathTranslator, String userSuppliedPath, String parameterName)
at
Microsoft.ReportingServices.Library.RSService.GetPermissions(String
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
--- End of inner exception stack trace ---
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
w3wp!ui!d90!12/5/2005-07:36:15:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: The report server
installation is not initialized. Check the documentation for more
information. --->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information. --->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
mainError, Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
Int32 clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
--- End of inner exception stack trace ---
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at
Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at
Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
pathTranslator, String userSuppliedPath, String parameterName)
at
Microsoft.ReportingServices.Library.RSService.GetPermissions(String
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
--- End of inner exception stack trace ---
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
Item)
at
Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String
Item)
at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
at Microsoft.ReportingServices.UI.Permissions..ctor(String path)
at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String
itemPath)
at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object
sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!d90!12/5/2005-07:36:20:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
ReportServer_Timestamp.log:
w3wp!webserver!384!12/5/2005-07:36:04:: i INFO: Reporting Web Server
started
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
ConnectionType to '1' as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
IsEventService to 'True' as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing MemoryLimit
to '60' percent as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing RecycleTime
to '720' minute(s) as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration
file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration
file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing InstanceName
to 'MSSQLSERVER' as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration
file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration
file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!384!12/5/2005-07:36:04:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!resourceutilities!384!12/5/2005-07:36:05:: i INFO: Running on 2
physical processors, 2 logical processors
w3wp!resourceutilities!384!12/5/2005-07:36:05:: i INFO: Reporting
Services starting SKU: Enterprise
w3wp!runningjobs!384!12/5/2005-07:36:05:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
w3wp!runningjobs!384!12/5/2005-07:36:05:: i INFO: Running Requests
Scavenger timer enabled: Cycle: 60 seconds
w3wp!runningjobs!384!12/5/2005-07:36:05:: i INFO: Running Requests DB
timer enabled: Cycle: 60 seconds
w3wp!runningjobs!384!12/5/2005-07:36:05:: i INFO: Memory stats update
timer enabled: Cycle: 60 seconds
w3wp!library!384!12/05/2005-07:36:09:: i INFO: Call to GetPermissions:/
w3wp!crypto!384!12/05/2005-07:36:09:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!384!12/05/2005-07:36:09:: i INFO: Exporting public key
w3wp!crypto!384!12/05/2005-07:36:09:: w WARN: Web Service not activated
w3wp!crypto!384!12/05/2005-07:36:09:: i INFO: Client is a local admin.
Activating web service via RPC.
w3wp!library!384!12/05/2005-07:36:09:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information. --->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
mainError, Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
Int32 clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
--- End of inner exception stack trace ---
w3wp!library!2a8!12/05/2005-07:36:19:: i INFO: Call to
GetSystemPermissions
w3wp!crypto!2a8!12/05/2005-07:36:19:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/05/2005-07:36:19:: i INFO: Exporting public key
w3wp!crypto!2a8!12/05/2005-07:36:19:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/05/2005-07:36:19:: i INFO: Client is a local admin.
Activating web service via RPC.
w3wp!library!2a8!12/05/2005-07:36:19:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information. --->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
mainError, Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
Int32 clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
--- End of inner exception stack trace ---
w3wp!crypto!2a8!12/5/2005-07:37:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:37:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:37:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:37:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:37:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!384!12/5/2005-07:38:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!384!12/5/2005-07:38:05:: i INFO: Exporting public key
w3wp!crypto!384!12/5/2005-07:38:05:: w WARN: Web Service not activated
w3wp!crypto!384!12/5/2005-07:38:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!384!12/5/2005-07:38:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-07:39:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:39:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:39:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:39:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:39:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-07:40:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:40:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:40:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:40:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:40:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-07:41:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:41:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:41:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:41:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:41:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-07:42:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:42:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:42:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:42:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:42:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!d90!12/5/2005-07:43:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!d90!12/5/2005-07:43:05:: i INFO: Exporting public key
w3wp!crypto!d90!12/5/2005-07:43:05:: w WARN: Web Service not activated
w3wp!crypto!d90!12/5/2005-07:43:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!d90!12/5/2005-07:43:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-07:44:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:44:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:44:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:44:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:44:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!d90!12/5/2005-07:45:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!d90!12/5/2005-07:45:05:: i INFO: Exporting public key
w3wp!crypto!d90!12/5/2005-07:45:05:: w WARN: Web Service not activated
w3wp!crypto!d90!12/5/2005-07:45:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!d90!12/5/2005-07:45:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!384!12/5/2005-07:46:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!384!12/5/2005-07:46:05:: i INFO: Exporting public key
w3wp!crypto!384!12/5/2005-07:46:05:: w WARN: Web Service not activated
w3wp!crypto!384!12/5/2005-07:46:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!384!12/5/2005-07:46:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-07:46:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:46:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:46:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:46:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:46:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-07:47:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:47:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:47:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:47:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:47:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!d90!12/5/2005-07:48:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!d90!12/5/2005-07:48:05:: i INFO: Exporting public key
w3wp!crypto!d90!12/5/2005-07:48:05:: w WARN: Web Service not activated
w3wp!crypto!d90!12/5/2005-07:48:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!d90!12/5/2005-07:48:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!d90!12/5/2005-07:49:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!d90!12/5/2005-07:49:05:: i INFO: Exporting public key
w3wp!crypto!d90!12/5/2005-07:49:05:: w WARN: Web Service not activated
w3wp!crypto!d90!12/5/2005-07:49:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!d90!12/5/2005-07:49:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!384!12/5/2005-07:50:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!384!12/5/2005-07:50:05:: i INFO: Exporting public key
w3wp!crypto!384!12/5/2005-07:50:05:: w WARN: Web Service not activated
w3wp!crypto!384!12/5/2005-07:50:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!384!12/5/2005-07:50:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!384!12/5/2005-07:51:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!384!12/5/2005-07:51:05:: i INFO: Exporting public key
w3wp!crypto!384!12/5/2005-07:51:05:: w WARN: Web Service not activated
w3wp!crypto!384!12/5/2005-07:51:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!384!12/5/2005-07:51:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-07:52:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:52:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:52:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:52:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:52:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-07:53:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:53:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:53:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:53:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:53:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!384!12/5/2005-07:54:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!384!12/5/2005-07:54:05:: i INFO: Exporting public key
w3wp!crypto!384!12/5/2005-07:54:05:: w WARN: Web Service not activated
w3wp!crypto!384!12/5/2005-07:54:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!384!12/5/2005-07:54:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!d90!12/5/2005-07:55:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!d90!12/5/2005-07:55:05:: i INFO: Exporting public key
w3wp!crypto!d90!12/5/2005-07:55:05:: w WARN: Web Service not activated
w3wp!crypto!d90!12/5/2005-07:55:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!d90!12/5/2005-07:55:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!384!12/5/2005-07:56:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!384!12/5/2005-07:56:05:: i INFO: Exporting public key
w3wp!crypto!384!12/5/2005-07:56:05:: w WARN: Web Service not activated
w3wp!crypto!384!12/5/2005-07:56:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!384!12/5/2005-07:56:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!d90!12/5/2005-07:56:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!d90!12/5/2005-07:56:05:: i INFO: Exporting public key
w3wp!crypto!d90!12/5/2005-07:56:05:: w WARN: Web Service not activated
w3wp!crypto!d90!12/5/2005-07:56:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!d90!12/5/2005-07:56:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!384!12/5/2005-07:57:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!384!12/5/2005-07:57:05:: i INFO: Exporting public key
w3wp!crypto!384!12/5/2005-07:57:05:: w WARN: Web Service not activated
w3wp!crypto!384!12/5/2005-07:57:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!384!12/5/2005-07:57:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-07:58:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:58:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:58:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:58:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:58:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-07:59:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-07:59:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-07:59:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-07:59:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-07:59:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!384!12/5/2005-08:00:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!384!12/5/2005-08:00:05:: i INFO: Exporting public key
w3wp!crypto!384!12/5/2005-08:00:05:: w WARN: Web Service not activated
w3wp!crypto!384!12/5/2005-08:00:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!384!12/5/2005-08:00:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!d90!12/5/2005-08:01:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!d90!12/5/2005-08:01:05:: i INFO: Exporting public key
w3wp!crypto!d90!12/5/2005-08:01:05:: w WARN: Web Service not activated
w3wp!crypto!d90!12/5/2005-08:01:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!d90!12/5/2005-08:01:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!d90!12/5/2005-08:02:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!d90!12/5/2005-08:02:05:: i INFO: Exporting public key
w3wp!crypto!d90!12/5/2005-08:02:05:: w WARN: Web Service not activated
w3wp!crypto!d90!12/5/2005-08:02:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!d90!12/5/2005-08:02:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-08:03:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-08:03:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-08:03:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-08:03:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-08:03:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-08:04:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-08:04:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-08:04:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-08:04:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-08:04:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-08:05:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-08:05:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-08:05:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-08:05:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-08:05:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!2a8!12/5/2005-08:06:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!2a8!12/5/2005-08:06:05:: i INFO: Exporting public key
w3wp!crypto!2a8!12/5/2005-08:06:05:: w WARN: Web Service not activated
w3wp!crypto!2a8!12/5/2005-08:06:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!2a8!12/5/2005-08:06:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!384!12/5/2005-08:06:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!384!12/5/2005-08:06:05:: i INFO: Exporting public key
w3wp!crypto!384!12/5/2005-08:06:05:: w WARN: Web Service not activated
w3wp!crypto!384!12/5/2005-08:06:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!384!12/5/2005-08:06:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!crypto!d90!12/5/2005-08:07:05:: i INFO: Initializing crypto as
user: NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!d90!12/5/2005-08:07:05:: i INFO: Exporting public key
w3wp!crypto!d90!12/5/2005-08:07:05:: w WARN: Web Service not activated
w3wp!crypto!d90!12/5/2005-08:07:05:: i INFO: Client is not a local
admin. Not attempting activation.
w3wp!library!d90!12/5/2005-08:07:05:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the
documentation for more information.
w3wp!webserver!84!12/5/2005-08:07:57:: i INFO: Reporting Web Server
stopped Tag: Q: deploying report into a folder Tag: 45057
problem installing Report Designer Component - visual studio 2005
while attempting to install the Report Designer Component,
from the Microsoft CRM 3.0 Server CD.
I get an error message that we need visual studio.net 2003 installed, in
order to install the Report Designer Component....
the problem is that we already installed visual studio 2005, and we use
SQLSERVER2000
what can I do? Tag: Q: deploying report into a folder Tag: 45056
Forms authentication & SQL RS 2000 - which versions supported?
Hi,
I was told recently that the SP2 release for SQL RS 2000 made custom (i.e.
Forms) authentication available in the SQL Server 2K Standard edition -
where it had only been available in Enterprise prior to SP2.
Can anyone confirm if this is correct?
Thanks,
Chris Tag: Q: deploying report into a folder Tag: 45051
Drillthrough actions in page headers and footers are not supported
Hi all
Our company is looking at upgrading a number of RS2000 reports to RS2005.
Inital deploys to the 2005 server (of the old 2000 reports) recieve this
warning msg:
"Drillthrough actions in page headers and footers are not supported by all
renderers"
It seems that within the report manager and the report server the HTML
rendering will not allow the Drillthough funcitonality to work within the
header, we get this msg when clicking the headers links:
"The path of the item "(null)" is not valid. The path must be less than 260
characters long and must start with slash. Other restrictions apply.
(rsInvalidItemPath)"
This drillthough in report headers works fine in 2000 and is an approach
used thoughout our reports. Can anyone let me know if Microsoft have
removed/modified this functionality?
We have tried:
*Converting the report
*Resetting the action and recompiling the report
*using an expression (Globals!ReportName) istead of the actual report name
Thanks for any help you can provide on this matter.
Mark Tag: Q: deploying report into a folder Tag: 45049
"A connection could not be made to the report server http://localh
Hello
My problem is following :
I try to deploy a simple report to my report server. It works without any
problem when I use a particular account (let's say account "A").
When I try to deploy the same report to the same report server, but with my
own account (or any other account), I can't get it to work. Following error
msg is displayed
"A connection could not be made to the report server
http://myServer/myReportServer"
I checked following parameters :
- I can access http://myServer/myReportServer with IE6
- I can access http://myServer/myReports with IE6
- NTFS permissions are correctly set (my account is in the same group as
account "A", which have NTFS permissions on "myServer", "Reportserver" and
"Reports")
I really have no more idea on what I could search for.
Thanks for any suggestion
Macfly92 Tag: Q: deploying report into a folder Tag: 45045
Successive Queries
Hello,
I was just wondering if anyone has used successive queries in a dataset
or if tried then wether it succeeded. I am currently trying to
implement one but I have to manualy add fields from query 1 and when I
preview the report query 2 isn't run.
Thanks in advance,
Lilja Tag: Q: deploying report into a folder Tag: 45043
Sql Reporting Services included in Sql Express?
Hi,
I am trying to develop a simple web application using Visual Web Developer
2005 Express Edition.
Does reporting services come with SQL Server 2005 Express Edition?
Thanks,
Mehul Tag: Q: deploying report into a folder Tag: 45042
Encrypt password
Hello,
please, is it possible to encrypt password for reports in reporting
services?
I want to use "The credentials supplied by the user running the report" for
my reports and I want to call IE( with reporting services) from other
program with full path ( with parameters, password, user name, ...).
Thank you
David Krenek Tag: Q: deploying report into a folder Tag: 45041
Bar Chart Trendline
Good day,
Can anyone help me in adding a trendline to a Bar chart in SSRS please?
Thanks Tag: Q: deploying report into a folder Tag: 45039
"Data-Driven Subscription" Not Showing
Hi,
Just a follow-up on my earlier email.
I have Reporting Services 2000 installed on Small Business Server for
Windows 2003.
I am logged on as admistrator and all permissions for Content Manager ans
System Admistrator are in place
When I Go To Subscriptions in Report Manager, "New Subscription" option only
shows.
I know that there should be a "New Data-Driven Subscription" option showing
right next to this.
But it just does not show. Does nayone know why this is not the case.
Does this appear only with SQL Reporting Services 2000 Service Pack 1 only?
Or is some option that needs to be ticked off somehwere for this to show.
Does anyone know why this option just will now show?
Thanks
Sanjeev Tag: Q: deploying report into a folder Tag: 45038
HELP - How to specify no credentials programatically?
When we use the ReportingService2005.CreateReport () method to publish an RDL
file to the server (from a C# client application we've developed), there
doesn't seem to be a way to specify within the RDL that "No credentials are
required" for the datasource it uses. Nor does the CreateReport() method
accept a parameter to specify this. The system seems to default to
"Credentials Supplied by User" which is not what we need.
The datasource definition is internal to the RDL file (i.e. not a shared
one).
Does anyone know how to do this?
thanks in advance,
Michael Tag: Q: deploying report into a folder Tag: 45037
Displaying drill threw report based on user rendering the report
Dear all
I have to develop a report which have user as the top level of grouping.
Two groups of users use the report
1. CEO
2. Manager
The requirement is that when the CEO reviews this report he
have to see all the managers.
If the manager review the report he have to view only his
personal work
How to approach this requirement
Thanks in advance
Manickam Tag: Q: deploying report into a folder Tag: 45036
RS 2005 and forms authentication
I am trying Reporting Services 2005 with forms authentication sample ofr 2000
and I could go upto the point of registering a user. I could register the
user but when I logon, it says "invalid namespace".
Desperate to solve this.
Mathi Tag: Q: deploying report into a folder Tag: 45035
LocalReport Render as HTML or Print HTML
We are developing an ASP.NET application and are considering using the report
viewer with localreports. Is there are way to either render the localreport
as HTML (for printing) or have the reportviewer print the rendered report?
Thanks,
Don DenUyl
Diamond Systems Tag: Q: deploying report into a folder Tag: 45033
Subscription error log?
I have a subscription that ran and produced the following 'Status'.
Done: 3397 processed of 3397 total; 2565 errors.
I don't see any errors listed in the RS log file.
Is there a way to identify what these errors are?
Thanks,
Neil Tag: Q: deploying report into a folder Tag: 45031
Sending Cube Parameters (SQl 2005) to a report
HI everyone,
I hope you can help me.
I'm interesting in sending the cube parameters to a reporting services report.
Iâ??ve already evoked a report from the cube.
Thanks, Tag: Q: deploying report into a folder Tag: 45027
Atlanta area help (will pay)
I have just about everything working, but I'm having some trouble
getting the correct implmentation I want. If anyone is in the Atlanta
area and has a few hours of free time I don't think what I'm trying to
do is that big of a deal.
Thanks,
Voss. Tag: Q: deploying report into a folder Tag: 45026
Export to word or rtf format
I would like to know if it is possible to export a report created with reporting
service
in Microsoft Word or RTF format.
Thank's in advance
Giorgio Parmeggiani Tag: Q: deploying report into a folder Tag: 45024
No longer emailing
Hi all,
On Thursday, the reports scheduled to be emailed suddenly stooped being
sent. When I go into the report, it shows an error as follows:
Failure sending mail: The message could not be sent to the SMTP server.
The transport error code was 0x800ccc15. The server response was not
available
Can anybody tell me what this means?
Many Thanks Tag: Q: deploying report into a folder Tag: 45023
the report manager can not be accessed .
After changing the ReportServerUrl to http://211.81.57.225/ReportSever
in RSWebApplication.config, the report manager can not be accessed,HTTP
401 failed Unauthorized will show after entering the user
:administrator,
when i change the Url to http://localhost/ReportSever, the Report
Manager has some errors visting from outside.
how can the report manager be accessed from outside? Tag: Q: deploying report into a folder Tag: 45022
Print scaling like Excel
Our company uses Excel heavily, like most other companies do. One of the
features that Excel does better than any other product is scale the output to
the printer automatically (option to "Fit to X pages wide by Y pages tall").
I haven't found an easy way to accomplish this in Reporting Services.
Because RS uses things like Matrix regions that grow dynamically, sometimes
you can't anticipate the final paper size of the output, but you can be sure
users will try to print. And now that SP2 includes the client-side print
functionality, users instinctively see the printer icon, and click it, only
to get a simple dialog to send directly to the printer with no control on the
output, except what was set by the report developer in the Report Properties
for paper size.
I also do not know if there is an option for overriding the pagination for
the HTML output vs. paper size, but when I view my report online in HTML,
even without explicit page breaks, RS cuts the report into 2 pages on screen.
This is fine when it is printed on paper, but users do not need to go to
page two if they can simply scroll down while viewing.
Thanks
Kory Tag: Q: deploying report into a folder Tag: 45016
Avoid User Login - Again!
I am trying to find a way to avoid the login popup that appears when a web
site user opens a page that includes a ReportViewer configured to show one
of my reports. I am using VWDE 2005 (VB) and my Report Services account is
on a SQL 2000 server.
I had posted a similar question earlier and got some helpful suggestions
from user "Ches" but I never got the ReportViewer approach to work - I
instead found an alternative way to display the report - see below - but it
does not include options (e.g. Export) that the ReportViewer does so I am
back to trying to get that working.
I have an aspx page with a ReportViewer control configured to display the
desired report but when that page is opened the user gets a popup indicating
that it is trying to connect to my RS service and it shows my account
username "MyMachineName/MyRSAccountName" and it wants my password which, if
I supply it, works fine - I see the report.
If I use an alternate way of showing the report (see below) it works fine
and the user is never asked for the PW? When using the ReportViewer control
I have been unable to find a way to pass it the credentials. It appears that
the credentials and userlogin methods are associated with an instance of the
reporting service but I don't see a way to connect the viewer to any such
instance.
My RS service is on a shared server (I just have an account and password). I
can navigate to my reports on the server and I can see that the specific
report is configured with the username and password included.
Any help on this is appreciated.
Wayne
===================== Alternate Approach - Works =========================
Public Sub ShowReport()
Dim rs1 As New rs.ReportingService
rs1.Credentials = New System.Net.NetworkCredential("myRSAccount",
"myPW", "")
Dim results As Byte(), image As Byte()
Dim streamids As String(), streamid As String
results = rs1.Render("/wengertorg0/reports/Votes", "HTML4.0", _
Nothing,
"<DeviceInfo><StreamRoot>/WebApplication1/</StreamRoot></DeviceInfo>",
Nothing, _
Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, streamids)
Response.BinaryWrite(results)
End Sub Tag: Q: deploying report into a folder Tag: 45012
Error 'SubReports could not be show'
Hi,
I have created a report with sub-reports in it, the parent report runs fine
in report designer as well as after deployment in report manager. That makes
sures that the parent & sub report mapping/binding configuration are perfect.
but when i try to execute the report through report viewer control (control
downloaded from the microsoft sample program site) it shows error in
sub-reports stating
'SubReports could not be show'
can any one tell , what could be wrong ??,
or could there be a problem in the report viewer control ?? Tag: Q: deploying report into a folder Tag: 45011
SRS Reports formatting
Hi ,
I am creating a cross-tab report and the columns in that are generated based
on the data.There's also a grouping
i have a percentage (calculated) column , that calculates the % of the
individual record with that of value of all the records
i want to show the % value only at grouping level and not at each record
level.
Report format
Jan-05 Feb=05
Region Value % Value %
1
2
3
total TValue T% Tvalue T%
4
5
6
total
how can i do this,there's seem to be a problem with cross-tab columns
formatting.
i want to show only T% value and not % values.
Jan-05 & Feb-05 are cross tab columns generated base on data fetched for
every month
any suggestions. please help.
Thanks in advance Tag: Q: deploying report into a folder Tag: 45010
Looking for a Reporting Tools
Has anyone used Intelliview? Is there any website comparing it with RS? Tag: Q: deploying report into a folder Tag: 45007
Urgent : ASP.NET session has expired???
Hi all,
I'm getting the above message whenever I try to view a report.
My current application has both run in the defaultapppool as well as a
user-created app pool - I still get the above error.
I really need help on this please.
Thanks in advance.
Regards
John. Tag: Q: deploying report into a folder Tag: 45006
RunningValue funtion doesn't seem to work with a chart data region
I am trying to build a chart where on of the data values represents a running
total. I also created a table data region to show the tablular
representation of the chart data.
The running value function requires a scope parameter representing the
group. I specify the name of the category group for the scope.
When I run the report the tablular data shows a correct running total.
However, the chart doesn't. I don't get any errors but the chart running
total values display as if a simple grouping and sum were done on the values.
Is this a known bug or am I doing something wrong. Tag: Q: deploying report into a folder Tag: 45002
Anyone having trouble with DefaultValues count of one (nil) when none are expected?
Depending on how the report is first deployed the DefaultValues collection
may or may not be empty. This is causing us trouble with our web app code
when we make attempt to set the UI select list when we want to leave it at
<select a value>.
The parameter collection of DefaultValues deployed on the server does not
match my RDL. The population of the DefaultValues section depends on the
steps taken to create the report. I can deploy equivalent reports and get a
DefaultValues collection if I first select 'allow null value'. If I do not
check this I will not get a DefaultValues collection unless I provide them.
The deployed results are dependent on how I first deployed the report.
Confirmed this occurs in both RS 2000 and RS 2005 (same box, 2005 is a named
instance)
Steps to reproduce:
Create a report with a single parameter, accept all parameter defaults.
Query the parameter field of the catalog table:
<Parameters>
<Parameter>
<Name>Report_Parameter_0</Name>
<Type>String</Type>
<Nullable>False</Nullable>
<AllowBlank>True</AllowBlank>
<MultiValue>False</MultiValue>
<UsedInQuery>False</UsedInQuery>
<State>MissingValidValue</State>
<Prompt>Report_Parameter_0</Prompt>
<PromptUser>True</PromptUser>
</Parameter>
</Parameters>
delete the parameter
create a new parameter with a different name (same parameter name doesn't
generate the DefaultValues enum)
<Parameters>
<Parameter>
<Name>Report_Parameter_new</Name>
<Type>String</Type>
<Nullable>True</Nullable>
<AllowBlank>True</AllowBlank>
<MultiValue>False</MultiValue>
<UsedInQuery>False</UsedInQuery>
<State>MissingValidValue</State>
<Prompt>Report_Parameter_0</Prompt>
<PromptUser>True</PromptUser>
<DefaultValues>
<Value nil="True" />
</DefaultValues>
<Values>
<Value nil="True" />
</Values>
</Parameter>
</Parameters>
edit the parameter clearing the 'allow null value' checkbox and deploy
<Parameters>
<Parameter>
<Name>Report_Parameter_new</Name>
<Type>String</Type>
<Nullable>False</Nullable>
<AllowBlank>True</AllowBlank>
<MultiValue>False</MultiValue>
<UsedInQuery>False</UsedInQuery>
<State>MissingValidValue</State>
<Prompt>Report_Parameter_0</Prompt>
<PromptUser>True</PromptUser>
<DefaultValues>
<Value nil="True" />
</DefaultValues>
<Values>
<Value nil="True" />
</Values>
</Parameter>
</Parameters>
* note: expected the default values collection to be empty. Tag: Q: deploying report into a folder Tag: 45001
Local report from local dataset
Hi,
I have some experience with RS 2000, but just started 2005.
I am trying to incorporate reports into my application using report viewer,
no server.
I will report from the data set that I created inside of my app. It is also
possible that based on user's input some fields can be suppressed.
I know that I can use business objects, but it looks like I have everything
in my data set. So, can I build my report(s) from this data set in design
time (how can I see my data set as data source?)?
And another question, is there any API to manipulate controls on report
during design time? I spent a lot of time with Crystal - I can do this there.
I hope RS has something like this or even better.
Thanks. Tag: Q: deploying report into a folder Tag: 45000
date input parameter
I have user who are entering startdate and enddate parameters. How can I make
sure that the date the enter is in the mm/dd/yy format? Usally you do this
with javascript. Or can I just do something where I can check the length of
the field.
--
kmatth007 Tag: Q: deploying report into a folder Tag: 44999
Can't connect to SSMS, need help.
Hi,
I have a local installation of SQL Server 2005 (evaluation ) on window 2000
sp4, with Reporting Services, Integration Services, and Analysis Server
installed.
I can connect to Integration Services and Analysis Server via the SQL Server
Management Studio, but not to the Report Server. I also can't access and use
the Report Server installation via http://myserver/Reports and
http://myserver/ReportServer. The following is an error I got when i try to
connect SSMS:
The request failed with HTTP status 407: Proxy Authentication Required ( The
ISA Server requires authorization to fulfill the request. Access to the Web
Proxy service is denied. ). (Microsoft.SqlServer.Management.UI.RSClient)
Can anyone helps me out ? Any suggestion is welcome. Thanks.
Karen, Tag: Q: deploying report into a folder Tag: 44993
Local SMTP
Scheduled reports without deliverable extensions are sent but however, when
sending reports in the format of Excel fails.
I am using local SMTP to deliver reports.
Thanks! Tag: Q: deploying report into a folder Tag: 44991
Reportviwer problem in remote mode
Hi all,
I set the ReportServer property correctly as well as the ReportPath but
receive the following error
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
Any ideas?
Regards
John. Tag: Q: deploying report into a folder Tag: 44989
outlook web access - weird
I have subscriptions setup to deliver reports in PDF format to users email
address. No problem there. When the email is opened in the Outlook client,
the attachment appears as expected and can be opened. The problem is when
the user accesses their email using Outlook web access (OWA). The email
appears and even has the paper clip identifying the attachment. However,
when the email is opened. the attachment is gone. Tag: Q: deploying report into a folder Tag: 44987
Creating new Users/Groups using RS SOAP API
I have Forms Authentication working well. I can create users & groups in my
Forms Authenticating database. However, defining a policy for an item
requires associating Item + Role + GroupUserName(different from forms
authenticating db) in RS.
How do I create these users/groups using Reporting Service SOAP API?
Thanks,
Dawit. Tag: Q: deploying report into a folder Tag: 44984
Client cached recordsets
What does ClientReportCtl.ActionHandler do?
I am looking to see if any data is stored locally at the client.
Specifically, what happens when the "toggle" button is clicked in a matrix.
I realize that the HTML along with the data is streamed from ReportServer,
and when I do a View Source on the page, all I see is the results of the
toggle display in the final HTML, but is there a local recordset with any
underlying data in it on the client, that subsequent toggles retrieve from,
rather than going back to ReportServer?
I need to make estimations on performance for some devices. Tag: Q: deploying report into a folder Tag: 44983
SQL 2005 RTM, Report Builder Permissions error
I have created a report model and published it to our SSRS server. When
administrators use Report Builder to build and run reports everything is
fine, but the normal users are encountering a runtime error when they try to
run a report they are designing. The error is "The permissions granted to
user 'CATSOLNS\<ntname>' are insufficient for performing this operation.
(rsAccessDenied)"
These users have been granted "Browser, My Reports, Report Builder"
permissions.
What is odd is they can create reports and save them to the server but they
can not run them.
Any clues?
Or better yet are there any good documents that discuss how security works
with SSRS and Report Builder.
Thanks, Mike Tag: Q: deploying report into a folder Tag: 44982
Hello,
I deploy my report through deploy command in the menu. If I create a folder
in the report manager how can deploy my report into the folder?
Thanks,