Activity overview
Latest activity by cnwilson
I had followed instructions on https://documentation.red-gate.com/sm12/troubleshooting/can-t-log-in-to-sql-monitor-with-active-directory/incorrect-service-account-credentials but had no luck. Another member of our team followed those steps and got it working. I believe I may have reinserted those [settings] table records too quickly or not restarted services when I first attempted. Either way we are back in working order now and I'll know to clear those tables out each time we reset the service account credentials moving forward. Thanks again for the help ATurner. / comments
I had followed instructions on https://documentation.red-gate.com/sm12/troubleshooting/can-t-log-in-to-sql-monitor-with-active-directory/incorrect-service-account-credentials but had no luck. Anoth...
Technically we use it for both, but I mean the account running base monitor AND web server. I can separate it out from the account used to read and write to the SQL database used if needed. Judging from some other screenshots I've seen, is it possible that some more recent versions are showing the proper account in Windows Services for the Web Monitor service? Ours has it as Local System even though the Base Monitor does show the proper AD account. Thank you for the help ATurner! / comments
Technically we use it for both, but I mean the account running base monitor AND web server. I can separate it out from the account used to read and write to the SQL database used if needed.Judging ...
The credentials do not appear to be stored anywhere in that configuration file. The connection string has Integrated Security = True, so there is no location to update the password. I can update this to False and specify if that is what you mean. Ours below (with our servername changed): <connectionStrings> <add name="DataConnectionString" connectionString="Data Source=%%%.%%%.com;Initial Catalog=RedGateMonitor;Integrated Security=True;Max Pool Size=500;Connect Timeout=15;Encrypt=True;Trust Server Certificate=True;Packet Size=4096"/> </connectionStrings> / comments
The credentials do not appear to be stored anywhere in that configuration file. The connection string has Integrated Security = True, so there is no location to update the password. I can update th...
Forgot to add: I did attempt to update any credentials found in Credential Manager, but the only one for RedGate was SQL_Monitor_Installer_Account. The service account is also not locked in Active Directory and does have Administrator rights to the base monitor host servers. Most of the documentation I can find on this is acting as if the service account is locked out when you receive "incorrect service account credentials." / comments
Forgot to add: I did attempt to update any credentials found in Credential Manager, but the only one for RedGate was SQL_Monitor_Installer_Account. The service account is also not locked in Active ...
How do we reset SQLMonitor service account credentials?
Is there any way to update the service account's password without a full reinstall of the WebServer and Base Monitors? Our security regulations are requiring us to rotate the password regularly. Ev...
Yes, we are using the built in Server Waits alert. Is it possible to ignore secondary replicas with custom metric alerts? / comments
Yes, we are using the built in Server Waits alert. Is it possible to ignore secondary replicas with custom metric alerts?