Reporting Services :: Enable Network Service In Report Configuration Manger?

Jun 9, 2015

My Report service account, by default "Network Service" in the config manager.

 some of my onsite people my mistakenly changed the SSRS service account to the "Local system".

when I am trying to change it back, Manager is ask to create the dialog box 2(encrypt key) given below...

When try to create the encrypt account , report server is stopped working..I had changed the properties of the reporting services also..

View 3 Replies


ADVERTISEMENT

Reporting Services :: How To Enable HTTP For Existing SSRS Service With HTTPs

May 19, 2015

How to enable http for SSRS service in my current sharepoint 2013 environment with https.

this is needed as we have a limitation in SSAS: We cannot specify HTTPS in the Analysis Services Report Action.

View 3 Replies View Related

Reporting Services :: Cannot Enable Schedule For Power View Report

May 18, 2015

I have a couple of Power View reports that I cannot enable the data refresh schedule for. I cannot pinpoint what caused the schedule to stop working but the scheduled data refresh for these reports used to work and now they don't. Every time I try to enable a schedule the page submits and it seems like everything worked (no errors). However, when I go back to the schedule page for the report the Enable checkbox is unchecked. There are other Power View reports that are scheduled and running just fine. The only error I can track down in the SharePoint logs is this:

Failed to remove workbook tracking handle from collection for workbook

I've tried making a copy of the file and re-uploading with a different name but nothing changes. The user would really rather not recreate the report from scratch.

View 4 Replies View Related

Reporting Services :: Disable / Enable View Report Button

Sep 14, 2015

Is there a way to make the View Report disabled or enabled if certain condition exists?

View 3 Replies View Related

Configure Report Server From Reporting Service Configuration Manager

Jan 25, 2008

When I opened "Reporting Service Configuration Manger" from SQL server configuration tool list, The "Report Server Installation Instance window came out. It showed my local machine name on the field of Machine Name. When I click "Find" button, a message box came out. It says: "No report server were found on the specified machine. Details: Invalid namespace

What is the problem and how to solve it.

View 1 Replies View Related

Unable To Open Windows Service Identity Panel In Reporting Services Configuration Manager

Jul 4, 2007

Hi,



I've a slight problem with configuring my Report Server. I have set up everything apart from the initialisation and and the Windows Service Identity, however when I select the panel for the latter I am presented with a message box displaying the following:



" Reporting Services Configuration Manager:



There was an error while switching panels. The most likely cause is an error retreiving WMI properties. The exception details are:



InvalidArgument=Value of '1' is not valid for 'SelectedIndex'.

Parameter name: SelectedIndex "



I have tried re-installing the entire SQL server setup and this made no difference, I followed this by removing then reinstalling just the Report Service. Still nothing.



Any ideas as to what it is doing and how I should go about fixing it?



Sim

View 4 Replies View Related

What Are Issues Involved With Deploying A Reporting Services Report Outside Of Our Network?

Oct 30, 2007

I would like to know if it is resonable and acceptable to make reports created through SQL Server Reporting services available through our Public facing applications.

Also, what are the potential problems? Security? Impact on the SQL Server? Limit to specific types of reports?

If anyone has any info it would be greatly appreciated, I am a big fan of SQL Reporting but we are unsure if we are going to be able to use the reports on the Public side and we don't want two separate sets of reports (internal and Public).

Thanks in advance.
Terry

View 6 Replies View Related

Reporting Services Configuration Killed Several Summary Report Functions

Nov 22, 2006

I installed 2K5 developer on my box. I was impressed with the Summary tab report functions and the reports available there. Then I ran the "Reporting services configuration" tool to get RS running, but now several of the summary reports are broken. There are several different error messages given in the summary window, depending on the report selected.

For example, the "server dashboard" now displays












Summary Unavailable











The information needed to display a summary page for the selected object is not available.








Error:









"sql_handle" is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode is set to 90.



The next two reports work, but the "Scheduler Health" report displays


















Summary Unavailable











The information needed to display a summary page for the selected object is not available.








Error:









Incorrect syntax near '.'.



"Memory Consumption" works GREAT, but "Activity - All blocking transaction" shows:


















Summary Unavailable











The information needed to display a summary page for the selected object is not available.








Error:









