Can't connect to the SQL Server while using Microsoft authentication in Windows 10-CodePudding

I am using Windows 10 on my laptop. I have an Azure account and I use to login to my computer. I have installed SQL Server and Management Studio under this Azure account. So I can login to SQL Server with Management Studio anytime and I don't have any problem with that.

Now I have created another account on my computer with Microsoft Email ID. I can login with this hotmail email Id to the computer. But this time I can't login to SQL Server with Management Studio.

I get this error:

Can anyone tell me how I can login to SQL Server while using the Microsoft account?

CodePudding user response：

there is a default login for SQL Server with a UN = "sa" and its password usually is set while installation. try to figure out that and you may be able to connect.