Break Down an Azure Connection String for SQL Studio

Map values from an Azure SQL connection string into SQL Studio server connection fields.

Example Azure SQL connection string

Server=tcp:myserver.database.windows.net,1433;
Initial Catalog=mydatabase;
Persist Security Info=False;
User ID=myuser;
Password=MyStrongPassword!;
MultipleActiveResultSets=False;
Encrypt=True;
TrustServerCertificate=False;
Connection Timeout=30;

Field mapping for SQL Studio

• Description: Any friendly name (for example, Azure SQL Production).
• Hostname: Value after Server=tcp: and before comma. Example: myserver.database.windows.net.
• Port: Value after comma in Server. Usually 1433.
• Integrated Security: Leave off for standard Azure SQL username/password connections.
• Username: Value from User ID.
• Password: Value from Password.
• Database: Value from Initial Catalog.
• Encrypt: Set to enabled/required when Encrypt=True.
• Trust Certificate: Set off/false when TrustServerCertificate=False.

Notes for the SQL Studio screen

• The Database field is especially important for Azure SQL and should match Initial Catalog.
• Keep encryption enabled for Azure SQL.
• If login fails, confirm the SQL login exists and has database access.
• If firewall errors appear, allow your client IP in Azure SQL Server networking settings.

Quick checklist

• Hostname ends with database.windows.net.
• Port is 1433.
• Database value is present.
• Encrypt is enabled and trust certificate is disabled unless your environment requires otherwise.

Back to support articles