Incorrect syntax near '.'.
Incorrect syntax near '.'.
Incorrect syntax near the keyword 'as'.
Incorrect syntax near the keyword 'as'.



What could be the cause of such errors? Is there an "easy fix"? I wouldn't know how to "unconfigure" reporting services and have a feeling that wouldn't help anyway...



View 11 Replies View Related

Reporting Services :: Report Server Email Configuration - Permitted Hosts

Aug 25, 2015

I would like to configure the permitted hosts setting for the Report Server. According to MSDN, the Syntax is:

 <PermittedHosts>
          <HostName>Adventure-Works.com</HostName>
          <HostName>hotmail.com</HostName>
     </PermittedHosts>

In case of having only one host, is the <HostName> tag mandatory? I was not able to find more information regarding the xsd on which the configuration file is based. To be more specific, is it possible to define the PermittedHost like this or will this result in an error?

 <PermittedHosts>Adventure-Works.com</PermittedHosts>

View 3 Replies View Related

Reporting Services :: Report Subscriptions Not Working With A Particular Domain Service Account?

Aug 13, 2015

I have an instance of SSRS that will not run my report subscriptions if it is using a dedicated domain account I made for the express purpose of using it to run this service.

If I have SSRS use my personal domain account as the service account, my subscriptions run correctly. If I have SSRS use this other domain account, the subscriptions do not run.

What else do I have to configure to make this run correctly not on my personal account?

Error message below.

"ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;"

View 2 Replies View Related

Stopping Cancelling Report Execution Reporting Services Ssrs 2005 Using The Web Service Api

Mar 23, 2008

Hello,
How can I stop a report I started by using:
ReportExecutionService rs = new ReportExecutionService()
.
.
.
rs.Render(...)


I need to stop the report when a user clicks a button in my aspx page.

TIA
gad

View 1 Replies View Related

How To Enable SQL 2005 Reporting Services?

Oct 7, 2007

SQL was installed w/o reporting previously by the other admin. How do i enable the reporting now?

View 6 Replies View Related

Reporting Services :: Enable And Disable Checkbox?

Sep 16, 2015

How can we create a checkbox in SSRS and how can it be enabled disabled based on the value.

View 5 Replies View Related

Reporting Services :: Enable Multi Value Parameter

Apr 2, 2010

I have an SSRS 2005 report that I want to enable for multi value. However, I always run into the issue with the way it passes multiple values. How exactly do I get a multi-value parameter setup and working on both the report AND SQL side?I used the MS example of checking the multi checkbox for the parameter and then using a WHERE Column IN (@MultiParam), but this doesn't work. When you select one item, or is it multiple I can't remember, it fails.

View 29 Replies View Related

SQL Server Service Manger Fails To Start With Error Message

Apr 15, 2001

We have changed the Network Domain name of a SQL server and restarted before changing any of the settings in SQL server. When we now try to start the SQL server service manager we get the following error

Your SQL server is either corrupt or has been tampered with. Unknown package id please rerun setup

Any suggestions on how to get the SQL server back on line without having to take the server down and changing the Netowrk Domain Name back ??

Cheers

SR

View 1 Replies View Related

Reporting Services :: How To Enable ADFS For SSRS 2008

Aug 3, 2009

How to enable ADFS for SSRS 2008?

View 4 Replies View Related

How To Enable Remote Errors For Reporting Services 2005

Mar 7, 2006

How do I enable remote errors for Reporting Services 2005?

View 5 Replies View Related

Reporting Service Configuration In Distributed Environment

Feb 27, 2007

Hi,

Please let me know if the following server configuration is possible?

SQL Server Database Services on machine #1

Analysis Services and Reporting Services 2005 on machine #2 (without SQL Server Database Services)


Post installation, need to setup Reporting services configuration. In that, within Database Setup, point to database installed on machine #1.

I am facing problem in pointing to remote database.

Awaiting some reply.

Thanks!



View 3 Replies View Related

Reporting Services :: How To Check Report Server Windows Service Has Send As Permissions On The SMTP Server

Sep 3, 2015

i want to check.. Report Server Windows service has Send As permissions on the SMTP server.

how can i do this..

View 2 Replies View Related

Reporting Services :: JIT Debugging Error When Reporting Configuration Manager Is Opened

Sep 11, 2015

