Unable To Connect To Reporting Services

Aug 23, 2007

Hi all,

I am new to reporting services. I have created a report project in SQL Server BIDS. The datasource is SQL Server. I was able to see the preview of the report and could build and deploy the report. But when I try to run the report, it gives me error. So I tried connecting to Reporting Services through SQL Server Management Studio.

There I am unable to connect to the Reporting Services.
I am getting a very long error message. Giving below few lines which made sense to me.

Client found response content type of text/html; charset=utf-8, but expected text/xml.

Parse Error Message : An error occurred loading a configuration file: Access to the path c:Inetpubwwwrootweb.config is denied



I have given full rights to ASPNET, AuthenticatedUsers.

Pl help to resolve this issue.

Thanks,
Tejaswini

View 14 Replies


ADVERTISEMENT

Unable To Connect To Reporting Services In Mng S

Apr 24, 2008

All,
While trying to access the Reporting Services in Mng studio.I receive the following error
Cannot Connect To ServerA
Client found response content type of 'text/html; charset=uf-8,but expected 'text/xml'
While trying to access the report on reportmanager.I receive an error."The report server is not responding.Verify that the report server is running and can be accessed from this computer"
Any suggestion?

View 4 Replies View Related

SQL 2012 :: Reporting Server - Unable To Connect

Jun 22, 2015

I am unable to connect to reporting server , services are running fine .Checked in logs and found

ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

How to resolve this ..

View 8 Replies View Related

Configure Reporting Service - Unable To Connect To The Remote Server

Feb 20, 2008

Vista + SQL Server 2005
Reporting Service Configuration Tool: No Red Cross.
http://localhost/reportserver get this error:
HTTP Error 403.1 - Forbidden
You have attempted to run a CGI, ISAPI, or other executable program from a directory that does not allow executables to run.
http://localhost/reports get this error:
w3wp!ui!4!20/02/2008-17:17:04:: e ERROR: Unable to connect to the remote server
w3wp!ui!4!20/02/2008-17:17:04:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:443
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!4!20/02/2008-17:17:06:: 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)



I googled but not found anything useful.
Thanks in advance!!!

View 8 Replies View Related

SQL 2012 :: Unable To Connect To Analysis Services

Apr 30, 2014

Currently we are unable to connect to analysis services and getting the below error

Element 'return' was not found.Line 5,position 2

What could be causing this?

View 1 Replies View Related

Integration Services :: Unable To Connect To OLEDB

Sep 29, 2015

I'm using SQL Srv '12. Have ADW'12 and ADWDW'12 DBs installed.I created a new SSIS project. Two project level OLEDB con mngers (One for each OLEDB DB).Dragged and dropped a new DFT.Inside the DFT, I'm using Source Assistant to connect to the ADW'12 OLEDB source.

View 8 Replies View Related

Integration Services :: Unable To Connect To A Webpage From SSIS

Nov 3, 2015

I am trying to connect to a Web page from SSIS and I've tried both http connection manager and a Script Task but none of them seems to be working.

I get the following errors:

Through Script Component: Exception has been thrown by the target of an invocation.

Through http connection manager: The remote server returned an error: (503) Server Unavailable.

Here is one of the VB code I've tried:

Public Sub Main()
Dim MyWebClient As New System.Net.WebClient()
Dim proxyObject As New System.Net.WebProxy("BANANA:8080", True)
MyWebClient.Proxy = proxyObject

[Code] ....

And, here is one of the C# codes I've tried:

