How can we help you today? How can we help you today?

Login failed for user - trying to add Azure SQL Server to Monitor

I am trying to add an Azure SQL server into SQL Monitor but I get a "login failed for user 'domain\login' error.  I have tried both my domain login and the AD account we have used for our on-prem servers with the same result.  Can someone advise what, if any, Azure roles (owner, contributor, etc) the chosen monitoring account needs to be in to allow the connection to succeed?
jonesric
0

Comments

4 comments

Sort by
  • Ben_P
    Hi @jonesricThe account used to monitor your Azure SQL Server must be the server admin account used to create the Azure SQL Server (mentioned at bottom of https://rd.gt/3prdnN3).
    Ben_P
    0
  • jonesric
    Hi @Ben_P thanks for that.  I found the same part of the documentation over the weekend.  Now to speak to the team who created the server(s).
    jonesric
    0
  • jonesric
    Hi @Ben_P to clarify, in our Azure portal when looking at the resource, it should be the login shown as the Server Admin in the Essentials section?

    Server admin: xxxxxxx
    jonesric
    0
  • Ben_P
    Hi @jonesric Yes, that's the one.
    Ben_P
    0

Add comment

Please sign in to leave a comment.