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 |
|
avmreddy17
Posting Yak Master
180 Posts |
 Posted - 2008-11-04 : 17:47:06
|
| Hi All,I have a situation where SQL Server(SS1) is in "X" Domain and the users who has to connect to this SS1 are in a diff Domain "Y".What is best way to give access to the Users.1. SQL Server login2. Windows Authentication ( This needs a trust between X and Y )I am planning to use windows authentication Which is the better choice?Thanks |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2008-11-04 : 18:18:14
|
| There are a LOT of "it depends" answers to your question. In general, I prefer the Windows Authentication with domain trust idea, but establishing a trusted domain relationship has broader implications for your network adminstrators than just accessing this one SQL Server. Using the SQL Server Login narrows the concern, but has other concerns of its own that Windows Authentication addresses.---------------------------EmeraldCityDomains.com |
 |
|
|
|
|
|
SQL Server Connectivity