Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Remotely Accessing the SQL Server Desktop

By:   |   Updated: 2007-03-05   |   Comments   |   Related: More > SQL Server Configurations

How can I get direct access to my SQL Server's desktop, not a terminal services session?  Do I need to purchase a third party product or is a tool available with Windows or SQL Server?  I know I should not need access to my SQL Server like this on a regular basis because I can manage my enterprise of SQL Servers via Management Studio or Enterprise Manager.  However, I want to find out if an option is available to keep in my back pocket in case a pop-up is on the desktop or I need to check to see if something unexpected has occurred on the SQL Server.

Check out the MSSQLTips RSS feeds and spread the word!

Luckily, the Remote Desktop application has a '/console' switch that can be enabled when it is started when executed from DOS.  This switch can give you direct access to the console as opposed to a terminal session.


Third Party Tools

Additional, remote access tools include:

Some of these tools have some bells and whistles when it comes to encryption support, 32 bit and 64 bit compatibilities, improved video drivers, enhanced file transfer, etc.  Check them out to see if they will meet your needs.

Next Steps

Last Updated: 2007-03-05

get scripts

next tip button

About the author
MSSQLTips author Jeremy Kadlec Since 2002, Jeremy Kadlec has delivered value to the global SQL Server community as an MSSQLTips.com co-founder and Edgewood Solutions SQL Server Consultant.

View all my tips
Related Resources

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools