Timeline for Linked server error- The table either does not exist or the current user does not have permissions on that table
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 22 at 8:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 15 at 9:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 16 at 5:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 12, 2023 at 23:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 14, 2023 at 7:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 9, 2023 at 16:19 | answer | added | vish | timeline score: 0 | |
| Jan 20, 2022 at 20:06 | comment | added | David Browne - Microsoft |
Usually a double-hop fails with Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON', but perhaps NT AUTHORITY\ANONYMOUS LOGON has a login, but lacks permissions to the target table.
|
|
| Jan 20, 2022 at 18:19 | comment | added | Marcin | Ok, so the problem most probable is with the 'double hop' Have you tried to configure connection between Server A and B using SQL Login? Check also this link: sqlservercentral.com/articles/… | |
| Jan 20, 2022 at 17:28 | comment | added | sqllover2020 | @Marcin- yes the queries work only when executing in SSMS from Server A. We have used the full qualified name. The issue is not querying from SQL. The issue happens when on the solution/app side. We even tried to give it temporary sysadmin permissions to just test and see if it executes w/o error, and it didnt help... | |
| Jan 20, 2022 at 16:57 | comment | added | Marcin | Are you query the view on Server A directly from that server or from remote server? Does the query that is used in view works when you execute it on Server A? Have you validated the database name on server B? To make it working on linked server it should be like that: [ServerB].[DB1].[SCHEMA].[TBL1] | |
| Jan 20, 2022 at 16:14 | comment | added | sqllover2020 | @Marcin- It is a Windows Domain acct | |
| Jan 20, 2022 at 16:14 | comment | added | sqllover2020 | @McNets - Yes I have, I forgot to mention that in my post. Thank you | |
| Jan 20, 2022 at 16:10 | comment | added | Marcin | The user you are using is SQL or Domain user? | |
| Jan 20, 2022 at 16:08 | comment | added | McNets | Have you granted select permissions to the view too? | |
| Jan 20, 2022 at 16:03 | history | asked | sqllover2020 | CC BY-SA 4.0 |