Advertisement
Guest User

Untitled

a guest
Dec 15th, 2016
214
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. login:adacek1
  2.  
  3. ADO.NET (SQL authentication):
  4. Server=tcp:lausion.database.windows.net,1433;Initial Catalog=Helpdesk;Persist Security Info=False;User ID={your_username};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;
  5.  
  6. JDBC (SQL authentication)
  7. jdbc:sqlserver://lausion.database.windows.net:1433;database=Helpdesk;user=adacek1@lausion;password={your_password_here};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
  8.  
  9. ODBC (Includes Node.js) (SQL authentication)
  10. Driver={ODBC Driver 13 for SQL Server};Server=tcp:lausion.database.windows.net,1433;Database=Helpdesk;Uid=adacek1@lausion;Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;
  11.  
  12. PHP (SQL authentication)
  13. // PHP Data Objects(PDO) Sample Code:
  14. try {
  15. $conn = new PDO("sqlsrv:server = tcp:lausion.database.windows.net,1433; Database = Helpdesk", "adacek1", "{your_password_here}");
  16. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  17. }
  18. catch (PDOException $e) {
  19. print("Error connecting to SQL Server.");
  20. die(print_r($e));
  21. }
  22.  
  23. // SQL Server Extension Sample Code:
  24. $connectionInfo = array("UID" => "adacek1@lausion", "pwd" => "{your_password_here}", "Database" => "Helpdesk", "LoginTimeout" => 30, "Encrypt" => 1, "TrustServerCertificate" => 0);
  25. $serverName = "tcp:lausion.database.windows.net,1433";
  26. $conn = sqlsrv_connect($serverName, $connectionInfo);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement