Forum Discussion
JasonVL
Oct 04, 2023Copper Contributor
Object reference not set to an instance of an object. (SqlMgmt)
Hello,
I'm running SSMS 19.0.2 and I'm getting an error 'Object reference not set to an instance of an object. (SqlMgmt)' when I expand Security | Server Roles, right click public and left click Properties. This only happens when attempting to view the properties for that one role and I'm able to view the properties for all other server roles. This appears to only happen when I'm connected to any of our servers running 2016 (SP3-GDR) 13.0.6430.49 and doesn't happen when viewing the public server role properties on our servers running 2019 (RTM-CU22) 15.0.4322.2. Oddly enough, this doesn't happen at all when I try the same thing using SSMS 18.12.1. Does anyone know how to resolve this error in SSMS 19.0.2 or know if this is a known bug? I've included SSMS 19.0.2 details and error details below. Thank you in advance for any help you can offer!
Cheers,
Jason
SSMS 19.0.2 Details
SQL Server Management Studio 19.0.20209.0+f9a9d8f6
SQL Server Management Objects (SMO) 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973
Microsoft T-SQL Parser 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e
Microsoft Analysis Services Client Tools 16.0.19993.0
Microsoft Data Access Components (MDAC) 10.0.19041.2251
Microsoft MSXML 3.0 4.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19045
Error details
===================================
Object reference not set to an instance of an object. (SqlMgmt)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsSecurableSelectorNew.PopulateRootNodes()
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsSecurableSelectorNew.RefreshTreeView()
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsOfPrincipalsCoreNew.InitializeSecurableSelector()
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsOfPrincipalsCoreNew.InitializePermissionsOfPrincipalCore(Principal principal, Object connectionInfo, Boolean yukonOrGreater, Boolean showColumnPermissionsInDetailsGrid)
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsOfPrincipalsCoreNew..ctor(Principal principal, Object connectionInfo, Boolean yukonOrGreater, Boolean showColumnPermissionsInDetailsGrid)
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsServerPrincipalNew.InitializePermissionsCore()
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsServerPrincipalNew.OnInitialization()
at Microsoft.SqlServer.Management.RelationalEngineTasks.ServerRoleGeneralPageView.InitializePermissionsUI(CDataContainer dataContainer)
at Microsoft.SqlServer.Management.RelationalEngineTasks.ServerRoleGeneralPageView.InitializePermissionsUserControl()
at Microsoft.SqlServer.Management.RelationalEngineTasks.ServerRoleGeneralPageView.Initialize(ServerRoleManageController controller)
at Microsoft.SqlServer.Management.RelationalEngineTasks.ServerRoleManageController.get_View()
at Microsoft.SqlServer.Management.TaskForms.TaskFormControl2005UI.InitializeView(IController controller)
at Microsoft.SqlServer.Management.TaskForms.TaskFormControl2005UI.SetCurrentView(IController controller)
at Microsoft.SqlServer.Management.TaskForms.TaskFormControl2005UI.Initialize(TaskFormManager taskFormManager)
at Microsoft.SqlServer.Management.TaskForms.TaskFormManager.get_Control()
at Microsoft.SqlServer.Management.TaskForms.TaskFormDialogHost.Microsoft.SqlServer.Management.TaskForms.ITaskFormManagerHost.Initialize(ITaskFormManager control)
at Microsoft.SqlServer.Management.ActionHandlers.ShowTaskUIDialogActionHandler.RunTaskForm(IContext context)
at Microsoft.SqlServer.Management.ActionHandlers.DialogBasedActionHandler.RunTaskFormThread(Object contextObject)
2 Replies
Sort By
- olafhelperBronze Contributor
JasonVL , instead of search for a reason, uninstall SSMS and install the latest version from
Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) | Microsoft Learn
- JasonVLCopper ContributorI made a similar post with more details here:
https://feedback.azure.com/d365community/idea/da15dd0c-2569-ee11-a81c-6045bdb7ea56