Post reply

Reporting Services - SQL Studio

  • December 15, 2010 at 3:13 pm

    #146553

    I have SQL Reporting Services up and running.

    I can connect via IE browser, but when I am in SQL Management Studio and click "CONNECT OBJECT EXPLORER" and select SERVER TYPE of REPORTING SERVICES with SERVER NAME of ccxxspdb020\CC_IET (which is the sql instance where the reportserver databases reside, and the IIS site runs), and have AUTHENTICATION of WINDOWS AUTHENTICATION, I get a message....

    TITLE: Connect to Server

    ------------------------------

    Cannot connect to CCXXSPDB020\CC_IET.

    ------------------------------

    ADDITIONAL INFORMATION:

    Unable to connect to the remote server (Microsoft.SqlServer.Management.UI.RSClient)

    ------------------------------

    No connection could be made because the target machine actively refused it 10.243.254.107:80 (System)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    Any help would be appreciated....THX!

  • December 16, 2010 at 2:19 pm

    #1263729

    I found the problem.

    Within the rsreportserver.config file located in c:\program files\microsoft sql server\mssql.3\reporting services\reportserver

    there is a line that looks like this:

    <UrlRoot>http://ccxxspdb014/reportserver$cc_iet</UrlRoot&gt;

    It should have ccxxspdb020 instead of 014....wrong server name!!!:hehe:

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply