We are running multiple versions of SQL Server Management Studio in our network, I believe from 2000 through 2017. For our security review we need to find out how to set an inactivity timeout in the SSMS application. Not a session timeout between SSMS & SQL Server but an inactivity timeout, and lock screen, for the GUI, if there is one. If there isn't one I need an explanation that I can give to our security folks that they will accept, preferably including a URL for the functionality. Any help would be greatly appreciated.
closed as off-topic by Philᵀᴹ, Max Vernon, Joe Obbish, Erik Darling, Josh Darnell May 14 at 2:10
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Philᵀᴹ, Max Vernon, Joe Obbish, Erik Darling, Josh Darnell
So you want SSMS to lock after a timeout and require the user to unlock it before continuing. All other applications that are open, and access to the OS / desktop UI, remain unlocked?
There isn't such a thing. There never has been such a thing AFAIK. I've worked with SQL Server's GUI tools for near-enough twenty years and I've never seen, heard or read of such a feature. Indeed, I can't think of any Windows desktop applications which does that. (Web apps do it when the OAuth token expires, but that's a different technology.)
You're not going to find documentation that says this feature doesn't exist, either, for the same reason you won't find a URL that says SSMS doesn't make banana smoothies. Software publishers document what their product does do. Unless it's written as a "can" it's a "can't".