Timeline for Is there any way to connect to one server and utilize a linked server using Windows authentication and NTLM?
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 3, 2013 at 22:14 | vote | accept | Christopher Garcia | ||
| May 29, 2013 at 18:02 | answer | added | Christopher Garcia | timeline score: 0 | |
| May 29, 2013 at 17:52 | answer | added | mrdenny | timeline score: 0 | |
| May 29, 2013 at 15:44 | history | edited | marc_s | CC BY-SA 3.0 |
added 12 characters in body
|
| May 29, 2013 at 3:30 | history | edited | Yasir Arsanukayev |
edited tags
|
|
| May 28, 2013 at 22:17 | comment | added | Nathan Jolly | Perhaps this SF question is similar enough to yours to be useful. I think that the short answer is that NTLM just doesn't work like that. If the powers that be are disinterested enough in security to not worry about Kerberos, perhaps they'll accept a linked server consideration that maps Windows logins to SQL logins. | |
| May 28, 2013 at 20:41 | history | edited | Christopher Garcia | CC BY-SA 3.0 |
added 159 characters in body
|
| May 28, 2013 at 20:39 | comment | added | Christopher Garcia | @Kin I should've clarified this earlier. The AD group has read access on the target SSAS linked server. The problem is that, due to NTLM limitations, they can't use the linked server from their workstation, they can only use it if they remote in to the server containing the SSAS linked server. | |
| May 28, 2013 at 20:09 | comment | added | Kin Shah | Refer to my answer at dba.stackexchange.com/questions/43013/… | |
| May 28, 2013 at 20:02 | history | asked | Christopher Garcia | CC BY-SA 3.0 |