public void Main()
{
Variables varCollection = null;
Dts.VariableDispenser.LockForRead("User::RemoteUri");
Dts.VariableDispenser.LockForRead("User::LocalFolder");
Dts.VariableDispenser.GetVariables(ref varCollection);
varCollection.Unlock();

[Code] ...

I could open the same web page mentioned in the code manually in all my browsers (IE, Firefox, Chrome).

I am using SQL Server 2014.

View 18 Replies View Related

Reporting Services :: Unable To Delete Reports

Apr 20, 2015

We have created and scheduled some test reports via Idera performance tool but we are unable to delete the reports. These are not custom reports and reports created with Schedule Email option in Idera. Unfortunately, I dera does not have any option to delete these reports and support is asking me if I tried this by deleting from SQL Server Reporting Services.I looked at the Reporting services but can't find any place to delete these reports. This link does not provide any support because I don't have these (Or Report Manager)----> Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services.

URL....All I have is "Reporting Services Configuration Manager" under "Configuration Tools". How can I delete these reports from SQL Server Reporting services ?. Can I delete them from some tables in Reports databases ?. If so, what are the tables ?. I delete the jobs from SQL Server but the jobs are automatically created the next day emailing the reports again..

View 3 Replies View Related

Unable To Install Reporting Services On Vista

Apr 9, 2007

Hi ,

i'm a new to vista and also with sql server 2005 reporting services ..

i was able to install all the tools in sql2005 express edition except reporting services ..gives a message IIS required ..even though the IIS is running and able to browse http://localhost ..

can any one give me an idea , how to install reporting services on vista with IIS7



Thanks

View 1 Replies View Related

Unable To Debug Using Reporting Services Process

May 17, 2007

I have written Custom delivery extension, I am trying to debug this by attching the process ReportingServicesService.exe , I am getting error "Unable to Attach to the Process.Access is denied". I am Admin on my sytem, ASP.net is also part of admin and debuggers group. I am using Visual studio 2005, reporting services 2005, ReportingServicesService.exe is also under my login



Any idea??

View 4 Replies View Related

Cant Connect To Reporting Services

Dec 6, 2007

our IT guy installed Reporting Services on our test server, but the problem is that I cannot not connect to it. It says the the report services instance coundt not be found. Am I correct in saying that report services needs its own instance?? Cause when I put it on my local computer I gave it its own instance and theres no problems there

View 2 Replies View Related

Cannot Connect To Reporting Services Using IE Or S

Dec 27, 2007

I have installed 2005 in a new machine with reporting services and configured the reporting services fine. I see the virtual directories fine in IIS but when I try connecting to the report server using IE (http://localhost/reports or http://servername/reports) i get page cannot be displayed errro. When I try connecting using management studio I get the following error



TITLE: Connect to Server
------------------------------
Cannot connect to BLRPTSQL03T.
------------------------------
ADDITIONAL INFORMATION:
The underlying connection was closed: An unexpected error occurred on a receive. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
------------------------------
An existing connection was forcibly closed by the remote host (System)
------------------------------
BUTTONS:
OK
------------------------------




I donot see any errors in the event logs or the report server logs. Any help with this issue greatly appreciated

View 1 Replies View Related

Cannot Connect To Reporting Services

Feb 11, 2008

I'm getting the following message when I try to connect to Reporting Services. 'The Report Services Instance could not be found'.

Report Services was installed separetly from the Database engine install. I see a reference in the documentation that Reporting Services has to be installed concurrntly with the Database engine. There are also to reporting databases installed. Assuming that this is the problem, is there a way to create the databases and connect to them without uninstalling and reinstalling the components. I've tried using the Database setup in the Reporting Services Configuration utility without success.

Thans,
Tom

View 13 Replies View Related

Reporting Services :: Unable To Add SSRS Field Values?

Aug 4, 2015

I am having SQL query which has inner join table from another Database. The below highlighted query shows its values.

/*Trend and Capacity Report*/
SELECT MEA.DisplayName AS Cloud, MEB.DisplayName AS VM, OS.PropertyValue AS OS, CONVERT(varchar(17),PD.DateTime,113) AS Date, 
VM3.VirtualCPUCount AS VCPU
FROM Perf.vPerfDaily AS PD
INNER JOIN vPerformanceRuleInstance AS PRI ON PD.PerformanceRuleInstanceRowId = PRI.PerformanceRuleInstanceRowId
INNER JOIN vPerformanceRule AS PR ON PRI.RuleRowId = PR.RuleRowId 

[code]....

My request is to calculate total capacity of all available Virtual CPUs, Memory and Storage from 4 separate clouds:  'cloud1','cloud2','cloud3','cloud4'

Whenever I select =Sum(Fields!VCPU.Value) expression in Report Properties and assign it to a variable and assign that variable to a Text Box field I get the value as VCPU * (Number of VMs) which is not correct.

I am looking to get the value of VCPU from all 4 clouds above.

View 9 Replies View Related

Unable To Execute Job Inside Sproc From Reporting Services

Mar 21, 2008

We have a request to build a report based on user input from an excel spreadsheet. We have a SSIS package that imports the data from Excel. This is run by a sql server agent job. Our stored procedure executes this job and runs this whole process just fine but when we execute the stored procedure from reporting services we get errors. Has anyone done this type of thing before and do you have any working solutions for how to get this reporting methodology to function?

Thanks!

View 4 Replies View Related

Reporting Services :: SSRS Reports - Unable To Open In PDF

May 15, 2015

I have deployed SSRS reports to the Report Server, but am not able to open them in PDF. 

View 3 Replies View Related

Reporting Services :: Unable To Add A Second Server To Scale-out Deployment?

Apr 22, 2015

I have two SQL 2014 Enterprise Edition installed with the SSRS (native) role installed.

Both server are configured separately with their own Report Server database. Now I want to configured a scale out deployment with a shared database.

On Server 1, I created a new Report Server database. On the second server, I change the database and joined the existing database. The problem is that the second server never shows up under Scale-Out deployment (Waiting to Join).

View 6 Replies View Related

Unable To Start Reporting Services On Local Machine

Apr 6, 2008

I am new to SQL Server 2005 Reporting Services and Im having problems starting the service. I am running a Windows XP SP2 with SQL Server 2005 and reporting services but the service will not start. My SQL Server instance logs on using Windows Authentication using a username sysadm with no password

I have installed IIS and made sure that ASP.net is running.

I have opened up the Report Services Configuration Manager and amended the settings but Im unable to get the service started!!!

Theses are my settings

i) Report Server Virtual Directory OK
Name: ReportServer1
Website: Default Web Site

ii) Report Manager Virtual Directory
Name: Reports1
Website: Default Web Site

