Team,
For an Azure PaaS SQL Database; I am trying to Generate the List of Users in the Database along with their Associated Permissions using Windows PS Command Export-DBAUser. However I receive the below error message. Can someone please help.
You cannot call a method on a null-valued expression.
At C:\Program Files\WindowsPowerShell\Modules\dbatools\1.1.101\allcommands.ps1:23090 char:13
+ $versionNameDesc = $versionName[$scriptVersion.ToString() ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull
Exception setting "TargetServerVersion": "Cannot convert null to type "Microsoft.SqlServer.Management.Smo.SqlServerVersion" due to enumeration values that are not
valid. Specify one of the following enumeration values and try again. The possible enumeration values are
"Version80,Version90,Version100,Version105,Version110,Version120,Version130,Version140,Version150"."
At C:\Program Files\WindowsPowerShell\Modules\dbatools\1.1.101\allcommands.ps1:23095 char:17
+ ... $ScriptingOptionsObject.TargetServerVersion = [Microsoft. ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], SetValueInvocationException
+ FullyQualifiedErrorId : ExceptionWhenSetting