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

Unable to Add Azure SQL Managed Instance

I updated to SQL Monitor v11.1.3.8144 and when I try to add an Azure SQL Managed Instance it initially looks like it connects (green check mark) and then turns to a red X. Show log displays the following error:

Setup extended events session
Internal SQL Monitor error
SqlException
Failed to update database "master" because the database is read-only.

I can log into the instance using SSMS and the username and password I am using with SQL Monitor. I am able to USE the master database and create a SP in the database so it is definitely not read only. The user that was created for SQL Monitor has the sysadmin role.

Any idea what I'm doing wrong?

-Tom
TUellner
0

Comments

11 comments

Sort by
  • ATurner
    Hi Tom

    Can you confirm the Tier that this managed instance is in?
    ATurner
    0
  • TUellner
    It is in Business Critical Gen5.
    TUellner
    0
  • ATurner
    Hi Tom

    I believe this to be related to a known bug. I shall let you know once there is a fix available.
    ATurner
    0
  • TUellner
    Thank you for checking. I look forward to the bug fix.
    TUellner
    0
  • Azhkanizkael
    ATurner said:
    Hi Tom

    I believe this to be related to a known bug. I shall let you know once there is a fix available. 
    Could you include me in on this fix? I'm getting this same issue.
    Azhkanizkael
    0
  • TUellner
    ATurner - Any progress on this? I can monitor my QA instance but not my production instance. Really do need this.
    TUellner
    0
  • TUellner
    ATurner said:
    Hi Tom

    I believe this to be related to a known bug. I shall let you know once there is a fix available. 
    Any progress on this?

    Adding some screen shots. As you can see, the login for this server is sysadmin so there should be no issue with master being read-only.


    TUellner
    0
  • ATurner
    Hi Tom

    The development team are still currently looking into this issue. I have raised it again with them today. 

    ATurner
    0
  • ATurner
    Hi Tom

    This issue should be fixed in 11.1.8
    ATurner
    0
  • Azhkanizkael
    ATurner said:
    Hi Tom

    This issue should be fixed in 11.1.8
    Do we have a ETA on the release date for this update?
    Azhkanizkael
    0
  • ATurner
    Hi Azhkanizkael

    This version is currently available, you can download it from  https://www.red-gate.com/products/dba/sql-monitor/entrypage/latest-version or through your SQL Monitor console.
    ATurner
    0

Add comment

Please sign in to leave a comment.