We have installed SQL Server 2005 with reporting services.When tried to open getting errors as below: how to avoid such errors See the end of this message for details on invoking  just-in-time (JIT) debugging instead of this dialog box.

ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMException (0x8000000A)
  at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
 
[code]...

View 4 Replies View Related

Configuration Of Reporting Services

Nov 23, 2006

obviously until I get this sorted I cannot deploy my reports

in my Reporting Services Configuration

All ticked except initialisation (3)

in Database services ticked but on the right hand side there are warnings/errors

Verifying Database Edition - ticked

Verifying Database Version - warning

The current connection string is not valid and can't be used to connect to SQL Server

Where do I check this? (1)

Creating A Grant Rights script for LocalSystem = ticked

Assigning Reporting Services Rights to User = error (2)

System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in the current database.
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 Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

Can someone tell me what I should be checking please?

thanks

View 13 Replies View Related

Reporting Services :: SSRS For Outside Network Access

May 19, 2015

Previously I was using SSRS to create a local website(native mode) for our domain users to access. I wonder whether it is possible to share the website to outside users(just like youtube, everyone can access it). Is there a possible way to achieve that?

View 3 Replies View Related

Reporting Services On A Workgroup Based Network?

Feb 28, 2007

Can I use Reporting Services 2005 in a workgroup to serve reports for a windows application which is distributed accross the network?

I've already tried but when the application on a client pc requested a report from the report server i got a message about not having enough permissions to see the report. The windows application was builded using VB .NET 2.0 and VS2005.

The report server instance is installed on a server 2003 enterprise along with the SQL Server 2005.

If this is possible how can set permisions or make my application to be able to requests and show reports?

Thanks a lot to anybody who takes the time to answer.

Antonio Alfaro

View 1 Replies View Related

Reporting Services Configuration NO Initialization

Mar 29, 2007

I am installing sql server 2005 reporting services on server running sql server 2005. I get to the reporting services configuration page and configure...
report server virtual directory
report manager virtual directory
windows service identity
web service identity
database setup
encryption keys
when I get to Initialization the button is grey and inactive so I can't initialize reporting
services, Do I need to restart server?

View 1 Replies View Related

Do You Use The Reporting Services Configuration Files And If So, How?

Jan 15, 2007

Wondering if I could get some feedback from 'you All' on how you use the Reporting Services configuration files.

Specifically, I'm interested in -

1) Have you ever made changes to the configuration files? (Yes/No; if Yes - how often?)

2) What if any operations you commonly do in the files? (list)

3) Do you script or otherwise have automated solutions for updating these files? (Yes/No; if Yes - in what scenarios; if No - did you try to?)

Any other feedback about the configuration files is also welcome.

Thanks,

-Lukasz

View 2 Replies View Related

Reporting Services Configuration Tool

Jul 11, 2007

Hello all

I am trying to configure reporting services using the Configuration Tool. I get all checks green except for Encryption Keys (Blue), Initialization (Grey), and Email Settings and Execution Account (both Yellow). I am not too worried about the yellow and blue ones because I have read that other people have the same, but I was wondering how to make Initialization available to configure. I am running SQL Server 2005 - Standard Edition.

Thanks for the help,



S.R.

View 39 Replies View Related

Reporting Services Configuration Tool

Jul 12, 2007

we just got the new server windows 2003 server, sql server 2005

- i use remote desktop connect to the server.

- i made the report services for testing,

the problem is I can't not published report.

i check the report services configuration tool.

(the page is gray. also warning come "no report server were found on
the specified machine" detail invalid namespace)

what shoul i do?

View 2 Replies View Related

Reporting Services Menu Does Not Appear When Install Reporting Service Add-in For SharePoint

May 14, 2008

Hi all,

I have some problem about reporting service add-in.

After I install reporting service add-in for SharePoint, reporting service menu does not appear in Application Management Tab in SharePoint Central Administration.

I try to uninstall and re-install again, it remain not work.

How can I solve this problem?

Thank you very much.

View 4 Replies View Related

SQl 2005 Reporting Services - Installation &&amp; Configuration - Need Help!!!

Jun 20, 2007

Hi,



I've encountered this error when opening up http://localhost/ReportServer/



The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)

Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerRSReportServer.config' is denied.

