Post reply

Data Collector on Remote Server Not Showing Up in Management Data Warehouse Overview

  • December 20, 2011 at 8:48 am

    #248411

    I have set up the Management Data Warehouse and Data collection on dbserver01. I then went to dbaserver02 and only set up data collection and had it set to upload to dbserver01. All collection sets say they are active and jobs have no errors on dbserver02, but the data is not showing up when I view the Management Data Warehouse Overview on dbserver01.

    Both SQL Server versions are 10.50.2500, both are using domain accounts and I "believe" the proper accounts are mapped properly.

    Any thoughts? Not sure what other information is useful to provide here.

    Jared
    CE - Microsoft

  • December 20, 2011 at 8:59 am

    #1423711

    Off the topic, but I see two signature in your post. :w00t:

    Jared

    sqlknowitall.com

    Thanks,

    Jared

    SQL Know-It-All

    The one highlighted above, that link doesn't work.

    Finally, My Best wishes for your new blog (nice name)!!!

  • December 20, 2011 at 9:02 am

    #1423717

    Dev (12/20/2011)

    Off the topic, but I see two signature in your post. :w00t:

    Jared

    sqlknowitall.com

    Thanks,

    Jared

    SQL Know-It-All

    The one highlighted above, that link doesn't work.

    Finally, My Best wishes for your new blog (nice name)!!!

    Ha! It looks like it added my sig after I posted and then I created it. I fixed it 🙂 Thanks Dev! Hopefully it turns out to help people and force me to do some good research on my own.

    Jared
    CE - Microsoft

  • December 20, 2011 at 9:11 am

    #1423723

    Now you should avoid adding explicit signature... (check your last post :hehe:)

  • December 20, 2011 at 9:15 am

    #1423727

    Dev (12/20/2011)

    Now you should avoid adding explicit signature... (check your last post :hehe:)

    lol Habit!

    Jared
    CE - Microsoft

  • December 20, 2011 at 12:15 pm

    #1423874

    We got this working by double-checking the permissions for the domain user initiating the upload. I was looking at Data Collector logs instead of the SQL Server Agent logs. The SQL Server Agent logs DID show errors and I was able to troubleshoot using those. Permissions are extremely particular for Data Collector with MDW. Also, keep in mind that once MDW is set up, it is not easy to remove.

    Jared
    CE - Microsoft

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

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