I need to clear up my understand of the relationship between the windows authenticated account and the microsoft account when connecting to a SQL Server instance. I'm currently able to connect with windows authentication but getting 'we couldn't authenticate with the credentials provided' error when using the MS account (I'm not typing my password in wrong) - which is making me think the two are separate entities even though they are the same username in the same domain? Am I right in saying the MS account would need to be added to the AD group alongside windows account in order to access?
I was originally getting the error 'a connection was established, but an error occurred... certificate chain not trusted' when signing in with MS account, so set up a certificate for encrypted connections (working with windows auth). This made me think that the MS account was authorised to connect to the server but just failing at certificate handshake, but I guess this was a red herring and it never could authenticate to the server in the first place?
Lastly, what authentication is used when a user is viewing a report from a client (e.g. phone app)? Is this defined in the report or does the user choose how to authenticate (it all seems to happen automatically, even though I have signed in with my organisation MS account)?
