Connection string of SQL database with Active Directory using user authentication

Question

I am connecting to a database on my Azure server where database is on different server and connection I made by choosing option Active Directory with user Credentials option. It is working in SQL server but I need a connection string to connect with DB. Any suggestions how to do it?

DxTx · Accepted Answer · 2018-04-23 08:15:00Z

8

If integrated, then use the below connection string:

Data Source=xxxxxxx.database.windows.net; Initial Catalog=xxxxxxx; Authentication=Active Directory Integrated;

If you're connecting using username and passsword:

Data Source=tcp:xxxxxxx.database.windows.net;Initial Catalog=xxxxxxx; Authentication=Active Directory Password; User ID=xxxxxxx; Password=xxxxxxx;

Reference: https://github.com/Huachao/azure-content/blob/master/articles/sql-database/sql-database-aad-authentication.md#7-connect-to-your-database-by-using-azure-active-directory-identities

edited Apr 23, 2018 at 8:15

DxTx

3,4434 gold badges30 silver badges39 bronze badges

answered Apr 23, 2018 at 7:54

DEEPAK LAKHOTIA

9935 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jason Ye · Accepted Answer · 2018-04-23 08:03:01Z

0

Also you can find the connection string via Azure portal:

Hope this helps.

answered Apr 23, 2018 at 8:03

Jason Ye

14k2 gold badges20 silver badges28 bronze badges

1 Comment

Jason Ye Over a year ago

Does this work for you? please let me know if you need more help, also if this helpful to you, please don't forget to accept it as an answer so that other community members will be benefited, thanks:)

Collectives™ on Stack Overflow

Connection string of SQL database with Active Directory using user authentication

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related