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 |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
 Posted - 2005-09-13 : 15:23:58
|
| 1. Does anyone know of a way to use SQL Server Windows authentication from non-Windows clients, UNIX, LINUX, or from Windows clients that are not in a trusted domain?2. Is there any way to force the use of an encrypted connection to SQL Server, or to have a client send a SQL Server username/password encrypted?3. How do you usually handle authentication from non-Windows clients?CODO ERGO SUM |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-13 : 15:29:24
|
| 1. Those other clients can't use Windows Authentication as they aren't authenticating via a Windows domain. I could be wrong though.2. There's probably a third party tool out there to do this. We encrypt the passwords in the app.config, so what's sent over is encrypted already. 3. SQL authenticationTara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-14 : 02:59:46
|
| 1. a workaround would be to setup an application server, whose login is used for windows authentication, it'll be similar to a standard login but with an additional layer.2. encryption can be handled through vpn and/or the application (like what Tara said)3. sql authentication + approle, #1 + approleHTH--------------------keeping it simple... |
|
|
|
|
|
|
A Few Security Questions