Unable to use Reporting Services

Hot Topic

Can not connect to AS 2005 from Excel
Configuring Reporting Services behind a firewall
The process could not connect to Distributor 'Distributor-name'. 20084
Can't Route to another LOCAL Broker Instance
Design of tables with large optional fields?
Detect installed version?
What's Happened to Copy Objects in Import/Export Wizard?
Unpivot Transformation Null Values
SQL Trigger Problem from .NET Assembly during deployment
SSIS Package on X64 with Script Task

SQL Server

can't open adventure works example
Transfer Objects Doesnt allow 2 connections to the same server
RSS feed with ISO8859 encoding
How to create a new named instance
Creating a package with data flow task programmatically
SQL Server Project
opinion xp_fileexist
Losing rows from file to destination table - need troubleshooting help
New features/bug fixes in Sept CTP?
Wait for Recieve Fails to recieve message when called from .Net sqlClient

Unable to use Reporting Services

Hi,
After installing Sql server 2005 CTP09, we can neither connect to reporting services trought Management Studio nore to reportserver.
Using Management Studion we are getting this message:

TITLE: Connect to Server
------------------------------
Cannot connect to XXXXXX.
------------------------------
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
------------------------------

Trying to connect to the ReportServer, it asks for a login/password, but the administrator account is not allowed.

Any idea

Regards

Ayzan.

Answer this question

Unable to use Reporting Services

  • GabrielMartin

    There is only one ISAPI Filter with no priority
    C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll
    There are no other ASP.NET applications

    Regards

    Ayzan

  • Lan Lan

    Can you connect to the report server using a browser   What is the error message, if any

    What is the setting for the reportserver virtual directory security in IIS.  Is it set to windows authentication   

    -Lukasz

    ---
    This posting is provided "AS IS" with no warranties, and confers no rights.

  • kdee

    Do you have any other web applications your computer   Are there any global ISAPI Filters that handle the request or is another ASP.NET application installed (you can check the c:\inetpub\wwwroot folder for a web.config file.

    -Lukasz

    ---
    This posting is provided "AS IS" with no warranties, and confers no rights.


  • elledibbi

    Check SQL Configuration Manager or Surface Area Configuration to ensure you're accepting remote TCP/IP connections.


  • WienerSchnitzel

    The problem seemed to come from a bad installation of IIS, and ASP.Net components. There is what I did:
    - Uninstall of IIS and Asp.Net Components (v1.1 and v2)
    - Restart
    - Install of IIS and Asp.Net through the Server Management Wizard
    - new install of SQL 2005

    Thank you all Big Smile

    Regards

    Ayzan

  • SSIS - newbie

    Check the Sql Server Surface Area Configuration or Configuration Manager and confirm you are accepting remote TCP/IP connections.


  • Zenubis

    Thanks Lukasz for you response.
    We can not connect to the report reser using the browser, it asks for a login/password, but even using the local machine admin account, the connection is refused.
    The virtual directory in IIS is set to windows authentication

    Regards

    Ayzan
  • Unable to use Reporting Services
Answer this question