question

Rahul-7230 avatar image
0 Votes"
Rahul-7230 asked ·

Azure AD with Azure SQL Database (Best Security approach in Connection String)

Hi,

In Azure SQL Database (Single Instance) what is the best approach for connecting to a Database ?

I want to maintain a connection string with Azure SQL DB without exposing the credentials. i.e.

Not using SQL authentication, wherein we provide username and password for logins and are only valid in the context of a specific database within the server

Need to use Azure AD authentication, use identities managed by Azure AD.

However I'm able to implement this (https://docs.microsoft.com/en-in/azure/sql-database/active-directory-interactive-connect-azure-sql-db) where we connect with Azure AD credentials.

But I need to maintain a connection string which is always active if I give Azure AD credentials in connection string it will get disconnected as Azure Session token might expire at some point of time.

Any Suggestion here how to achieve this maintain Azure SQL connection without exposing Azure AD credentials ?

(https://docs.microsoft.com/en-us/azure/sql-database/sql-database-security-tutorial#secure-connection-strings)

azure-active-directory
· 2
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Rahul-7230 It looks like we are already engaged in MSDN regarding this issue. I will update this thread once we finish our discussion in MSDN : https://social.msdn.microsoft.com/Forums/en-US/ee69d652-ae78-47ba-97a3-d0528c26ffb9/azure-ad-with-azure-sql-database-best-security-approach-in-connection-string?forum=WindowsAzureAD

0 Votes 0 · ·

@KAREDD-MSFT


Hey


I read something about security in your url. What type of security are you building. If you dont want to answer, believe that's fine.


I wish you a happy developing


Chousein Ali Kechagia


0 Votes 0 · ·
FarcasescuMarcela-9499 avatar image
0 Votes"
FarcasescuMarcela-9499 answered ·

This website is showing the 3 main options you could use:
[1]


[1]: https://support.citrix.com/article/CTX137556

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

huatuostudio avatar image
0 Votes"
huatuostudio answered ·

I'm also interested in this situation.

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.