Remotely Accessing the SQL Server Desktop


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


Problem

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!

Solution

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 Jeremy Kadlec is the Co-Founder, Editor and Author at MSSQLTips.com, CTO @ Edgewood Solutions and a six time SQL Server MVP.

View all my tips
Related Resources





Comments For This Article





download





Recommended Reading

How to tell what SQL Server version you are running

Resolving could not open a connection to SQL Server errors

Identify SQL Server TCP IP port being used

Changing SQL Server Collation After Installation

Managing Maximum Number of Concurrent Connections in SQL Server








get free sql tips
agree to terms


Learn more about SQL Server tools