Timeline for Linked-server query against remote DB does NOT fail when DB is in SINGLE_USER mode
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 31, 2016 at 19:39 | answer | added | NateJ | timeline score: 0 | |
| Oct 31, 2016 at 19:36 | comment | added | NateJ | Let us continue this discussion in chat. | |
| Oct 31, 2016 at 19:36 | comment | added | Aaron Bertrand | Well, it is the point. You could use restricted_user if you didn't have so many users with elevated rights. | |
| Oct 31, 2016 at 19:35 | comment | added | NateJ | @AaronBertrand "Why" indeed. Not really the point, tho. I cannot seem to reproduce the problem so I'm going to close my question. Thanks for the tips guys! | |
| Oct 31, 2016 at 18:38 | comment | added | Aaron Bertrand | The problem with single user is that you only get one. This often gets stolen away by SQL Server Agent or another user you're not expecting. Why are so many people in the db_owner role? | |
| Oct 31, 2016 at 15:19 | comment | added | NateJ |
@AaronBertrand I have not, but that's interesting. My goal was basically to prevent all other users from accessing it, without taking it offline. In this case there are several other users in the db_owner role so restricted_user doesn't sound like a great fit, but... maybe.
|
|
| Oct 31, 2016 at 15:15 | comment | added | Aaron Bertrand | Have you considered using restricted user instead of single user? | |
| Oct 31, 2016 at 15:07 | comment | added | NateJ |
@Nic It's possible that nobody else was connected to MyDB at the time, not even me. I may have to test that theory.
|
|
| Oct 31, 2016 at 15:06 | comment | added | NateJ |
@WEI_DBA no, I'm logged in to Bar2008R2 & connected to MyDB as myself, a Windows login with admin rights.
|
|
| Oct 31, 2016 at 15:06 | comment | added | Nic | Being in single user mode will not implicitly prevent you from connecting. If it is the only connection to the database when you would still be able to access it. Have you tried maintaining a connection with SSMS and then attempting to access data via the linked server? | |
| Oct 31, 2016 at 15:05 | comment | added | SS_DBA | Is the User in the linked server the same as the user that has the db in single user mode? | |
| Oct 31, 2016 at 15:01 | history | asked | NateJ | CC BY-SA 3.0 |