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:
- Bomgar
- CoPilot
- DameWare
- GoToAssist
- RealVNC
- Ultra VNC
- Symantec pcAnywhere
- If you have another favorite, remote access tool, please send us an email to tips@mssqltips.com to update this tip.
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
- Although getting direct access to the SQL Server console should not be a regular habit, knowing about the Remote Desktop /console switch can save significant time when needing to troubleshoot an issue.
- Remote Desktop has also recently sent out an updated version of the Remote Desktop application that can be directly downloaded from the Windows Update as an optional download.
- Check out the following related MSSQLTips.com tips:
- Special thanks to Doug K of the MSSQLTips.com community for this tip suggestion.
Jeremy Kadlec is a Founder, Editor and Author at MSSQLTips.com with more than 300 contributions and 25+ years of SQL Server experience. Jeremy leads a team of more than 300 authors helping millions of SQL Server professionals around the globe every second of the day for the last 20 years. He is also the CTO @ Edgewood Solutions and a six-time SQL Server MVP based on his community contributions. Jeremy brings 25+ years of SQL Server DBA and Developer knowledge to the community and holds a bachelor’s degree from SSU and master’s degree from UMBC.