4:36 CREATE USER [AlexDF] FROM EXTERNAL PROVIDER; ALTER ROLE db_owner ADD member [AlexDF]; SELECT * FROM sys.database_principals WHERE name = 'AlexDF'; SELECT * FROM sys.database_role_members WHERE member_principal_id = USER_ID('AlexDF');
thank you for the video, I spend about 90 min in the first 10 min for a connection failing issues in the DF after fixing some stuff the tables wasn't showing also after a lot of research I just closed the tab and open it and IT WORKED more mad than happy though 🙃😂
@@ashrithsd The fix for me was to go to the server then on the left menu networking then on the main page at the bottom under Exceptions make sure "Allow Azure services and resources to access this server" is selected
Keep improving your talents and seek God; He loves you and created you for great things. God bless you all and your families. "10 For we are His workmanship, created in Christ Jesus for good works, which God prepared beforehand that we should walk in them.". Ephesians 2:10. Read, please: Romans 10:8-13. To be save you need to be born again. God wants to change your life. 😊
Thank You Alex.
4:36
CREATE USER [AlexDF] FROM EXTERNAL PROVIDER;
ALTER ROLE db_owner ADD member [AlexDF];
SELECT * FROM sys.database_principals WHERE name = 'AlexDF';
SELECT * FROM sys.database_role_members WHERE member_principal_id = USER_ID('AlexDF');
thank you for the video, I spend about 90 min in the first 10 min for a connection failing issues in the DF after fixing some stuff the tables wasn't showing also after a lot of research I just closed the tab and open it and IT WORKED more mad than happy though 🙃😂
Hey, can you explain how to fix the connection failed error in Azure data Factory.......I'm facing the same issue. TIA.
@@ashrithsd The fix for me was to go to the server then on the left menu networking then on the main page at the bottom under Exceptions make sure "Allow Azure services and resources to access this server" is selected
@@jeip19 you are a hero
Thank you you for this video
I’m wondering if you can do some videos for power bi service, that would be helpful too
Hi Alex, I'm still getting the same connection error, though I have configured Azure data studio with the provided connecting SQL code.
Hi Alex, The series you did for Azure and AWS is for Data analyst or For Data Engineer?
Where do I find the start of this series?
Hi @AlexTheAnalyst, Please I'm stuck. i did ran the code but it's still failing when testing connection. i might be doing something wrong.
Hi , i am getting errors because of the change in IP each time , should i enable allow azure services to access this server in the firewall settings ?
Alex, do you have a course Data Engineering/Azure?
I have a full AWS and Azure course on Analyst Builder. Releasing a full series here on both on UA-cam too
@@AlexTheAnalyst Hi Alex do you have an Azure Data Engineering course. Can you please ping the links if possible 🙏
Who is looking for an online study partner?
@JuleeChan Data Analysis... you know SQL, Tableau, Python
🙌🙋🙋♀️🖐️✋
@@EDITV112 what's your email we connect?
I
Keep improving your talents and seek God; He loves you and created you for great things. God bless you all and your families.
"10 For we are His workmanship, created in Christ Jesus for good works, which God prepared beforehand that we should walk in them.".
Ephesians 2:10.
Read, please: Romans 10:8-13.
To be save you need to be born again. God wants to change your life. 😊