iii) Windows Service Identity
Service name: ReportServer
Service Account: NT AuthorityLocal Service

Iv Web Service Identity (NOT WORKING)


v) Database Setup
Servername Nameofmyserver
Database name - ReportServer1
Credential Type Server Credentials


When I click on start no error message appears, it just seems to time out.

View 5 Replies View Related

Reporting Services :: Unable To See Design Page In SSRS

May 20, 2015

when I try to open the SSRS in BIDS ( VS 2008), it is displaying the code portion alone. If i click 'View Designer', it prompts me like "....already opened. Do you want to close?" Only XML content of report is displaying. if I click 'Viee Code' then it displays error like "There is no editor available for 'c: eport Sample. rdl'.Make sure the application for the file type (.rdl) is installed."how to correct this issue by installing or by upgrading?

View 6 Replies View Related

Unable To Configure Reporting Services With Vista/IIS7

Jan 10, 2007

I am trying to configure a reporting server on my laptop at work. This laptop is running Vista and IIS 7. When I install reporting services, the option for "Install the default configuration" is disabled (greyed out) during setup. The install is successful, but then when I try to connect in the Reporting Services Configuration Manager, I get an unhandled exception ("A WMI error has occurred an no additional error information is available."). If I continue, this error continues to crop up as I attempt to configure the Report Server. When I attempt to configure the virtual directory, the configuration manager crashes. Then, when I navigate to the reportserver page, I get a page that states:
Server Application Unavailable

The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

Any ideas for a solution or workaround would be greatly appreciated.

Thanks,

Dave

View 1 Replies View Related

Unable To Configure Reporting Services To Use SSIS Datasource

May 16, 2008

I've created a SSIS package with a DataReaderDestination and a SSRS report that points to it.

I referenced these links during development and I have everything working as expected locally. **I changed the config files as stated on both my local machine and our server. My config matches the example exactly.

http://msdn.microsoft.com/en-us/library/ms345250.aspx
http://msdn.microsoft.com/en-us/library/ms159215.aspx

When I attempt to deploy my report project to the server I get this error message:
"An attempt has been made to use a data extension 'SSIS' that is not registered for this report server."

In the report manager data source properties page it reads:
"The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly."

In SQL Server Management Studio data source properties page SSIS is not a data source type option.

I've tried restarting both the Reporting Services and Integration Services on the server to no avail.

Any suggests? My problem is I can't get the SSIS to be recognized source on the server.

View 1 Replies View Related

Reporting Services :: Unable To Bind A New Certificate In SSRS 2008 R2

Feb 22, 2011

