# MIcrosoft Azure portal

**URL:** <https://forum.robotframework.org/t/microsoft-azure-portal/6375>\
**Category:** DatabaseLibrary\
**Created:** [19 October 2023 15:01 UTC](https://forum.robotframework.org/t/microsoft-azure-portal/6375 "2023-10-19T15:01:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![automation\_user](https://avatars.discourse-cdn.com/v4/letter/a/d78d45/32.png) [@automation\_user](https://forum.robotframework.org/u/automation_user)\
**Post date:** [19 October 2023 15:01 UTC](https://forum.robotframework.org/t/microsoft-azure-portal/6375/1 "2023-10-19T15:01:16Z")

</div>

As per my test script requirement I am establishing database connection with sql server using Database Library and pyodbc and it was working perfectly fine with all my queries get executed and verify the query result with UI data

```python
DatabaseLibrary.Connect To Database pyodbc ${DBName} ${DBUser} ${DBPass} ${DBHost} ${DBPort}   

```

But now what happen our admin change the authentication method to sql server from SQL Server authentication to Azure Active Directory - Universal with MFA so now my script is failing

![image](https://europe1.discourse-cdn.com/flex005/uploads/robotframework1/original/2X/3/3ab3505b8d9f2a50b9c3d6db1b9d1c5512f6b3a3.png)

Can someone please provide me solution for this?

---

<div class="post-metadata">

**Author:** ![damies13](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robotframework.org/damies13/32/623_2.png) [@damies13](https://forum.robotframework.org/u/damies13)\
**Post date:** [19 October 2023 15:22 UTC](https://forum.robotframework.org/t/microsoft-azure-portal/6375/2 "2023-10-19T15:22:24Z")

</div>

Hi Gituwalia

I am no expert on this library, but a quick search about the problem turned up this → [Connect to Azure SQL in Python with MFA Active Directory Interactive Authentication without using Microsoft.IdentityModel.Clients.ActiveDirectory dll](https://stackoverflow.com/questions/58440480/connect-to-azure-sql-in-python-with-mfa-active-directory-interactive-authenticat)

It seems you need to somehow pass `Authentication='Active Directory Interactive'` to `pyodbc`perhaps with dbConfigFile, but I’m not sure.

Hopefully someone with more experience with this library can give you better guidance,

Dave.

---

<div class="post-metadata">

**Author:** ![Gazala](https://avatars.discourse-cdn.com/v4/letter/g/c57346/32.png) [@Gazala](https://forum.robotframework.org/u/Gazala)\
**Post date:** [22 February 2024 11:41 UTC](https://forum.robotframework.org/t/microsoft-azure-portal/6375/3 "2024-02-22T11:41:54Z")

</div>

Hello… Is your problem resolved. I am also trying to connect my azure database to robot framework. so need your inputs on same. Could you please help me if you are able establish connection.