How can we help you today? How can we help you today?
Sergio Rocha

Activity overview

Latest activity by Sergio Rocha

Setting up OpenID Connect (OIDC) with Entra ID in Redgate Monitor
This article provides specific information on how to use Redgate Monitor's OpenID Connect authentication feature with Redgate Monitor. Please also consult https://documentation.red-gate.com/sm/addi...
Edited 1 follower 0 comments -1 votes
The operation could not be performed because OLE DB provider ... for linked server ... was unable to begin a distributed transaction (SQL Compare)
This error occurs because of the Transaction Isolation Level. By default, SQL Compare uses the Serializable Transaction Isolation Level, however this deployment requires a Transaction Isolation Lev...
Edited 1 follower 0 comments 2 votes
Body of Generated HTML Document is Blank
The body of the document you've generated using SQL Doc appears blank when you open it on a browser To fix this, generate the documentation again with the Use frames option disabled. This is a defa...
Edited 1 follower 0 comments -3 votes
An error occurred during the pre-login handshake
If you receive the error message: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate...
Edited 2 followers 0 comments 2 votes
The target principal name is incorrect
If you receive the error message: Microsoft.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process (provider: SS...
Edited 1 follower 0 comments -6 votes
SQL Source Control can't access this database - make sure the database is online and you have permission to access it
Besides the causes mentioned in the actual error message (the database being offline or the user used to connect in SSMS not having permissions) this can also be caused by Certificate Validation is...
Edited 1 follower 0 comments -27 votes
Could not install SqlChangeAutomation from any registered PSRepository
This can be caused by connection issues to the PowerShell Gallery or because the connection does not meet the encryption standard required to connect to the PowerShell Gallery, please see this arti...
Edited 2 followers 0 comments -2 votes
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
The SQL Change Automation add-on will attempt to download the latest version of the SQL Change Automation (SCA) Module from the PowerShell Gallery before carrying out the task at hand. This allows ...
Edited 1 follower 0 comments 1 vote
No match was found for the specified search criteria and module name 'SqlChangeAutomation'.
This issue can occur when using when you are using a SQL Change Automation Azure DevOps add-on, using an older task version, and the self-hosted agent you are using cannot download the SQL Change A...
Edited 1 follower 0 comments 0 votes