Post reply

Request to provide credentials on opening Report Manager

  • September 28, 2010 at 3:20 am

    #387883

    Every time I try to open the report manager (even from the SSRS server itself) it's asking me for a username and password. My current setup is as follows:

    SQL Server/SSRS 2008

    Windows Server 2008 using domain accounts

    SSRS Config: Service account using 'Network Service'

    Report server database credentials: Auth type set to Integrated security.

    I'm new to SSRS and I'm lost... any help would be really appreciated!

    Regards

    Brian

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

  • September 28, 2010 at 6:16 am

    #1228280

    Are trying to access the local or remote instance of SSRS?

    Raunak J

  • September 28, 2010 at 8:06 am

    #1228379

    Raunak Jhawar (9/28/2010)

    Are trying to access the local or remote instance of SSRS?

    The login prompt is displayed when accessing SSRS both locally and remotely.

    Thanks

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

  • September 28, 2010 at 8:14 am

    #1228385

    brian118 (9/28/2010)

    Raunak Jhawar (9/28/2010)

    Are trying to access the local or remote instance of SSRS?

    The login prompt is displayed when accessing SSRS both locally and remotely.

    Thanks

    Brian,

    I am leaving for the day..

    But please refer the security authentication config file located at Drive:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\ReportingServices\ReportServer\rsreportserver.config

    Scroll down to Authentication block.

    Raunak J

  • September 29, 2010 at 1:29 am

    #1228789

    Raunak Jhawar (9/28/2010)

    brian118 (9/28/2010)

    Raunak Jhawar (9/28/2010)

    Are trying to access the local or remote instance of SSRS?

    The login prompt is displayed when accessing SSRS both locally and remotely.

    Thanks

    Brian,

    I am leaving for the day..

    But please refer the security authentication config file located at Drive:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\ReportingServices\ReportServer\rsreportserver.config

    Scroll down to Authentication block.

    Thanks for your help!

    Below is what I have in the config file.... authentication block. I'm not using Kerberos. I've added the RSWindowsNegotiate yesterday and then restarted SSRS but no success!

    <Authentication>

    <AuthenticationTypes>

    <RSWindowsNegotiate/>

    <RSWindowsNTLM/>

    </AuthenticationTypes>

    <EnableAuthPersistence>true</EnableAuthPersistence>

    </Authentication>

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

Viewing 5 posts - 1 through 4 (of 4 total)

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