23. Create Login and User for Dedicated SQL Pool in Azure Synapse Analytics

In this video, I discussed about creating login and user for dedicated sql pool in azure synapse analytics

Link for Azure Synapse Analytics Playlist:

Link for Azure Databricks Play list:

Link for Azure Functions Play list:

Link for Azure Basics Play list:

Link for Azure Data factory Play list:

Link for Azure Data Factory Real time Scenarios

Link for Azure LogicApps playlist

#Azure #AzureSynapse #AzureSynapseAnalytics

[MohammedKhan-npdn]

Hi Maheer, Thank for your Videos. Can you please make a video on workload management group and it's properties how it is controlled using workload management

[ttt]

I have a question, one of the managers of synapse is insisting that he hasnt created anything like logins using ssms or anywhere to access the dedicated sql server in one of our older synapse. But in the new synapse which is recently created users are unable to explore anything in the dedicated sql pool from the portal or even connect. It says login failed for user "., Any suggestions pls.

[pavankumar-nmyu]

Hi Maheer, I didn't get what is the actual difference between external tables and tables w.r.t dedicated sql pools. I have created one more adls account which is not linked to my synapse account and tried to query on blob and i am able to access the data. If we can access from adls which is not connected to synapse directly, what is the significance of this external tables? Can you please explain in detail...

[asatech]

Hi Maheer, for release DevOps pipeline. I am using Sql dacpac to deploy to Dedicated sql pool. My query is if I select SQL authentication then which user name & password I should mention for the pipeline to publish the dacpack to Dedicated SQL pool? or if I select AD Authentication then which user creds I should select?

[ultimatevexation]

if someone created the login password
can you retrieve it. for example the person is no longer in the project/company?