Forum Discussion

Copper Contributor

Oct 27, 2021

Solved

"Object reference not set to an instance of an object. (SqlManagerUI)"

I have installed SSMS 18.10 and I have connected to Azure SQL Managed Instance, then trying to edit SQL Agent Job always failing to open and resulting is this error "Object reference not set to an ...

erinstellato
Feb 12, 2024
adamoumagaji I do not have that issue with SSMS 19.3, which is the latest release. Can you please try with SSMS 19.3? Thanks.

jainChetan

Copper Contributor

May 20, 2024

erinstellato

Hello Team,

I am faching same issue in my environment.

SQL AOAG with Windows 2 node FCI.

It has 3 instances.

This issue is coming in 2 instances ( there are total 4 instances of SQL server) on that server.

SSMS Version = 16.0.16091.0

Database version = 15.0.43603.2

Any help would be appreciated.

erinstellato

Microsoft

May 20, 2024

SSMS version 16.0.16091.0 is a preview (19 preview 3). As noted in the reply selected as best response, I noted that I cannot recreate with SSMS 19.3. Please try with that version, or the latest release of SSMS, which is 20.1.

jainChetan
Copper Contributor
Jul 08, 2024
erinstellato
SSMS version has been upgraded to 19.3 ( 19.3.4.0).

Currently, i am facing issue while adding replica to existing AOAG setup ( with 1 replica only - Primary).
- erinstellato
  Microsoft
  Jul 08, 2024
  jainChetan Can you please provide step by step instructions to create the problem that you are seeing? This original item was opened for Azure SQL Managed Instance and editing an Agent Job. You are talking about adding a replica to an AG, so I don't know what steps you are taking, what version of SQL to which you're connecting, etc. Also, please try the latest SSMS 20.x release to see if the problem still occurs there.