I've had a SSL wildcard certificate successfully in use, unless it had to be replaced because of its age. Now I've imported a new certificate, but unfortunately I'm unable to set it up in the SSRS Configuration Manager Console (Web Service URL / Report Manager URL), because "We were unable to create the certificate binding". 
 
Here is the Error Message: 
 
Microsoft.ReportingServices.WmiProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070520
 ---> System.Runtime.InteropServices.COMException (0x80070520): A specified logon session does not exist. It may already have been terminated. (Exception from HRESULT: 0x80070520)
   --- End of inner exception stack trace ---
 
I've also deleted the existing bond in the netsh console with "netsh>http delete sslcert ipport=0.0.0.0:443", but this still doesn't fix the issue.

View 3 Replies View Related

Reporting Services :: Unable To Create Parameter Using OLEDB Connection

Sep 18, 2015

I am new to MSBI, I am unable to create parameter using OLEDB ....

I am using Report Builder 3.0 and using this report tool I am executing below query, while I am running this query it display below error message.

Query:  SELECT * FROM EMP  WHERE EMPID =@EID

I need to pass @EID as parameter.

Error msg: (run the above query disp error msg)

Column or global variable *N not found. SQLSTATE:42703, SQLCODE:-206(Microsoft DB2 OLE DB Provider)

View 9 Replies View Related

Reporting Services :: Unable To Generate Report With URL With StartDate And EndDate Parameters?

Aug 14, 2015

i have problem generating the SSRS Reports. 

i have Report URL  with 2 parameters-- @StartDate and @EndDate

when i hard coded the values and copy the URL in IE, Report gets generated

sample URL's:

[URL]

but when i use Parameters--Report is not getting generated.

[URL]

Below is the error;

Reporting Services Error

The value provided for the report parameter 'StartDate' is not valid for its type. (rsReportParameterTypeMismatch)

SQL Server Reporting Services

View 2 Replies View Related

Problem In Accessing Reporting Services Web Service, Unable To Set Credentials I Guess....

Feb 28, 2007

  I am trying to access the Reporting Services Web Service, but i m not able to make it work. i tried with default credentials and network credentials

ReportingService service = new ReportingService();

service.Credentials = new System.Net.NetworkCredential("username", "password", "domain");

service.CreateSubscription(report, extSettings, description, eventType, matchData, parameters);

This is the exception i getThe current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. ---> The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.Services.Protocols.SoapException: The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. ---> The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database.

Source Error:





