Activity overview
Latest activity by Sergio Rocha
High RAM usage in the Credential Guard service on servers hosting the Base Monitor service
DescriptionEver increased RAM usage in the Credential Guard service (lsalso.exe) in the server that hosts the Redgate Monitor Base Monitor service. Eventually, the server might crash.CausesThis app...
Hi Jason, Yes, I am afraid it will. / comments
Official comment
Hi Jason,Yes, I am afraid it will.
Hi Pam, I would suggest trying the following: 1 - Drop the Shadow Database and then refresh: this should force a rebuild of the Shadow Database 2 - If the above doesn't work and assuming that you are using the default Programmable Objects option (UseRepeatableScriptsForAllObjects), delete the scripts for all the problematic Views and Stored Procedures and add them again / comments
Official comment
Hi Pam,I would suggest trying the following:1 - Drop the Shadow Database and then refresh: this should force a rebuild of the Shadow Database2 - If the above doesn't work and assuming that you are ...
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...
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...
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...
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...
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...
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...
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...