Timeline for Linked Server with Windows Authentication Permissions
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 9, 2017 at 15:04 | vote | accept | ronniej962 | ||
| Aug 8, 2017 at 20:06 | comment | added | ronniej962 | Thanks for the reply McDonald - I can connect to the DB instance using SSMS and run queries against the DB that I've been given permission to. | |
| Aug 8, 2017 at 19:59 | comment | added | IT Thug Ninja | Ronnie - Where you get the error "“Login failed for user ‘domain\user'" are you sure that this domain user is defined and setup to CONNECT to the SQL Server instance the linked server points to, and that it has all other applicable permissions needed for the DB operations that will be made via the linked server using? The below answer has some helpful detail as well but I wanted to point out the super obvious just in case but be sure to understand the different configuration option as listed in Daniel's answer below too. | |
| Aug 8, 2017 at 19:45 | answer | added | Daniel Björk | timeline score: 10 | |
| Aug 8, 2017 at 19:14 | history | asked | ronniej962 | CC BY-SA 3.0 |