Timeline for Cannot see other databases in SQL Server Managed Instances using Azure AD user
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 15, 2019 at 9: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. | |
| Nov 17, 2018 at 14:58 | history | edited | rdagumampan | CC BY-SA 4.0 |
Added containment modes
|
| Nov 17, 2018 at 11:52 | answer | added | SqlWorldWide | timeline score: 3 | |
| Nov 17, 2018 at 7:34 | answer | added | Md Haidar Ali Khan | timeline score: 0 | |
| Nov 17, 2018 at 7:22 | comment | added | rdagumampan | @MdHaidarAliKhan we two have issues here 1. accessing other databases when using AAD and 2. accessing linked servers with AAD. Jut not to confuse everyone here, we are referring to Azure SQL MI and On-prem databases. Azure SQL Database is completely different product and its NOT used in the case we're covering here :) | |
| Nov 17, 2018 at 7:16 | comment | added | Md Haidar Ali Khan | I believe that you linked server connection has been setup successfully with Azure SQL database. | |
| Nov 17, 2018 at 7:07 | comment | added | rdagumampan | @MdHaidarAliKhan No :). USER1 should be able to run his SSMS from his local machine, connects to SQL MI using his AAD account and perform cross database queries and cross server queries via linked servers. | |
| Nov 17, 2018 at 7:04 | comment | added | Md Haidar Ali Khan | As I believe DB1 & DB2 databases, you want to access from Azure. | |
| Nov 17, 2018 at 6:56 | history | edited | rdagumampan | CC BY-SA 4.0 |
added 67 characters in body
|
| Nov 17, 2018 at 6:50 | comment | added | rdagumampan | @MdHaidarAliKhan yes, our AAD is synced with our on-prem AD. Updated the question to reflect this. Its also on private VNet | |
| Nov 17, 2018 at 6:49 | history | edited | rdagumampan | CC BY-SA 4.0 |
added 67 characters in body
|
| Nov 17, 2018 at 6:47 | comment | added | Md Haidar Ali Khan | In your Environment there is "azure AD" is sync with "On-premises AD" or not. | |
| Nov 17, 2018 at 6:42 | history | edited | rdagumampan | CC BY-SA 4.0 |
edited title
|
| Nov 17, 2018 at 6:30 | history | asked | rdagumampan | CC BY-SA 4.0 |