Here is the log info:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Daylight Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFilesReportServerService__06_20_2007_10_08_12.log</Path>
<SystemName>CSD060266</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!9!6/20/2007-10:08:13:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!9!6/20/2007-10:08:13:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 57106 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: SQM timer timer enabled: Next Event: 60706 seconds. Cycle: 86400 seconds
ReportingServicesService!library!e!6/20/2007-10:08:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
ReportingServicesService!library!e!6/20/2007-10:08:44:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
ReportingServicesService!library!e!6/20/2007-10:08:44:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!e!6/20/2007-10:08:44:: Attempting to start service again...




I've been doing all I could think of: reinstall the whole SQL server and its services; stop and restart SQL server service and Reporting service.



It could be my SQL version has a problem...not sure....

I could not think of anything else.



If you have any thoughts about it, please do reply.



Any suggestion is highly appreciated. Thank you...

View 3 Replies View Related

2005 Reporting Services Configuration Issues

May 3, 2007

Hi All -
I am trying to configure reporting services on virtual machine but unable to succeed. I never touched this topic before SQL Server 2005. The left hand side options in Reporting Services Configuration Manager such as Server Status, Virtual Directories, Web Identity works fine but it fails in Database Setup section
Here are the details:
AppServer: SQL Server 2005 Reporting Services & Client components build# 2153 (with SP1 & SP1 hotfix)
going to apply SP2 and Add-on component after the configuration
DBServer: SQL Server 2005 Database Services & Client components build# 2153 (with SP1 & SP1 hotfix)
OS: Windows 2003 Server with SP1
IIS version on AppServer: 6

I have SQL 2005 Reporting services and 2005 Database Engine on 2 different machines.

Here is the error message I am receiving when I try to apply the script in "Database Setup" section of Reporting Services Configuration Manager
It did not log any errors in SQL Server however it shows a warning message in Event Log
Event Log message - "The RSReportServer.config file has been modified."

Configuration Manager error message - It shows me "Create a Grants Rights Script" task failed
"System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)"

I have captured the screenshot, let me know if I can send this.

One of my friends suggested the following and I have tried the first option but could not work - Option I)
Our account that is used for database connection should have
1) public and RSExecRole roles for the ReportServerDatabase.
2) RSExecRole roles for the master, msdb , and ReportServerTempDB databases.

Else - Option II)
we can run the Reporting Service Windows Service under the local System Account and then the credentials type for the database set up would be Service credentials. This way we would have more permission.

Did anyone face this problem? how should I resolve this?


Anyone have steps to follow as I feel of missing something in the configuration steps?
Any information/ suggestions/ pointer on this are higly appreciated.

Thanks in advance !!
-Satya

View 2 Replies View Related

SQL 2005 - Reporting Services Configuration Error.. Pls Help..

Aug 12, 2007

Hi,

I've installed SQL 2005 on a Windows 2003 R2 Server, I also installed another Web Server (Another Windows 2003 R2 Server) on a different machine.
I've installed the Reporting Services on the Web Server.
When I am trying to configure the report server, I successfully created the Virtual Directories, but when trying to do the "Database Setup" step, I am getting an error on the "Create a Grants Rights Script", with this message:

System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)


As a result, I cannot run the reports nor get to the folder.aspx page on the manager side of the application.
I am getting this HTML msg:
The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Get Online Help

When installing the Reporing Server on the SQL Server machine, it works with no problems, and I am doing everything the same.

Would appreciate your help, I've been working on this for few days with no luck.

Thank you!
Yaniv.

View 4 Replies View Related

Error In Reporting Services Configuration Manager

May 24, 2006

Hello

I've got an error when I want to initialize the Report Server by means of RS Configuration Manager.

All points are check in green except "Encryption Keys" that is in "Optionnal configuration" and "Initialization" that is in "Not Configured".

When I click on "Initialization" an error occured :

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)

When I want to browse the report this error occured:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError). Cannot generate SSPI context.

Someone can help me ?

Thanks

Arnaud

View 3 Replies View Related

Reporting Services Configuration (Database Connection)

Nov 9, 2006

Hi,

I want to configure my Reporting Service.

And if I want to configure the Database Connection I the action

"Create a Grants Rights Script" fails.

I tried all credential types by it doesn't work.



Does anybody have an idea? Thanks for your help!



Jo-Jo

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved