Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To monitor an Azure SQL server using SQL Diagnostic Manager, you have to create a SQL Server user on the instance with the following minimum permissions:

Azure - Minimum permissions

  • db_datareader
  • View Definition
  • View Database State
  • Select
  • Execute
  • Connect

Azure - Recommended Permissions

  • Minimum permissions plus Control and db_datawriter.
Tip
Recommended permissions are on database level.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse