A parameter cannot be found that matches parameter name 'ApplicationIntent'

[pjvander]

When running, receive following:

A parameter cannot be found that matches parameter name 'ApplicationIntent'.
+ CategoryInfo : InvalidArgument: (:) [], ParameterBindingException
+ FullyQualifiedErrorId : NamedParameterNotFound

Current Versions:
PS C:> Get-Host | Select-Object Version ; Get-Module SqlServer

Version

5.1.22581.1
21.1.18226

Can't figure out what I'm missing.

eta:
PS C:\Users\Desktop\sql_diagrams> sqlcmd -?
Microsoft (R) SQL Server Command Line Tool
Version 15.0.2000.5 NT

[DanielLoth]

Hi @pjvander,

Thanks for reaching out.

Can you confirm you get output similar to this:

PS C:\> Get-Module SqlServer

ModuleType Version    Name                                ExportedCommands
---------- -------    ----                                ----------------
Script     21.1.18256 SqlServer                           {Add-RoleMember, Add-SqlAvailabilityDatabase, Add-SqlAvailabilityGroupListenerStaticIp, Add-SqlAzureAuthenticationContext...}

PS C:\> (Get-Module SqlServer).ExportedCommands

Key                                            Value                                         
---                                            -----                                         
Add-RoleMember                                 Add-RoleMember                                
Add-SqlAvailabilityDatabase                    Add-SqlAvailabilityDatabase                   
Add-SqlAvailabilityGroupListenerStaticIp       Add-SqlAvailabilityGroupListenerStaticIp      
Add-SqlAzureAuthenticationContext              Add-SqlAzureAuthenticationContext             
Add-SqlColumnEncryptionKeyValue                Add-SqlColumnEncryptionKeyValue               
Add-SqlFirewallRule                            Add-SqlFirewallRule                           
Add-SqlLogin                                   Add-SqlLogin                                  
Backup-ASDatabase                              Backup-ASDatabase                             
Backup-SqlDatabase                             Backup-SqlDatabase                            
Complete-SqlColumnMasterKeyRotation            Complete-SqlColumnMasterKeyRotation           
Convert-UrnToPath                              Convert-UrnToPath                             
ConvertFrom-EncodedSqlName                     ConvertFrom-EncodedSqlName                    
ConvertTo-EncodedSqlName                       ConvertTo-EncodedSqlName                      
Disable-SqlAlwaysOn                            Disable-SqlAlwaysOn                           
Enable-SqlAlwaysOn                             Enable-SqlAlwaysOn                            
Export-SqlVulnerabilityAssessmentBaselineSet   Export-SqlVulnerabilityAssessmentBaselineSet  
Export-SqlVulnerabilityAssessmentScan          Export-SqlVulnerabilityAssessmentScan         
Get-SqlAgent                                   Get-SqlAgent                                  
Get-SqlAgentJob                                Get-SqlAgentJob                               
Get-SqlAgentJobHistory                         Get-SqlAgentJobHistory                        
Get-SqlAgentJobSchedule                        Get-SqlAgentJobSchedule                       
Get-SqlAgentJobStep                            Get-SqlAgentJobStep                           
Get-SqlAgentSchedule                           Get-SqlAgentSchedule                          
Get-SqlAssessmentItem                          Get-SqlAssessmentItem                         
Get-SqlBackupHistory                           Get-SqlBackupHistory                          
Get-SqlColumnEncryptionKey                     Get-SqlColumnEncryptionKey                    
Get-SqlColumnMasterKey                         Get-SqlColumnMasterKey                        
Get-SqlCredential                              Get-SqlCredential                             
Get-SqlDatabase                                Get-SqlDatabase                               
Get-SqlErrorLog                                Get-SqlErrorLog                               
Get-SqlInstance                                Get-SqlInstance                               
Get-SqlLogin                                   Get-SqlLogin                                  
Get-SqlSensitivityClassification               Get-SqlSensitivityClassification              
Get-SqlSensitivityRecommendations              Get-SqlSensitivityRecommendations             
Get-SqlSmartAdmin                              Get-SqlSmartAdmin                             
Grant-SqlAvailabilityGroupCreateAnyDatabase    Grant-SqlAvailabilityGroupCreateAnyDatabase   
Import-SqlVulnerabilityAssessmentBaselineSet   Import-SqlVulnerabilityAssessmentBaselineSet  
Invoke-ASCmd                                   Invoke-ASCmd                                  
Invoke-PolicyEvaluation                        Invoke-PolicyEvaluation                       
Invoke-ProcessASDatabase                       Invoke-ProcessASDatabase                      
Invoke-ProcessCube                             Invoke-ProcessCube                            
Invoke-ProcessDimension                        Invoke-ProcessDimension                       
Invoke-ProcessPartition                        Invoke-ProcessPartition                       
Invoke-ProcessTable                            Invoke-ProcessTable                           
Invoke-SqlAssessment                           Invoke-SqlAssessment                          
Invoke-Sqlcmd                                  Invoke-Sqlcmd                                 
Invoke-SqlColumnMasterKeyRotation              Invoke-SqlColumnMasterKeyRotation             
Invoke-SqlVulnerabilityAssessmentScan          Invoke-SqlVulnerabilityAssessmentScan         
Join-SqlAvailabilityGroup                      Join-SqlAvailabilityGroup                     
Merge-Partition                                Merge-Partition                               
New-RestoreFolder                              New-RestoreFolder                             
New-RestoreLocation                            New-RestoreLocation                           
New-SqlAvailabilityGroup                       New-SqlAvailabilityGroup                      
New-SqlAvailabilityGroupListener               New-SqlAvailabilityGroupListener              
New-SqlAvailabilityReplica                     New-SqlAvailabilityReplica                    
New-SqlAzureKeyVaultColumnMasterKeySettings    New-SqlAzureKeyVaultColumnMasterKeySettings   
New-SqlBackupEncryptionOption                  New-SqlBackupEncryptionOption                 
New-SqlCertificateStoreColumnMasterKeySettings New-SqlCertificateStoreColumnMasterKeySettings
New-SqlCngColumnMasterKeySettings              New-SqlCngColumnMasterKeySettings             
New-SqlColumnEncryptionKey                     New-SqlColumnEncryptionKey                    
New-SqlColumnEncryptionKeyEncryptedValue       New-SqlColumnEncryptionKeyEncryptedValue      
New-SqlColumnEncryptionSettings                New-SqlColumnEncryptionSettings               
New-SqlColumnMasterKey                         New-SqlColumnMasterKey                        
New-SqlColumnMasterKeySettings                 New-SqlColumnMasterKeySettings                
New-SqlCredential                              New-SqlCredential                             
New-SqlCspColumnMasterKeySettings              New-SqlCspColumnMasterKeySettings             
New-SqlHADREndpoint                            New-SqlHADREndpoint                           
New-SqlVulnerabilityAssessmentBaseline         New-SqlVulnerabilityAssessmentBaseline        
New-SqlVulnerabilityAssessmentBaselineSet      New-SqlVulnerabilityAssessmentBaselineSet     
Read-SqlTableData                              Read-SqlTableData                             
Read-SqlViewData                               Read-SqlViewData                              
Read-SqlXEvent                                 Read-SqlXEvent                                
Remove-RoleMember                              Remove-RoleMember                             
Remove-SqlAvailabilityDatabase                 Remove-SqlAvailabilityDatabase                
Remove-SqlAvailabilityGroup                    Remove-SqlAvailabilityGroup                   
Remove-SqlAvailabilityReplica                  Remove-SqlAvailabilityReplica                 
Remove-SqlColumnEncryptionKey                  Remove-SqlColumnEncryptionKey                 
Remove-SqlColumnEncryptionKeyValue             Remove-SqlColumnEncryptionKeyValue            
Remove-SqlColumnMasterKey                      Remove-SqlColumnMasterKey                     
Remove-SqlCredential                           Remove-SqlCredential                          
Remove-SqlFirewallRule                         Remove-SqlFirewallRule                        
Remove-SqlLogin                                Remove-SqlLogin                               
Remove-SqlSensitivityClassification            Remove-SqlSensitivityClassification           
Restore-ASDatabase                             Restore-ASDatabase                            
Restore-SqlDatabase                            Restore-SqlDatabase                           
Resume-SqlAvailabilityDatabase                 Resume-SqlAvailabilityDatabase                
Revoke-SqlAvailabilityGroupCreateAnyDatabase   Revoke-SqlAvailabilityGroupCreateAnyDatabase  
Save-SqlMigrationReport                        Save-SqlMigrationReport                       
Set-SqlAuthenticationMode                      Set-SqlAuthenticationMode                     
Set-SqlAvailabilityGroup                       Set-SqlAvailabilityGroup                      
Set-SqlAvailabilityGroupListener               Set-SqlAvailabilityGroupListener              
Set-SqlAvailabilityReplica                     Set-SqlAvailabilityReplica                    
Set-SqlAvailabilityReplicaRoleToSecondary      Set-SqlAvailabilityReplicaRoleToSecondary     
Set-SqlColumnEncryption                        Set-SqlColumnEncryption                       
Set-SqlCredential                              Set-SqlCredential                             
Set-SqlErrorLog                                Set-SqlErrorLog                               
Set-SqlHADREndpoint                            Set-SqlHADREndpoint                           
Set-SqlNetworkConfiguration                    Set-SqlNetworkConfiguration                   
Set-SqlSensitivityClassification               Set-SqlSensitivityClassification              
Set-SqlSmartAdmin                              Set-SqlSmartAdmin                             
Start-SqlInstance                              Start-SqlInstance                             
Stop-SqlInstance                               Stop-SqlInstance                              
Suspend-SqlAvailabilityDatabase                Suspend-SqlAvailabilityDatabase               
Switch-SqlAvailabilityGroup                    Switch-SqlAvailabilityGroup                   
Test-SqlAvailabilityGroup                      Test-SqlAvailabilityGroup                     
Test-SqlAvailabilityReplica                    Test-SqlAvailabilityReplica                   
Test-SqlDatabaseReplicaState                   Test-SqlDatabaseReplicaState                  
Test-SqlSmartAdmin                             Test-SqlSmartAdmin                            
Write-SqlTableData                             Write-SqlTableData                            
Invoke-SqlNotebook                             Invoke-SqlNotebook                            
SQLSERVER:                                     SQLSERVER:                                    
Decode-SqlName                                 Decode-SqlName                                
Encode-SqlName                                 Encode-SqlName                                

You could also try forcefully reinstalling the SqlServer module like so:

Install-Module -Name SqlServer -AllowClobber -Force