Line 3382: [return: System.Xml.Serialization.XmlElementAttribute("SubscriptionID")]
Line 3383: public string CreateSubscription(string Report, ExtensionSettings ExtensionSettings, string Description, string EventType, string MatchData, ParameterValue[] Parameters) {
Line 3384: object[] results = this.Invoke("CreateSubscription", new object[] {
Line 3385: Report,
Line 3386: ExtensionSettings,

View 5 Replies View Related

Reporting Services :: Error Unable To Load Client Print Control

Nov 16, 2015

We have recently upgraded our .Net web application from a windows 2003 server to a windows 2012 server. Since this happened users that are trying to print a reporting services report is getting the error "Unable to load client print control". We are using reporting services 2012, but the application is using the 8 version of the viewer. The reporting services server did not change only the application server. The code for the application did not change.

View 4 Replies View Related

Reporting Services :: Unable To Display Time Difference Value From Stored Procedure

Nov 2, 2015

Created a report that displays the Maximum Response time (example of value 00:00:00) which is directly pulled from the Stored proc.When I ran the report, the column displays blank values.I am not sure if I should add any conversion to the Response value in the report.

View 2 Replies View Related

Unable To Pass Null Value With DropDownList Parameter In Reporting Services 2005

Dec 3, 2007



Hello,

I have a stored procedure that on two fields it allows null. On the report, I have two DropDownList boxes that are populated with data, however, I would like the user to be able to have the option of not selecting an item from these list, thus passing null to the stored procedure.

When I goto "Report | Report Parameters" I have set these fields to "allow null" and "allow blank" and at the bottom I also gave it the default value of null.

When I run the report in preview mode, those two dropdownlist have a <Select a Value> and my assumption is since I want them to pass null, I will just leave them that way. However, when the report is ran, I receive an error saying "Please select a value for the parameter: (my parameter)". So it forces me to select an option at which I don't want to do.

How can I set this to pass a null?

Thanks,
Flea#

View 11 Replies View Related

Reporting Services :: Unable To Pass Parameters Dynamically In SSRS 2012

Oct 1, 2015

I am creating simple report in ssrs and pass one parameter only. It will work perfectly (here user enter the parameter value). but i need that i should select the value in drop down box. i had tried many time and did different ways but I am unable to do it.

First i gave the parameter in my sql query in Data set (like WHERE COUNTRY = @COUNTRY) and i checked the Parameters tab in the data set. Here by default comes the Parameter Name: COUNTRY and Parameter value: [@COUNTRY].

Next i select COUNTRY Parameter in the Report Data Pane. and go to properties Here in General Tab: Name COUNTRY Prompt: COUNTRY, Select Get values from query in available values Tab (and also i tried with Select Get values from query in Default Value Tab) and Select Data set: Data Set1, Value field: COUNTRY and Label Field COUNTRY. And Click Ok

And tried to preview the report, it throwing below error

"An error Occured during local report processing.  The definition of the report is invalid. The Report Parameter 'COUNTRY' has a DefaultValue or a ValidValue that depends on the report parameter "COUNTRY". Forward dependencies are not valid.

How can I achieve dropdown list.What i missed? Even i unable to do it Multi valued parameters and Cascading parameters.

Actually i am working on SQL Express 2012 version.

View 5 Replies View Related

SQL 2012 :: Can't Connect To Reporting Services From SSMS

Nov 17, 2014

I am working with SSRS. I do have admin rights. I can connect to the url https://localhost/Reports and can create the new reports and subscription. Delete the reports and subscriptions.

But when I tried to connect to Reporting Services from SSMS, I am getting below error.

I used the windows authentication. It is showing that the user name or password is not valid or you don't have permission to access this server

I can connect to the database engine and Integration services but unable to connect to the Reporting services.

View 4 Replies View Related

Reporting Services And IIS Errors - Cannot Connect To Database Etc.

Mar 29, 2008

hi,

I set up Reporting Services about 9 months ago when I installed Microsoft CRM 3 (Dynamics?), but these problems have only just started occurring. Lost count of how many hours have been wasted looking for answers!

Apologies if this rambles on like a cheap book but i don't want to miss out any of the detail..


CRM stops working within an hour of IIS starting up, but if somebody logs in to CRM before it goes down then it's fine for the rest of the day. However the next day it's back to square one. Looking through Event logs it seems to be caused by SQL Reporting Server, because;

Report Server errors show it starting up after IIS, but within an hour throws up "Exception: System.Runtime.Serialization.SerializationException - Message: Unable to find assembly 'Microsoft.ReportingServices.Diagnostics". It's at this point that IIS stops responding altogether, hence CRM stops working.

Running iisreset from the command line makes IIS work again, but this becomes a pain in the backside running it every morning before my colleagues get in. I have set up a schedule to run it for me, which works, but as i said if nobody logs in within the hour (which does happen at least once a week), then CRM won't work until i manually run iisreset again.

Also Reporting Services Configuration Manager does not start properly, so i can't even go through that to see if it's a config problem - when launching it i get an alert box with "An unknown error has occurred in the WMI Provider. Error Code 800706B3". That's with the default server name already in the box, but no matter what server name or IP I try to get it to connect to, it just will not have it. Also that error code seems to be unique to me, since not one webpage exists with the same code.

Other things i've gone through;

- SQL Server Configuration Manager shows everything Running, including Report Server
- SQL Management Studio shows all CRM & Reporting Services databases exist and are online.

- The Report Server error log shows this: "w3wp!library!1!29/03/2008-12:34:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server."

- http://localhost/ works fine.
- http://localhost/Reports/ shows up a .Net error page with Security Exception error: "The application attempted to perform an operation not allowed by the security policy".
- http://localhost/ReportServer/ shows up a page with "localhost/ReportServer - / ---- Microsoft SQL Server Reporting Services Version 8.00.1038.00" which i assume is lacking correct content.

- When CRM was configured the setup wizard moaned that it could not use the existing Reporting Services database or IIS directories, so for that purpose there are two more virtual directories in IIS..
- https://localhost/ReportsSQL/ shows up an error: "Unable to connect to the remote server"
- https://localhost/ReportServerSQL/ shows up an error: "Reporting Services Error - The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable)"

- While trying everything i am logged in as server admin
- Software specs: Windows 2003 Small Business Server (SP2), SQL Server Standard 2005 (9.0.3054 / SP2), all patches from Microsoft Update (not just Windows Update) have been applied.


If you managed to read this far then thank you.. I'm nearly bald with frustration so if someone could please suggest things worth looking into or trying, that would be very much appreciated.

Cheers

View 3 Replies View Related

Can't Connect Management Studio To Reporting Services

Jun 20, 2007

Hi,



I'm trying to connect Management Studio to Reporting services on my local machine, but get this message:






Code Snippet

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Compilation Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Compilation Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
<br><br>

<b> Compiler Error Message: </b>CS0246: The type or namespace name 'Site' could not be found (are you missing a using directive or an assembly reference?)<br><br>
<b>Source Error:</b><br><br>
<table width=100% bgcolor="#ffffcc">
<tr><td>
</td></tr>
<tr>
<td>
<code><pre>

[No relevant source lines]</pre></code>

</td>
</tr>
</table>

<br>

<b>Source File:</b> c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.0.cs
<b>Line:</b> 19
<br><br>
<br><div class="expandable" onclick="OnToggleTOCLevel1('compilerOutputDiv')">Show Detailed Compiler Output:</div>
<div id="compilerOutputDiv" style="display: none;">
<br><table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

C:WINDOWSsystem32> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450assemblydl378d258ab0f57899_d34cc701ReportingServicesWebServer.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.1.cs"


Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.1318
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.

c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.0.cs(19,20): error CS0246: The type or namespace name 'Site' could not be found (are you missing a using directive or an assembly reference?)
</pre></code>

</td>
</tr>
</table>



</div>

<script type="text/javascript">
function OnToggleTOCLevel1(level2ID)
{
var elemLevel2 = document.getElementById(level2ID);
if (elemLevel2.style.display == 'none')
{
elemLevel2.style.display = '';
}
else {
elemLevel2.style.display = 'none';
}
}
</script>
<br><br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.1318; ASP.NET Version:2.0.50727.1318

</font>

</body>
</html>
<!--
[HttpCompileException]: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.0.cs(19): error CS0246: The type or namespace name 'Site' could not be found (are you missing a using directive or an assembly reference?)
at System.Web.Compilation.AssemblyBuilder.Compile()
at System.Web.Compilation.BuildProvidersCompiler.PerformBuild()
at System.Web.Compilation.CodeDirectoryCompiler.GetCodeDirectoryAssembly(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories, Boolean isDirectoryAllowed)
at System.Web.Compilation.BuildManager.CompileCodeDirectory(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories)
at System.Web.Compilation.BuildManager.CompileCodeDirectories()
at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled()
at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters)
[HttpException]: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.0.cs(19): error CS0246: The type or namespace name 'Site' could not be found (are you missing a using directive or an assembly reference?)
at System.Web.HttpRuntime.FirstRequestInit(HttpContext context)
at System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
-->
--. (Microsoft.SqlServer.Management.UI.RSClient)

------------------------------
Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()







Anyone got any ideas?



Thanks,



Martin.



View 1 Replies View Related

Reporting Services :: Unable To Run Scheduled Reports From SharePoint In Manage Shared Schedules

Jul 16, 2015

We are running into an issue where we are unable to run scheduled reports from SharePoint in the "Manage Shared Schedules" sections of any given site in our site collection (<site url>/_layouts/15/ReportServer/ScheduleList.aspx).  Reports are able to be generated manually, but never run when scheduled from SharePoint.We are encountering the following error in the SharePoint logs for our server.  

 Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException: , Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is '162'.;     Here is the background in our environment:

SharePoint App Server  - Server 2012 R2 running SharePoint 2013 Application server - running SSRS SharePoint Integrated configured through Central Admin.SharePoint SQL Server - Server 2012 R2 running SQL 2012 SP1 for the SharePoint farm - hosts the Reporting Services databases.I have run the script within the Central Admin > Provision Subscriptions and Alerts to give appropriate permissions the the account in use.  Also the reporting services databases were created new as part of the install, so they were not migrated from a previous version.

View 3 Replies View Related







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