You get the following error message when running a SQL Change Automation Powershell:
Unable to resolve package source 'https://www.powershellgallery.com/api/v2'.
No match was found for the specified search criteria and module name 'SQLChangeAutomation'. Try Get-PSRepository to see all available registered module repositories.
This message indicates that connection between the agent where you are running SQL Change Automation and the Powershell Gallery is not possible.
This usually occurs due to network restrictions on the environment where the agent is hosted (Firewalls, Proxy Servers, etc).
You can't avoid this error message, however if you have previously installed SQL Change Automation Powershell on the agent, this error message is not fatal and can be treated as a warning (you will notice that the SQL Change Automation task proceeds normally after the error is displayed).
If the agent doesn't have SQL Change Automation Powershell installed, you can get an installer by logging in to the customer portal at selecting My Products.
Was this article helpful?
Articles in this section
- Method not found: 'System.Security.CodeAccessPermission
- Couldn't connect to the database specified by the Target parameter: A connection was successfully established with the server, but then an error occurred during the login process
- Could not install SqlChangeAutomation from any registered PSRepository
- System.Exception: No match was found for the specified search criteria and module name 'SQLChangeAutomation'. Try Get-PSRepository to see all available registered module repositories
- No match was found for the specified search criteria and module name 'SqlChangeAutomation'.
- Online index operations can only be performed in Enterprise edition of SQL Server
- Unable to resolve package source
- error 5(Access is denied.) while attempting to open or create the physical file
- SQL Change Automation Installation freezes at 99%
- SQL Change Automation Powershell permissions