Activity overview
Latest activity by JoeLeBaron
2.5 years later, this is still a problem. The issue is the MFA. The token expires and a new one has to be acquired. I believe the default is 1 hour. SSMS handles this automatically, but SQL Prompt does not. Restarting SSMS causes SQL Prompt to restart and acquire the new token. Not a workable solution. / comments
2.5 years later, this is still a problem. The issue is the MFA. The token expires and a new one has to be acquired. I believe the default is 1 hour. SSMS handles this automatically, but SQL Pr...
The only other issue is that it keeps throwing license errors. We only have one license - so limited to monitoring 5 databases. We have a lot more databases on that server. You select which five you want to monitor - but there is no way to tell it to ignore the other db's. Every morning I have to dismiss the errors and all the others show up in all the lists. / comments
The only other issue is that it keeps throwing license errors. We only have one license - so limited to monitoring 5 databases. We have a lot more databases on that server. You select which fi...
Time change blocking SQL Monitor Logging
SQL Monitor 9.2.8.24491 (Web and Base)I have seen this twice now... I log in to SQL Monitor to discover that has not been logging anything for the last 8 hours. I check the event viewer on the ser...
Remove Unmonitored Databases
I am using Azure SQL DB's. I have 20 databases on one server, but I only want monitoring on one of those databases. I configure that under licensing, but the un-monitorred databases still show up...
I was able to get around this by specifying an AD group when it asked for the Administrator AD User. Since my AD Account is part of the group, I am able to log in. So instead of: me@domain.com I just typed the group name (with no domain prefix or suffix) and it worked. / comments
I was able to get around this by specifying an AD group when it asked for the Administrator AD User. Since my AD Account is part of the group, I am able to log in.So instead of:me@domain.com I ju...
Active Directory Locked Out After Upgrade to 9.2.4.24230
Just upgraded to the latest version and Active Directory Accounts were locked out.I followed the reset instructions: UPDATE settings.KeyValuePairs SET KeyValue = 0 WHERE KeyName = 'ActiveDirectory-...
Top Queries not Updating
When looking at my database top queries, they are not updating when I move the slider. The Top queries section refreshes, but the queries listed were not run in the timeframe I selected.I ran some...
For anyone else coming across this, I was only able to get this to work using the account user and password configured during server creation (aka: SA) / comments
For anyone else coming across this, I was only able to get this to work using the account user and password configured during server creation (aka: SA)
I just downloaded the SQL ToolBelt from that link and it is listing 9.1 in the installer / comments
I just downloaded the SQL ToolBelt from that link and it is listing 9.1 in the installer