none
Reporting Services Server cannot connect to the DPM database. To repair the configuration, follow steps for repairing DPM from DPM Setup Help. ID: 3001 RRS feed

Answers

  • To access DPM reports, you will need to be a member of the local administrators group of the DPM server.

    What you are doing now is fixing an issue about scheduling email reports in DPM, a different thing :)

    You can send reports by email, this avoids you having the need for access to the DPM reports.


    Blog: https://thesystemcenterblog.com LinkedIn:


    • Edited by Leon Laude Thursday, September 12, 2019 12:03 PM
    • Marked as answer by SC2317 Thursday, September 12, 2019 12:38 PM
    Thursday, September 12, 2019 12:03 PM

All replies

  • Hi,

    If you can't search for Stored Procedures as mentioned in step 10 over here:
    “Reporting Services Server cannot connect to the DPM database” error when you try to schedule an email report in DPM

    Then you can add permissions to the stored procedures the following way:

    1. Expand the DPMDB database.

    2. Expand Programmability and then expand Stored Procedures.

    3. Locate the dbo.prc_MOM_Heartbeat_Get & dbo.prc_MOM_ProductionServer_Get stored procedures.

    4. Right-click the stored procedure and select Properties.

    5. Go to the Permissions tab.

    6. Click on Search and then add the local group (DPMDBReaders$<DPMServerName>) that you created in the earlier steps in the above link.

    Then continue to follow the next steps mentioned in the link.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Wednesday, September 11, 2019 11:01 PM
  • Hi Leon,

    Thanks. Now, I am getting this below error even after following the given steps in the article.

    Couldn't connect

    The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

    Hide error details Show error details

    Log on failed. Ensure the user name and password are correct.


    Thursday, September 12, 2019 10:50 AM
  • Did you follow the steps exactly as mentioned? It still looks like your data source is incorrect or that you are trying to connect with a user that has no permissions.

    Double check the server name and instance and catalog.

    Under the "Data sources" configuration in the SQL Server Reporting Services Web Portal, if you test the connection by clicking "Test Connection" what are the results?

    Also try testing the connection with the local user that you created earlier DPMR$<DPMServerName>


    Blog: https://thesystemcenterblog.com LinkedIn:


    • Edited by Leon Laude Thursday, September 12, 2019 10:59 AM
    Thursday, September 12, 2019 10:58 AM
  • Hi,

    Yes while clicking test connection button I am getting this error. Checking at the logs of SSRS, it says "System.ComponentModel.Win32Exception: Logon failure: the user has not been granted the requested logon type at this computer."

    Thursday, September 12, 2019 11:16 AM
  • And with which user are you testing with?

    Blog: https://thesystemcenterblog.com LinkedIn:

    Thursday, September 12, 2019 11:17 AM
  • User that is created locally using the steps mentioned in the article. i.e. DPMR$SERVERNAME
    Thursday, September 12, 2019 11:19 AM
  • Please post screenshots of the user and group you created, also of the permissions in the SQL server.

    Blog: https://thesystemcenterblog.com LinkedIn:

    Thursday, September 12, 2019 11:21 AM
  • Something related to below error in SSRS log file only as connection works fine if I add the user in local administrators group. However, I don't want that in local administrators. How can this be solved without adding the user in administrators group ?

    "Logon failure: the user has not been granted the requested logon type at this computer"


    • Edited by SC2317 Thursday, September 12, 2019 11:45 AM
    Thursday, September 12, 2019 11:44 AM
  • The users must be member of the local administrators of the DPM server, otherwise it won't work.

    Blog: https://thesystemcenterblog.com LinkedIn:

    Thursday, September 12, 2019 11:45 AM
  • Article does not mention that as it just says that add user in DPMDBReaders$<DPMServerName. 

    Does this needs to be modified in the article ?

    Thursday, September 12, 2019 11:47 AM
  • To access DPM reports, you will need to be a member of the local administrators group of the DPM server.

    What you are doing now is fixing an issue about scheduling email reports in DPM, a different thing :)

    You can send reports by email, this avoids you having the need for access to the DPM reports.


    Blog: https://thesystemcenterblog.com LinkedIn:


    • Edited by Leon Laude Thursday, September 12, 2019 12:03 PM
    • Marked as answer by SC2317 Thursday, September 12, 2019 12:38 PM
    Thursday, September 12, 2019 12:03 PM
  • Are you now able to schedule email reports?

    Blog: https://thesystemcenterblog.com LinkedIn:

    Thursday, September 12, 2019 12:27 PM
  • Yes, I am able to schedule reports now.
    Thursday, September 12, 2019 12:37 PM
  • Great to hear that!

    Blog: https://thesystemcenterblog.com LinkedIn:

    Thursday, September 12, 2019 12:41 PM