How To Get Connection String From Azure SQL Server

The Azure SQL connection string is important information for any application that wants to connect to the Azure SQL database. In this article, we will discuss the steps to get the connection string for the Azure SQL database.

Table of Contents

How To Get Connection String From Azure SQL Server
Wrapping Up

How To Get Connection String From Azure SQL Server

To get connection string from Azure SQL Server, follow the steps below

Log in to the Azure Portal.
Search for SQL databases and click on the search result SQL databases.

3. On the SQL databases window, you can see the lists of Azure SQL databases you have created. Click on the specific database for the one you want to find the connection string.

4. Click on the Connection strings link from the left navigation below.

Click on the ADO.NET tab to see the connection string for ADO.NET, and it will be like below.

Server=tcp:tsinfo.database.windows.net,1433;Initial Catalog=TsInfoSQLNewDB;Persist Security Info=False;User ID=rajkishore;Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

Then click on the JDBC tab to see the connection string for JDBC.

jdbc:sqlserver://tsinfo.database.windows.net:1433;database=TsInfoSQLNewDB;user=rajkishore@tsinfo;password={your_password_here};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;

Click on the ODBC tab to see the connection string for ODBC.

Driver={ODBC Driver 13 for SQL Server};Server=tcp:tsinfo.database.windows.net,1433;Database=TsInfoSQLNewDB;Uid=rajkishore;Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;

Then, if you click on the PHP tab, you will see the connection string for PHP, and it will be like below.

<?php
// PHP Data Objects(PDO) Sample Code:
try {
    $conn = new PDO("sqlsrv:server = tcp:tsinfo.database.windows.net,1433; Database = TsInfoSQLNewDB", "rajkishore", "{your_password_here}");
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
    print("Error connecting to SQL Server.");
    die(print_r($e));
}

// SQL Server Extension Sample Code:
$connectionInfo = array("UID" => "rajkishore", "pwd" => "{your_password_here}", "Database" => "TsInfoSQLNewDB", "LoginTimeout" => 30, "Encrypt" => 1, "TrustServerCertificate" => 0);
$serverName = "tcp:tsinfo.database.windows.net,1433";
$conn = sqlsrv_connect($serverName, $connectionInfo);
?>

Finally, click on the Go tab to see the connection string, and it will be like the below

// Go connection Sample Code:
package main
import (
	_ "github.com/microsoft/go-mssqldb"
	"database/sql"
	"context"
	"log"
	"fmt"
	"errors"
)

var db *sql.DB
var server = "tsinfo.database.windows.net"
var port = 1433
var user = "rajkishore"
var password = "<your_password>"
var database = "TsInfoSQLNewDB"

func main() {
	// Build connection string
	connString := fmt.Sprintf("server=%s;user id=%s;password=%s;port=%d;database=%s;",
		server, user, password, port, database)
	var err error
	// Create connection pool
	db, err = sql.Open("sqlserver", connString)
	if err != nil {
		log.Fatal("Error creating connection pool: ", err.Error())
	}
	ctx := context.Background()
	err = db.PingContext(ctx)
	if err != nil {
		log.Fatal(err.Error())
	}
	fmt.Printf("Connected!")
}

Wrapping Up

This article discussed how to get connection string from Azure SQL Server using the above instructions. I hope this information will help you. Thanks for reading this article !!!

Rajkishore

I am Rajkishore, and I am a Microsoft Certified IT Consultant. I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machines, Logic Apps, PowerShell Commands, CLI Commands, Machine Learning, AI, Azure Cognitive Services, DevOps, etc. Not only that, I do have good real-time experience in designing and developing cloud-native data integrations on Azure or AWS, etc. I hope you will learn from these practical Azure tutorials. Read more.

How To Get Connection String From Azure SQL Server

Wrapping Up

DOWNLOAD FREE AZURE VIRTUAL MACHINE PDF