Manage MS SQL server over SSH (putty)

Posted by adopilot on Server Fault See other posts from Server Fault or by adopilot
Published on 2010-01-28T18:17:00Z Indexed on 2010/03/21 19:21 UTC
Read the original article Hit count: 458

Filed under:

ssh

|

putty

|

sql-server

There is great implementation of PuttY for Symbian S60 devices, and last versions of Nokia phones with full QWERTY keyboard offers comfort for using Putty and SSH goodies. I start wondering is there a way to access MSSQL over SSH and send T-SQL commands. I am able to connect my router which running on FreeBSD OS, also other CentOS server with MYSQL are able to me over SSH. I want to try access MS-SQL-2005 from my mobile phone,

Probably this is not going to have daily use, it is just for geeky and justification to myself: why I had to buy so expensive a toy

© Server Fault or respective owner

Related posts about ssh

Problem with hadoop start-dfs.sh

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I installed and configured hadoop on my Ubuntu 14.04 server, virtualized inside of hyper-v, however I am getting an issue when i run start-dfs.sh root@sUbuntu01:/var/log# start-dfs.sh 14/06/04 15:27:08 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java… >>> More
SSH problems (ssh_exchange_identification: read: Connection reset by peer)

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I was running 11.10 and decided to do the full upgrade and come up to 12.04 after the update SSH (not SSHD) is now misbehaving when attempting to connect to other OpenSSH instances. I say OpenSSH as I am running a DropBear sshd on my router and I am able to connect to it. When attempting to connect… >>> More
SSH main process ended

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have a running ubuntu server 10.04.1. When I tried to login to the server via ssh, I could not. Instead, I got connection refused error. I tried to ping the machine and I got reply! So, the clear reason is that SSH daemon is stopped. After reboot, I was able to login to my server via ssh. After… >>> More
SSH server not working (respawns until stopped)

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have a running Ubuntu Server 10.04.1. When I tried to login to the server via ssh, I could not. Instead, I got connection refused error. I tried to ping the machine and I got reply! So, the clear reason is that SSH daemon is stopped. After reboot, I was able to login to my server via ssh. After… >>> More
Cannot SSH after resetting firewall on VPS

as seen on Server Fault - Search for 'Server Fault'
I'm having trouble trying to SSH to my Debian 5 VPS with blacknight. It was working fine until I did the following: Logged into 'Parallels Infrastructure Manager' - Container - Firewall - Set to 'Normal Firewall settings'. It told me there was an error with the IPTables and offered the option again… >>> More

Related posts about putty

"Stream" tar action from remote server through Putty?

as seen on Server Fault - Search for 'Server Fault'
I am accessing a shared hosting account through Putty / SSH. The account is pretty full, 300 MB below its quota. I need to make a full backup of all data present on the account. Creating a bzip2 file using tar cjf archive.tar.bz2 directory/* fails because there is not enough space for the tar… >>> More
Basic proxy with OpenSSH, Cygwin, Putty

as seen on Server Fault - Search for 'Server Fault'
I know this is probably a common question, but after looking around for a few hours (on this site and others), I can't find a solution. I'm trying to set up a simple proxy. I already have a server running Windows Server 2008. I've installed Cygwin and have OpenSSH installed. I also have sshd (the… >>> More
delete key prints "~" in putty

as seen on Server Fault - Search for 'Server Fault'
Hi, i am SSHing to a RHEL-3 box using Putty. Backspace works correctly, but when I press the "Delete" key the deletion does not happen. Instead, it prints "~" on the screen. Thanks in advance, Ajay >>> More
created pub/priv keys using putty, created .ssh folder and authorized_keys, still not working

as seen on Server Fault - Search for 'Server Fault'
created public/private keys using puttygen on my computer. put the public key in the .ssh/authorized_keys folder on the server setup pageant.exe to use the pk on my computer. when I run pageant, and connecting using putty it still asks me for my password. what am I missing? I did do a: chmod 700… >>> More
SSH Client - What are some alternatives to Putty that use tabs?

as seen on Super User - Search for 'Super User'
I've been using Putty for years now and it seems kind of dated. What are some good alternatives to Putty that use tabs to manage console sessions (managing individual putty windows is a messy pita). Edit: I've found the holy grail of SSH clients on SO, the PuTTY Connection Manager. Its the same old… >>> More