Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- login:adacek1
- ADO.NET (SQL authentication):
- 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;
- JDBC (SQL authentication)
- 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;
- ODBC (Includes Node.js) (SQL authentication)
- 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;
- PHP (SQL authentication)
- // PHP Data Objects(PDO) Sample Code:
- try {
- $conn = new PDO("sqlsrv:server = tcp:lausion.database.windows.net,1433; Database = Helpdesk", "adacek1", "{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" => "adacek1@lausion", "pwd" => "{your_password_here}", "Database" => "Helpdesk", "LoginTimeout" => 30, "Encrypt" => 1, "TrustServerCertificate" => 0);
- $serverName = "tcp:lausion.database.windows.net,1433";
- $conn = sqlsrv_connect($serverName, $connectionInfo);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement