Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Adrenaline Seed
Starting Member
10 Posts |
 Posted - 2009-01-20 : 17:24:54
|
| Hello,I have so many SQL servers I need to administrate piling up and none of them do I have access to open port 1433. I do have access to other ports like 80 and 3389.The question is, can I setup some sort of utility that will allow me to access the databases through port 80 so that I can remote administrate without needing to RDP into each and every server and manually run scripts, etc?Note: I can't change the SQL Server port away from 1433. |
|
|
shaunc
Starting Member
28 Posts |
Posted - 2009-01-21 : 13:17:46
|
| I'm not aware of anything specifically for SQL Server, but you might take a look at STunnel, http://www.stunnel.org . It lets you set up a secure SSL tunnel between your local machine and a remote machine. You can tell it to listen on a certain port (e.g. 80) and relay the decrypted traffic to a different port (e.g. 1433).Note that the machine running SQL Server can't be running anything else on port 80. If there's already a webserver running, for example, you will have to pick a different port. |
 |
|
|
Adrenaline Seed
Starting Member
10 Posts |
Posted - 2009-01-21 : 17:03:20
|
Thanks!quote:
Originally posted by shaunc
I'm not aware of anything specifically for SQL Server, but you might take a look at STunnel, http://www.stunnel.org . It lets you set up a secure SSL tunnel between your local machine and a remote machine. You can tell it to listen on a certain port (e.g. 80) and relay the decrypted traffic to a different port (e.g. 1433).Note that the machine running SQL Server can't be running anything else on port 80. If there's already a webserver running, for example, you will have to pick a different port.
|
|
|
|
|
|
|
Remote administration of sql through alternate por