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 |
|
bpsintl
Posting Yak Master
132 Posts |
 Posted - 2011-01-14 : 11:02:03
|
| When you connect to a remote database via SSMS with username and login, is that secure?ie can someone "sniff" out the password like you can with unsecure ftp etc? |
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2011-01-19 : 08:57:17
|
| Anyone? |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-19 : 09:56:15
|
| It is not secure unless you're on an SSL VPN or some such. |
|
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2011-01-19 : 10:08:42
|
| Would it be easy for someone to get at your password then? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-19 : 10:54:59
|
| Not very easy, but certainly not impossible. What do you mean by "remote"? Is the server on your network? If so, why not use Windows Authentication? |
|
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2011-01-19 : 11:12:28
|
| No it's not on my network. It's a web-server with SQL 2008 on it and I connect to it via SSMS etc |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-19 : 14:46:34
|
| If you're connecting over the internet, then I'd strongly suggest using a VPN.If this is a hosted solution, then there's not much you can do. But you can find out what they support and what other hosting companies support. |
|
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2011-01-20 : 02:34:26
|
| It's a dedicated server that I have full access to. Can I use ssl somehow? I have that setup for the website but I've never used it for connecting to the database etc |
|
|
|
|
|
|
Connecting to remote sql server