locked
SSRS 2012 MP (Native) - Bug with non-default port on SSRS DB, Does not discover RRS feed

  • Question

  • We have test changing SSRS DB instance to default port 1433 and discovery is immediate in SSRS MP. When using non-default port, discovery fails, SSRS instance role is never identified.

    Our SSRS is separated into app and db tires across two servers. Have tried creating sql network aliases, but this does not work either.

    In our environment, we use non-default port for our SQL DB instances. how do we get SSRS to discover.

    Thanks in advance,

    Rois Cordova

    Friday, February 13, 2015 5:09 PM

Answers

  • Hi,

    If you are using a dynamic port, please identify the port, do the following:

    1. Run SQL Server Configuration Manager.
    2. Open SQL Server Network Configuration.
    3. Open Protocols for INSTANCE1 (or the instance that is running under it).
    4. Open TCP/IP.
    5. Click IP Addresses.
    6. The port is under IPAll (usually the TCP Dynamic Ports).

    You may try turn off firewall on the server is there is any firewall configured and check the result.

    In addition, you may check operation manager event logs for more information regarding to this issue.

    Regards,

    Yan Li


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by Yan Li_ Monday, February 23, 2015 1:37 AM
    • Marked as answer by Yan Li_ Thursday, February 26, 2015 5:56 AM
    Tuesday, February 17, 2015 1:14 AM
  • The Monitoring Pack for Microsoft SQL Server 2012 Reporting Services automatically discovers instances of SSRS 2012 by reading registry.
    When the Monitoring Pack for Microsoft SQL Server 2012 Reporting Services is imported for the first time, it creates three new Run As profiles:
    • Microsoft SQL Server 2012 Reporting Services Discovery Run As Profile
    • Microsoft SQL Server 2012 Reporting Services Monitoring Run As Profile
    • Microsoft SQL Server 2012 Reporting Services SCOM SDK Discovery Run As Profile
    By default, all discoveries, monitors and rules defined in the SQL Server 2012 Reporting Services management pack use accounts defined in the “Default Action Account” Run As profile. If the default action account for a given system does not have the necessary permissions to discover or monitor the instance of SQL Server 2012 Reporting Services, then those systems can be bound to more specific credentials in the “Microsoft SQL Server 2012 Reporting Services …” Run As profiles, which do have access.
    It s recommend that you should check the default action account permission.


    Roger

    • Proposed as answer by Yan Li_ Monday, February 23, 2015 1:37 AM
    • Marked as answer by Yan Li_ Thursday, February 26, 2015 5:56 AM
    Tuesday, February 17, 2015 6:48 AM

All replies

  • Hi,

    If you are using a dynamic port, please identify the port, do the following:

    1. Run SQL Server Configuration Manager.
    2. Open SQL Server Network Configuration.
    3. Open Protocols for INSTANCE1 (or the instance that is running under it).
    4. Open TCP/IP.
    5. Click IP Addresses.
    6. The port is under IPAll (usually the TCP Dynamic Ports).

    You may try turn off firewall on the server is there is any firewall configured and check the result.

    In addition, you may check operation manager event logs for more information regarding to this issue.

    Regards,

    Yan Li


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by Yan Li_ Monday, February 23, 2015 1:37 AM
    • Marked as answer by Yan Li_ Thursday, February 26, 2015 5:56 AM
    Tuesday, February 17, 2015 1:14 AM
  • The Monitoring Pack for Microsoft SQL Server 2012 Reporting Services automatically discovers instances of SSRS 2012 by reading registry.
    When the Monitoring Pack for Microsoft SQL Server 2012 Reporting Services is imported for the first time, it creates three new Run As profiles:
    • Microsoft SQL Server 2012 Reporting Services Discovery Run As Profile
    • Microsoft SQL Server 2012 Reporting Services Monitoring Run As Profile
    • Microsoft SQL Server 2012 Reporting Services SCOM SDK Discovery Run As Profile
    By default, all discoveries, monitors and rules defined in the SQL Server 2012 Reporting Services management pack use accounts defined in the “Default Action Account” Run As profile. If the default action account for a given system does not have the necessary permissions to discover or monitor the instance of SQL Server 2012 Reporting Services, then those systems can be bound to more specific credentials in the “Microsoft SQL Server 2012 Reporting Services …” Run As profiles, which do have access.
    It s recommend that you should check the default action account permission.


    Roger

    • Proposed as answer by Yan Li_ Monday, February 23, 2015 1:37 AM
    • Marked as answer by Yan Li_ Thursday, February 26, 2015 5:56 AM
    Tuesday, February 17, 2015 6:48 AM