Azure SQL Database

%3CLINGO-SUB%20id%3D%22lingo-sub-3199466%22%20slang%3D%22en-US%22%3EAzure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3199466%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20boss%20has%20created%20a%20new%20Azure%20database%20and%20has%20manually%20queried%20in%20a%20basic%20table.%20He%20is%20wanting%20to%20add%20me%20as%20a%20user%20so%20I%20can%20access%20the%20database%2C%20edit%2C%20etc.%20How%20can%20this%20be%20done%20and%20are%20there%20any%20steps%20we%20need%20to%20take%20before%20hand%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20will%20be%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EJack%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3200545%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3200545%22%20slang%3D%22en-US%22%3EIt%20depends%20how%20your%20Azure%20SQL%20Database%20was%20configured%3A%20it%20could%20either%20use%20SQL%20or%20Azure%20AD%20Authentication%2FAuthorization.%20You%20should%20check%20the%20following%20article%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Flogins-create-manage%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Flogins-create-manage%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all,

 

My boss has created a new Azure database and has manually queried in a basic table. He is wanting to add me as a user so I can access the database, edit, etc. How can this be done and are there any steps we need to take before hand? 

 

Any help will be appreciated!

 

Thanks,

Jack

4 Replies
It depends how your Azure SQL Database was configured: it could either use SQL or Azure AD Authentication/Authorization. You should check the following article: https://docs.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage
Hi David,

Thanks for the reply, I am still un clear after looking at the page linked. My boss is the admin for the azure database and I am added as a user within that. However we are wanting to create and manage users within SQL Server so that I can connect to his SQL DB through my own PC on SQL Server.

Hope this makes sense.

Thanks,

Jack
Thank-you, we actually managed to get it all done by searching around in Azure and online. I might use this link in the future if we need to do it again and forget how we did it aha.