Post reply

Cannot connect to SSRS via SSMS *not a duplicate*

  • December 20, 2019 at 1:20 am

    #3709283

    I'm trying to connect remotly to SSRS via SSMS, I'm using the URL as follows https://serverdomain/reportserver also tried with http version, for athentication I'm using Basic Authentication with user as: DOMAIN\LocalUserName and its password, the response I'm getting is Object reference not set to an instance of an object.

    When trying from local with the http version it doesn't work either, BUT if I try using the default url that Configuration Manager provides http://DOMAIN/reportserver works but locally.

    This is driving me crazy, I followed steps to allow remote configuration via Reporting Servives Configuration Manager

    Also wierd behaviour, I can access the Report Server and Reports site from outside, but not from local, after I submit user and password, wont load the site, opposite when doing it from outside.

     

  • December 21, 2019 at 2:10 am

    #3709723

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • January 13, 2020 at 4:03 am

    #3714789

    SSRS configuration is not managed via SSMS. You can connect to SSRS instances via SSMS and view some basic stuff; jobs, security and shared schedules, but any configuration beyond this or service configuration is done via Reporting Services Configuration Manager or WMI calls. The link you posted talks about configuration of remote management of SSRS via Reporting Services Configuration Manager, not SSMS.

    Your login issues are a little vague, so maybe if you could provide additional info it would help:

    • What browser are you using?
    • What happens when you enter the URL and navigate there?

    • When you say you've configured it for "Basic Authentication", can you elaborate? Basic Auth isn't usually used in SSRS authentication, typically Integrated Authentication (Windows) is used or a custom authentication extension is written and used. I'm not even aware of a method to change this to basic auth without modifying the SSRS web config file, which is generally not required for most implementations.

    Prompting for usernames and passwords in SSRS typically indicates a problem with credential delegation. In Firefox and Chrome, this can be caused by NTLM settings that need updating (link). Also, validate your SPN configurations for SSRS as well (link and download).

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

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