Timeline for SQL Server - Linked Server - Using OPENROWSET with windows integrated security
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 16, 2022 at 9:00 | history | tweeted | twitter.com/StackDBAs/status/1526125325268172800 | ||
| May 16, 2022 at 8:01 | answer | added | Shamvil Kazmi | timeline score: 1 | |
| Oct 6, 2016 at 16:16 | history | edited | Marcello Miorelli |
added a tag = sql-server
|
|
| Feb 21, 2015 at 9:29 | comment | added | Jens D. | I guess you have got the typical problem with Kerberos: double hop. | |
| Feb 20, 2015 at 12:17 | history | edited | Marcello Miorelli | CC BY-SA 3.0 |
added 1852 characters in body
|
| Feb 20, 2015 at 10:30 | vote | accept | Marcello Miorelli | ||
| Feb 19, 2015 at 12:43 | answer | added | AA.SC | timeline score: 5 | |
| Feb 19, 2015 at 12:23 | comment | added | Marcello Miorelli | @MikaelEriksson Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. | |
| Feb 19, 2015 at 12:16 | comment | added | Mikael Eriksson |
So what happens if you use the first query in the article you have linked to? select a.* from openrowset('SQLNCLI', 'Server=myserver;Trusted_Connection=yes;', 'SELECT GETDATE() AS [RADHE]') as a
|
|
| Feb 19, 2015 at 12:03 | history | edited | Marcello Miorelli | CC BY-SA 3.0 |
added 175 characters in body
|
| Feb 19, 2015 at 11:24 | comment | added | Aasim Abdullah | Error you are facing ? | |
| Feb 19, 2015 at 11:11 | history | asked | Marcello Miorelli | CC BY-SA 3.0 |