SSMS Application Security idle session locking window

database-internalslockingssms

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.

Best Answer

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".