Management data warehouse ( MDW ) SQL Authentication

• tony28

  SSCertifiable

  Points: 7108

  More actions

  August 9, 2021 at 11:00 am

  #3918073

  Hello,

  I have questions about MDW.

  I would like to collect data from more domain, but I have problem that there is not possible set with SQL USER and only domain user.

  I have

  -MDWServer in Doman1

  -Server1 in Domain1

  -Server2 in Domain2

  On Server1 is not possible problem to set and collect something ( cpu, queries and etc)

  On Server2 is not possible because I am not from same domain and this is gray for possible to set on SQL Authentication.

  Is there any setting or is not possible due to some security reason ?

   

  Thanks

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  August 10, 2021 at 11:10 am

  #3918401

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

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