I assume that your problem is with SQL Server Management Studio? Only tip that comes in mind is that you should make sure that you are not using some very old version of SQL Server Management Studio.
bro i run this sql query but "Cannot alter the role 'db_owner', because it does not exist or you do not have permission." as error i saw in your videos you didnt have db onwer databse but i stuck i have project to done and it will help me to clear my assignment for getting job please help me in this
@@rugvedpatil5604 select your database, not the master one. When you run a query, in the top bar you can select for what database you run that query. I had the same issue.
Precise, helpful and straight to the point. Thank you very much!
You're welcome! :)
after searching a couple hours for a solution to build a working authentification to the sql databse, i finally found your video! thanks!
Very glad it helped! Using managed identity is one of the best and most secure ways of building this linked service.
What an awesome tutorial series. Definitely the best I've found so far.
Thank you, Aleksi! Keep churning the good stuff!
Awesome, thank you!
Thanks for providing concise explanations with practical labs, which are excellent for beginners like me.
Glad it was helpful!
thank you a lot , i've had this problem for 2 days !
Glad it helped
Thanks u very much for this video
Welcome!
Thanks very much for this tuto
You are welcome!
I do not get the option Azure Active Directory - Universal with MFA besides the Authentication dropdown. Any ideas on how to access it? :(
I assume that your problem is with SQL Server Management Studio? Only tip that comes in mind is that you should make sure that you are not using some very old version of SQL Server Management Studio.
bro i run this sql query but "Cannot alter the role 'db_owner', because it does not exist or you do not have permission." as error i saw in your videos you didnt have db onwer databse but i stuck i have project to done and it will help me to clear my assignment for getting job please help me in this
Hmm probably you don’t have sufficient access rights to that database to be able to grant db_owner to Data Factory
@@AleksiPartanenTech what I can do
@@rugvedpatil5604 select your database, not the master one. When you run a query, in the top bar you can select for what database you run that query. I had the same issue.
Hi @Aleksi , i have followed all steps in this lecture. It does not work for me
Hmm it should work and hard to say what is wrong with your setup. I would double check that everything was done according to the video