HOME > PHP > PHP Forum > error connect sql server ค่ะ ... Warning: mssql_connect(): message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (severity 14)
error connect sql server ค่ะ ... Warning: mssql_connect(): message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (severity 14)
คือsql server ลงไว้อีกเครื่องนึงน่ะค่ะ เลยต้องใช้ip แต่ว่ามันก้อ error แบบด้านล่างอ่ะค่ะ
ช่วยดูให้หน่อยนะค่ะแก้มา3วันแว้ว ยังconnectไม่ได้เลย
Code (PHP)
<?
$objConnect = mssql_connect("192.168.0.238","pkb","pkb") or die("Error Connect to Database");
$objDB = mssql_select_db("002",$objConnect);
$strSQL = "SELECT * FROM recipe ";
$objQuery = mssql_query($strSQL) or die ("Error Query [".$strSQL."]");
echo mssql_num_rows($objQuery);
?>
error
Warning: mssql_connect(): message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (severity 14) in c:\appserv\www\itemmanage\test3.php on line 2
Warning: mssql_connect(): Unable to connect to server: 192.168.0.238 in c:\appserv\www\itemmanage\test3.php on line 2
Error Connect to Database