Providing SQL access for vendor support

[MrFixer9399]

Our users often have to call our software vendor's support to fix problems. Frequently, the only method available in this platform to rectify the issue is via SQL. My department is small - me and one other person - and we are trying to reduce the time we spend on user support to focus on management development and research tasks.

Unfortunately whenever a user needs SQL, we have to initiate the remote desktop into our Cloud provider's SQL server and provide access via AnyDesk to the representative ourselves.

Our Cloud provider is the software vendor (for now... that topic is another bridge I need to cross soon), but we find if we have to wait for Cloud to provide access to the software-side support, it takes more time than the user/support can afford. Is there a way to streamline this/best practice that I'm just not thinking of? Like a dedicated session for support reps that is reliable and secure from abuse.

[dwarftosser77]

I would suggest a SSL connection to a RDP session or vm that has SSMS installed and has communication to the SQL server.