...
Sure. However, it's a bit tricky since the system is tied in with SU's directory service. We highly reccommend recommend using our Remote Lab to accomplish this (see https://remotelab.ischool.syr.edu). If you'd like to proceed with connecting from your own installation of SQL Management Studio, see the tutorial below called Connecting to Microsoft SQL Server - Personal Device.
Can I access these services from off-campus?
Yes, but , and again we highly recommend using RemoteLab. Either way, you'll need to use the SU remote access tool. http://its.syr.edu/security/remoteaccess/sura.cfm
...