can my phone run ssms inside our firewall?

  • Hi my phone is now upgraded to allow teams , outlook etc using my work account.   Its a portal more or less.

    Is there a way to leverage my new portal to run ssms from my phone so i can check on the status of a couple of jobs rather than carrying my pc around and using my hotspot in more remote areas i visit?

    • This topic was modified 3 months ago by  stan.
  • SSMS won't run on your phone. The most likely way of making this work is using some sort of remote access software to a PC which has SSMS installed.

    Unless you have the eyesight of an eagle, you'll be doing a lot of scrolling around. Not a great user experience.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • thx phil, i sat with our ops guy and learned vpn'ing wont happen from my phone.  just outlook using my work account, teams using my work account  and one note where i can at least see word docs.

    so like you say i wont be running ssms.   my head is switching to path of least resistance in sending sql agent job status info to outlook or one note.     im thinking it would be difficult to target a specific user's one note account from sql agent/ssis running on a sql server.    i'm also remembering its possible thru a certain view to return sql agent step results.  unless a step gets hung up in some of our ancient erp's, our etl job steps  move on to the next step whether successful or not.   i'll post back here after i revisit that view im thinking of.

  • As someone who has had (and currently has) VPN access on their phone AND RDP access on my phone, I do not recommend it. While it is possible, it is not fun to work with. You either get a mouse cursor the size of a pixel (really easy to click wrong buttons!!!) OR you get zoomed in and lots of scrolling around and getting annoyed with things. And get ready to lose half your screen real estate when the keyboard pops up... It's not a good user experience...

    What I would recommend is to get a laptop that you can take with you and use the laptop to VPN and access what you need. MUCH nicer user experience than on your phone and you can run SSMS! use phone for email and teams and word and such and leave the laptop off until you need to use it. Then the battery will be good for a few hours (if you charge it to full before you go) and you can fiddle around in SSMS.

    What I would recommend is to set up the jobs you care about to send you an email alert on failure (or success/completion if you really want that info). That or get a SQL monitoring tool to shoot you an email when a job succeeds and/or fails. Mind you, I'd still want to have a laptop handy so I could investigate what went wrong, but that's just me. Getting notified of something going wrong is step 1 and can be done via email and on a phone. Investigating the issue I would not want to be doing on a 7" screen. Give me a 14" laptop at a minimum (17" preferred for work things).

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply