sql-database-include-connection-string-20-portalshots.md

title	description	keywords	services	author	manager	ms.service	ms.custom	ms.topic	ms.date	ms.author
Obtain the connection string from the Azure portal	Obtain the connection string from the Azure portal	sql connection,connection string	sql-database	dalechen	craigg	sql-database	develop apps	include	07/13/2018	ninarn

Obtain the connection string from the Azure portal

Use the Azure portal to obtain the connection string that's necessary for your client program to interact with Azure SQL Database.

1. Select All services > SQL databases.

2. Enter the name of your database into the filter text box near the upper left of the SQL databases blade.

3. Select the row for your database.

4. After the blade appears for your database, for visual convenience select the Minimize buttons to collapse the blades you used for browsing and database filtering.

5. On the blade for your database, select Show database connection strings.

6. Copy the appropriate connection string. i.e. If you intend to use the ADO.NET connection library, copy the appropriate string from the ADO.NET tab.

   

7. Edit the connection string as needed. i.e. Insert your password into the connection string, or remove "@<servername>" from the username if the username or server name are too long.

8. In one format or another, paste the connection string information into your client program code.

For more information, see Connection strings and configuration files.