Forum Discussion
Jack_Viljoen
Feb 22, 2022Brass Contributor
Azure SQL Database
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...
pazdedav
Feb 22, 2022MVP
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
Feb 25, 2022Brass Contributor
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
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_ChenMar 01, 2022MCTHope it will be helpful.
https://levelup.gitconnected.com/how-to-securely-connect-to-your-azure-sql-database-53348804baa3- Jack_ViljoenMar 01, 2022Brass ContributorThank-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.