Unable To Connect To Reporting Services

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
 



ADVERTISEMENT

Unable To Connect To Reporting Services In Mng S

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 Replies View Related

Configure Reporting Service - Unable To Connect To The Remote Server

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 Replies View Related

Unable To Configure SQL 2K5 Reporting Services On IIS 5

 

hi all,
im attempting to configure my SQL Server 2005 reporting services on my development machine that is running IIS 5 on Windows 2000.
 
I installed the reporting services and went through the configuration application.  everything went fine.  the only item with a red x is the web services account - i read on several pages that within iis 5 you can't specify this and it always runs as the ASP.NET account. 
 
Every time i go to my Report Manager site i get the following error : The report server is not responding. Verify that the report server is running and can be accessed from this computer.
 
i have tried with several differnet admin accounts and none of them work. 
when i go to the actual Reporting server site i get this error :
ACCESS TO THE PATH : 'C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config'  IS DENIED.
 
i have given almost everyone in the world access to this file through windows security but to no avail.
 
Any ideas on what to try?
 
THANKS IN ADVANCE

mcm

View Replies View Related

Unable To Debug Using Reporting Services Process

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 Replies View Related

Unable To Install Reporting Services On Vista

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 Replies View Related

Unable To Execute Job Inside Sproc From Reporting Services

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 Replies View Related

Unable To Configure Reporting Services With Vista/IIS7

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 Replies View Related

Unable To Start Reporting Services On Local Machine

I am new to SQL Server 2005 Reporting Services and I€™m 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 I€™m 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 Replies View Related

Unable To Configure Reporting Services To Use SSIS Datasource

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 Replies View Related

Unable To Login To Reporting Services On Local Host

 I am trying to setup Reporting Services on my local machine. I have installed SQL 2005 Developer Edition on my laptop and when I goto http://localhost/reports/Pages/Folder.aspx I receive the following error:





The report server is not responding. Verify that the report server is running and can be accessed from this computer.


I checked in the Event Viewer and I see some cryptic error by SQLDUMPER:

EventType sql90exception, P1 aspnet_wp.exe, P2 2.0.50727.1433, P3 471ebf4c, P4 sqldumper_unknown_module.dll, P5 0.0.0.0, P6 00000000, P7 0, P8 0f11432d, P9 00000000, P10 NIL.
 
I have the reporting server sevice running under my domain account. I also went into Reporting Services Configuration and all checks are green. 
 
Does anyone have any additional suggestions on what might be causing me to not be able to access this locally?

Thanks,
Flea#

View Replies View Related

Cant Connect To Reporting Services

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 Replies View Related

Cannot Connect To Reporting Services Using IE Or S

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 Replies View Related

Cannot Connect To Reporting Services

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 Replies View Related

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

  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 Replies View Related

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

 

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 Replies View Related

Unable To Deploy Report In Reporting Services Running In Wss 3.0 Integrated Mode

