SQL in Cloud

SQL Azure Connection Strings

Wondering how to connect to SQL Azure databases? here are the connection string formats in ADO.Net , ODBC, PHP and JDBC to connect to the SQL Azure databases:

ADO.NET


Server=tcp:“{YourServer}”.database.windows.net,1433;Database=“{DatabaseName}”;User ID=“{UserNamer}”@”{YourServer}”;Password={your_password_here};Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

ODBC


Driver={SQL Server Native Client 11.0};Server=tcp:“{YourServer}”.database.windows.net,1433;Database=“{DatabaseName}”;Uid=“{UserNamer}”@”{YourServer}”;Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;

PHP


Server: “{YourServer}“.database.windows.net,1433 \r\nSQL Database: “{DatabaseName}”\r\nUser Name: “{UserNamer}“\r\n\r\nPHP Data Objects(PDO) Sample Code:\r\n\r\ntry {\r\n $conn = new PDO ( \”sqlsrv:server = tcp:”{YourServer}”.database.windows.net,1433; Database = “{DatabaseName}”\”, \””{UserNamer}“\”, \“{your_password_here}\“);\r\n $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );\r\n}\r\ncatch ( PDOException $e ) {\r\n print( \”Error connecting to SQL Server.\” );\r\n die(print_r($e));\r\n}\r\n\rSQL Server Extension Sample Code:\r\n\r\n$connectionInfo = array(\”UID\” => \””{UserNamer}”@”{YourServer}”\”, \”pwd\” => \”{your_password_here}\”, \”Database\” => \””{DatabaseName}”\”, \”LoginTimeout\” => 30, \”Encrypt\” => 1, \”TrustServerCertificate\” => 0);\r\n$serverName = \”tcp:”{YourServer}”.database.windows.net,1433\”;\r\n$conn = sqlsrv_connect($serverName, $connectionInfo);

JDBC


jdbc:sqlserver://”{YourServer}”.database.windows.net:1433;database=”{DatabaseName}”;user=”{UserNamer}”@”{YourServer}”;password={your_password_here};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;

« Diagnostic connections to SQL DB V12 Databases
Alter database – SQL Azure V12 »

Leave a comment Cancel reply

Your email address will not be published. Required fields are marked *

Pages

  • Alter database in SQL V12
  • Changing MAX_DOP setting in SQL Azure DB V12
  • Connection Pooling and Isolation level reset
  • Contained users in SQL Azure DB V12
  • Full-text search in SQL Azure
  • Large Index Rebuild in SQL Azure V12
  • Row versioning in SQL Database version (V12)
  • Sql Azure db – database offline

Archives

  • May 2016
  • December 2015
  • July 2015
  • May 2015
  • April 2015

Categories

  • SQL Azure (8)
  • Uncategorized (3)

WordPress

  • Log in
  • WordPress

Subscribe

  • Entries (RSS)
  • Comments (RSS)
  • Alter database in SQL V12
  • Changing MAX_DOP setting in SQL Azure DB V12
  • Connection Pooling and Isolation level reset
  • Contained users in SQL Azure DB V12
  • Full-text search in SQL Azure
  • Large Index Rebuild in SQL Azure V12
  • Row versioning in SQL Database version (V12)
  • Sql Azure db – database offline