Azure SQL Database

Question

Hi all,&nbsp;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?&nbsp;&nbsp;Any help will be appreciated!&nbsp;Thanks,Jack

pazdedav · Answer

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

jack_viljoen · Answer

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

jiadong_chen · Answer

Hope it will be helpful.https://levelup.gitconnected.com/how-to-securely-connect-to-your-azure-sql-database-53348804baa3

jack_viljoen · Answer

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.

Forum Discussion

Azure SQL Database

Share

Resources