Dynamics Community Forum Thread Details

Downloading Symbols from TESTINGSERVER Demo Database BC (21-0)
Invoke-Sqlcmd : Cannot open database "Demo Database BC (21-0)" requested by the login. The login failed.
Login failed for user 'ANANTSO\fs0539'.
At C:\Users\fs0539\Documents\Downloads\PermissionSetConversion\Convert-PermissionSets.psm1:499 char:13
+ $Apps = Invoke-Sqlcmd -ServerInstance $DatabaseServer -Database $ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException
+ FullyQualifiedErrorId : SqlExectionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

Invoke-Sqlcmd :
At C:\Users\fs0539\Documents\Downloads\PermissionSetConversion\Convert-PermissionSets.psm1:499 char:13
+ $Apps = Invoke-Sqlcmd -ServerInstance $DatabaseServer -Database $ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ParserError: (:) [Invoke-Sqlcmd], ParserException
+ FullyQualifiedErrorId : ExecutionFailureException,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

You cannot call a method on a null-valued expression.
At C:\Users\fs0539\Documents\Downloads\PermissionSetConversion\Convert-PermissionSets.psm1:502 char:17
+ ... $Apps | % { $_.Name = $_.Name.Replace('_Exclude_', '').TrimEnd('_')}
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull

Proccessing Symbols
Quering permissions from TESTINGSERVER Demo Database BC (21-0)
Invoke-Sqlcmd : Cannot open database "Demo Database BC (21-0)" requested by the login. The login failed.
Login failed for user 'ANANTSOL\fs0539'.
At C:\Users\fs0539\Documents\Downloads\PermissionSetConversion\Convert-PermissionSets.psm1:518 char:20
+ ... rmissions = Invoke-Sqlcmd -ServerInstance $DatabaseServer -Database $ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException
+ FullyQualifiedErrorId : SqlExectionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

Invoke-Sqlcmd :
At C:\Users\fs0539\Documents\Downloads\PermissionSetConversion\Convert-PermissionSets.psm1:518 char:20
+ ... rmissions = Invoke-Sqlcmd -ServerInstance $DatabaseServer -Database $ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ParserError: (:) [Invoke-Sqlcmd], ParserException
+ FullyQualifiedErrorId : ExecutionFailureException,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand
Convert-PermissionSets -DatabaseServer TESTINGSERVER -DatabaseName "Demo Database BC (21-0)" -Destination "C:\Users\Documents\Downloads\PermissionSetConversion"

After putting above command I'm getting below error please help me to resove this error.

Invoke-Sqlcmd : Cannot open database "Demo Database BC (21-0)" requested by the login. The login failed.
Login failed for user 'ANANTSOL\fs0539'.
At C:\Users\fs0539\Documents\Downloads\PermissionSetConversion\Convert-PermissionSets.psm1:558 char:34
+ ... leContent = Invoke-Sqlcmd -ServerInstance $DatabaseServer -Database $ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException
+ FullyQualifiedErrorId : SqlExectionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

Invoke-Sqlcmd :
At C:\Users\fs0539\Documents\Downloads\PermissionSetConversion\Convert-PermissionSets.psm1:558 char:34
+ ... leContent = Invoke-Sqlcmd -ServerInstance $DatabaseServer -Database $ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ParserError: (:) [Invoke-Sqlcmd], ParserException
+ FullyQualifiedErrorId : ExecutionFailureException,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

WritePermissionSets : Cannot validate argument on parameter 'PermissionSets'. The argument is null, empty, or an element of the argument
collection contains a null value. Supply a collection that does not contain any null values and then try the command again.
At C:\Users\fs0539\Documents\Downloads\PermissionSetConversion\Convert-PermissionSets.psm1:559 char:25
+ WritePermissionSets $PermissionSets $Destination $PermissionSetTa ...
+ ~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidData: (:) [WritePermissionSets], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,WritePermissionSets