Export-DBAUser Gives an Error Message for an Azure PaaS Database using PowerShel

  • 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

     

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply