Windows 10: How to connect to Azure-hosted DB with Windows Auth on local workstation

Hello,


This is something we have wanted to implement for some time now, but it always falls to the wayside because higher priority tasks come up and SQL Auth works. We have several Azure VM's running, some dataservers and some webservers.


From our workstations we are only able to connect to our databases using SQL authentication, which is not ideal.


However, we can RDP to the SQL servers and from there use Windows Authentication with SSMS to log in successfully. Convenience and workflow are the reasons why we wouldn't want to do that, as well as the latency going through RDP introduces (it just feels slightly off).


We want to stop using SQL authentication because it just adds another headache to our work; Another password to remember, as well as being less secure.


We are using a VPN, which I guess tunnels to Azure but I'm not sure why we cannot authenticate with our windows credentials. How can we achieve this?


Thanks

:)

 

Add workstation to Network Browser in Windows 10 Pro with AD

Something so simple is driving me crazy: I have a Windows 10 Professional workstation with AD. In the Windows Explorer I see only other 6 workstations and the local PC. Has enable Network Discovery and I can connect to others workstation in the network.
The question is: why I see only 6 workstations and not the rest of the network? How can I add other host to the Network Browser list?

* All workstations are in the same VLAN

 

Windows 10 Azure AD to local

Hello,

I have a problem using my Azure AD profile in Windows 10. I have set up my Windows 10 PC using my organization Office 365 account (Azure AD). This caused a problem accessing my organization shared folders in file servers, it cannot recognize and connect.
I tried with a local Windows account and there was no problem. So I suppose I need to disconnect from Azure AD and go to a local administrator account for not having such a problem. I have 2 PCs with the same problem, I tried in one but it changed totally
the account, deleted the Azure and lost the installation and settings from that. Now I need to set up from the beginning the local account...

In order not to lose the data, installations, settings etc from the other computer (I have my whole work and licensed software in that), how could I just change to a local account from my Azure/Office365? I need to keep the whole profile but login locally,
not with my Office365 account. Is there any way to do that?

Thank you

 

Convert online Microsoft Azure account to local account?

Unfortunately, you cannot switch an Azure AD account to a local or Microsoft account. You need to create a new user account first, make it an admin account, then disconnect from your organizational account, restart and sign in to new local account.

All software remains installed and intact but all user specific customizations and settings are lost, new local user starting from scratch with default settings.

The whole process step by step:

1.) Copy your personal data (documents, images etc.) from current Azure AD user profile folder to respective folders in C:\Users\Public

2.) In Settings > Accounts > Other people, add a new local user (see Option One in this tutorial)

3.) Check that everything is correct, that you will see your Azure AD account under Work or school users (yellow highlight), and your new local admin account under Other people (blue highlight):





4.) Select Access work or school on left pane, select the connected Azure AD domain, click Disconnect:





5.) Click Yes:





6.) Click Disconnect:





7.) Enter the username and password for your new local admin account, click OK:





8.) Click Restart now:





9.) When back on desktop with your new local admin account, move personal data from Public folder and its subfolders you backed up in step 1 above to respective subfolders on new user profile folder. If the old Azure AD user profile folder is still present in Users folder, it can be deleted now.

That's it.