“Adaptive Server is unavailable or does not exist” error connecting to SQL Server from PHP

by

1. See information about the SQL server

tsql -LH SERVER_IP_ADDRESS

locale is "C"
locale charset is "646"
ServerName TITAN
InstanceName MSSQLSERVER
IsClustered No
Version 8.00.194
tcp 1433
np \\TITAN\pipe\sql\query

2. Set your freetds.conf

tsql -C    
freetds.conf directory: /usr/local/etc

[TITAN]
host = SERVER_IP_ADDRESS
port = 1433
tds version = 7.2

3 Try

tsql -S TITAN -U user -P password

OR 

 'dsn' => 'dblib:host=TITAN:1433;dbname=YOURDBNAME',

See also http://www.freetds.org/userguide/confirminstall.htm (Example 3-5.)

If you get message 20009, remember you haven’t connected to the machine. It’s a configuration or network issue, not a protocol failure. Verify the server is up, has the name and IP address FreeTDS is using, and is listening to the configured port.

More Related Contents:

  1. Getting data with UTF-8 charset from MSSQL server using PHP FreeTDS extension
  2. SQL Server error 1934 occurs on INSERT to table with computed column PHP/PDO
  3. How to escape strings in SQL Server using PHP?
  4. PHP Fatal error: Call to undefined function mssql_connect()
  5. Connect PHP to MSSQL via PDO ODBC
  6. How can I detect a create, update, delete query is successful in Codeigniter
  7. Connect to SQL Server through PDO using SQL Server Driver
  8. How do I get the SQLSRV extension to work with PHP, since MSSQL is deprecated?
  9. Notice: Array to string conversion in
  10. Should a MAMP return ::1 as IP on localhost?
  11. How to connect to mssql using pdo through PHP and Linux?
  12. How to get Insert id in MSSQL in PHP?
  13. How to execute Stored Procedure from Laravel
  14. CodeIgniter MSSQL connection
  15. How to connect sql server with php using xampp?
  16. PHP + SQL Server – How to set charset for connection?
  17. Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs
  18. How to use PHP to connect to sql server
  19. How to execute a stored procedure in php using sqlsrv and “?” style parameters
  20. Linux – PHP 7.0 and MSSQL (Microsoft SQL)
  21. json_encode produce JSON_ERROR_UTF8 from MSSQL-SELECT
  22. Get Return Value from SQL Stored Procedure using PHP
  23. Is this curl post or get?
  24. PHP mysql search multiple tables using a keyword
  25. Column name or number of supplied values does not match table definition
  26. How to build a JSON array from mysql database
  27. How to generate unique id in MySQL?
  28. checking if a number is float in PHP
  29. Does query plan optimizer works well with joined/filtered table-valued functions?
  30. Add a row number to result set of a SQL query

Leave a Comment