I configure an evaluation stand alone server installing SQL Server 2005 Service Pack 2 and the SQL Server 2005 reports Services Add-in for SharePoint Technologies (http://msdn2.microsoft.com/en-us/library/bb677368.aspx).
 
When I deply some reports from visual studio running on the same machine to reporting services runnig in sharepoint integrated mode, I get the following error:
 
TITLE: Microsoft Report Designer
------------------------------
A connection could not be made to the report server http://win2k3r2ee/Report.
------------------------------
ADDITIONAL INFORMATION:
The request failed with HTTP status 502: Bad Gateway. (System.Web.Services)
------------------------------
BUTTONS:
OK
------------------------------
===================================
A connection could not be made to the report server http://win2k3r2ee/Report. (Microsoft Report Designer)
===================================
The request failed with HTTP status 502: Bad Gateway. (System.Web.Services)
------------------------------
Program Location:
   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.ReportingServices2006.ReportServiceAuthentication.GetAuthenticationMode()
   at Microsoft.ReportDesigner.Project.ReportServiceClient2006.CheckAuthenticated()
   at Microsoft.ReportDesigner.Project.ReportClientManager.DetectEndpointAndAuthenticate(String url, ICredentials credentials, String& authCookieName, Cookie& authCookie, EndpointType& endpointType)
   at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
   at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
 
 
 

View Replies View Related

Can't Connect Management Studio To Reporting Services

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 Replies View Related

How To Connect A MS Reporting Services Area To A MY SQL Database

I am having a issue trying to connect MS Reporting Services with a MY SQL database.  Under the system, I can get the connection to work, but when trying to run the queries, I get database connection string errors.  I have found  the sp_addlinkview stored procedure, but get errors trying to run the values though it.  The MY SQL database is on a different machine from the Report Services Server.

I had gone unto the server itself to setup this area.  I tryed a solution posted on the internet, but that was what errored out, and the parameters did not seem to be the same.

 

Thanks!

Terry

View Replies View Related

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

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 Replies View Related

Problem Connect To Reporting Services Via Mgmt Studio

I'm using SQL 2005 Management Studio and am having a problemconnecting to Reporting Services. I get the following error when Iattempt to connect. To ReportingServices running on the same clientthat I am connecting from. Does anyone know what is going on?Cannot connect to <server name>Additional Information:The request failed with HTP status 502: Bad Gateway.(Microsoft.SqlServer.Management.UI.RSClient)

View Replies View Related

Can't Connect To SQL Reporting Services Through IIS And SQL Server Management Studio

Hi,

I'm getting the following error message when I want to connect to reporting services through SQL Server Management Studio. I have also check the reporting services configurations manager for any issues but still can't connect. The http://localhost/reportserver also is down. I also checked if ASPNET account belongs to the Reporting Services security settings and it does. IIS is up and running.

I'm running SQL 2005 Enterprise 64bit with Service Pack 2.

===================================

Cannot connect to ctbbcysql02.

===================================

The request failed with HTTP status 503: Service Unavailable. (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()

Any help will be greatly appreciated.

Regards,

Ruaan

View Replies View Related

Error Trying To Connect To Reporting Services Using SQL Management Studio

Hi.

 

I have some strange error trying to connect to Reporting Services.

At the beginning I was suspecting some accounts issues.

But after checking all the accounts under wich ASP.NET, SQL SERVER, Reporting Services are running I don't even know what to think.

After searching internet for answers the only similar problems' solutions were remove RS and install it again.

Have anybody here had this problem? Can you just fix something without reinstalling RS? The error is:

 

 

Object reference not set to an instance of an object

 

------------------------------
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.ConnectionDlg.Connector.ConnectorThread()

 

View Replies View Related

Cannot Connect To Reporting Services Using IE Or Sql Server Management Studio

 

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 Replies View Related

Cannot Connect To SQL Server 2005 Reporting Services Engine

I work in an environment where everyone is there own server.  I can connect to a collegeau's SQL Server by using the Windows Authentication method in the Database Engine but if I try to connect to the Reporting Services Engine it says that I am not allowed to connect due to permission violations.  How do I get adequate permissions to do so? I have all of the components for Reporting Services installed and I am actively using it.  I want to be able to test the functionality of the RSScriptor before deploying it out to others.

View Replies View Related

Can't Connect To Reporting Services Using Microsoft SQL Server Management Studio

When I try to connect to the Reporting Services using Microsoft SQL Server Management Studio, the following error message propmpts up:

_____________________________________________________________
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
_____________________________________________________________

Is there any settings that I need to do in the "Reporting Services Configuration Manager" ?

Thanks.

Best regards,

Michael Wu

View Replies View Related

Problems Creating Data Source To Connect To Oracle Using Sql Server Reporting Services

 

Hi,
I've created a data source to connect to Oracle through "SQL Server Reporting Services" using connection string like this "Data Source=exampleOracleConnection;Unicode="True"". I have set up a system DSN to connect and also the correct entry in the tnsnames.ora. file. I'm just confused as to how the connection credentials are run. I have selected the option within the datasource "credentials stored securely in the report server" and popped the oracle database user name and password in here. I'm not too sure is this correct though because when I run the report I get the following error message "an error has occured during report processing. cannot create a connection to data source". Does the oracle database user name and password have to be entered in the report server database in order to connect and set with the correct credentials? Any advice would be great.
Cheers.

View Replies View Related

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

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 Replies View Related

Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services

 

Hello,
 
I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
   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)
 
It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?
 
Any help is appreciated

View Replies View Related

Cannot Connect To &&"Reporting Services&&" Using Microsoft Sql Server Management Studio.

Hi,

View Replies View Related

Compatibility Of SQL Express Reporting Services With SQL 2000 Reporting Services

I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.

One option possibly is the SQL Express with Advanced Services download, which has Reporting Services.  My questions are as follows:

Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets?
Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?

Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.

Thanks to anyone who can help.

        -- Mark

View Replies View Related

Connect To Object Explorer But Cannot Connect To Integration Services.

 

I try to import my SSIS packages which are created using the Business Intelligent studio into SQL server 2005 but I cannot do that.

I am running SQL server 2005 enterprise edition.

Also when i tried to connect to Integration services using Object explorer, it only prompt me for server name.  I cannot change the username and password which is disabled.

Then how am i supposed to connect to Integration services on a server in this case?

View Replies View Related







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