Workaround for SMO Bug: urn could not be resolved at level OleDbProviderSetting
Microsoft ConnectM isn't letting me sign in to post this workaround, but I just ran into a bug with the OleDbProviderSettings within SMO.
To get around it, I used $server.Settings.OleDbProviderSettings instead of $server.OleDbProviderSettings
1$server.Settings.OleDbProviderSettings.Name.Contains("SQLOLEDB")
2True