PHP เออเร่อติดต่อฐานข้อมูล MS SQL ครับ Connection failed: SQLSTATE[HY000] [1045] Access denied
PHP เออเร่อติดต่อฐานข้อมูล MS SQL ครับ Code (PHP) <?php
$servername = "localhost";
$username = "sa";
$password = "......";
try {
$conn = new PDO("mysql:host=$servername;dbname=ELASTIC", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected successfully";
}
catch(PDOException $e)
{
echo "Connection failed: " . $e->getMessage();
}
?> Code (PHP) <html>
<head>
<title>ThaiCreate.Com PHP & SQL Server (sqlsrv)</title>
</head>
<body>
<?php
ini_set('display_errors', 1);
error_reporting(~0);
$serverName = "localhost";
$userName = "sa";
$userPassword = "....";
$dbName = ".....";
$connectionInfo = array("Database"=>$dbName, "UID"=>$userName, "PWD"=>$userPassword, "MultipleActiveResultSets"=>true);
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if($conn)
{
echo "OK Good Weerawat";
}
else
{
die( print_r( sqlsrv_errors(), true));
}
sqlsrv_close($conn);
?>
</body>
</html>
Tag PHP, Ms SQL Server 2016
Date :
2023-11-23 09:26:50By :
sweerawatView :
362Reply :
1
รหัสผ่านไม่ถูกครับCode (PHP) Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'sa'@'localhost' (using password: YES)
Date :
2023-11-23 12:31:23By :
Pong Thep
Server 02
Load balance : Server 02
