Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - mssql_connect() - Connecting to Different Port Numbers

By: FYIcenter.com

(Continued from previous topic...)

How To Connect with Different Port Numbers?

You know that SQL Server could be configured to accept connections with different TCP/IP port numbers. See other tutorial collections on how to view and configure SQL Server TCP/IP protocol.

If you installed SQL Server 2005 Express Edition with default settings, it should be running with instance name of "SQLEXPRESS" and port number of "1269" You can use the mssql_connect() function to connect to the server in 3 ways:

$con = mssql_connect('LOCALHOST','login','pass');
$con = mssql_connect('LOCALHOST\SQLEXPRESS','login','pass');
$con = mssql_connect('LOCALHOST,1269','login','pass');

Other ways of entering the server name and port number will not work. The PHP manual has this statement: "servername - The MS SQL server. It can also include a port number. e.g. hostname:port." The example is really for non-Windows systems. Try the following testing PHP script to find out:

<?php
  print("Calling 'LOCALHOST'\n");
  mssql_connect('LOCALHOST','sa','FYIcenter');

  print("Calling 'LOCALHOST\SQLEXPRESS'\n");
  mssql_connect('LOCALHOST\SQLEXPRESS','sa','FYIcenter');

  print("Calling 'LOCALHOST,1269'\n");
  mssql_connect('LOCALHOST,1269','sa','FYIcenter');

  print("Calling 'LOCALHOST,SQLEXPRESS'\n");
  mssql_connect('LOCALHOST,SQLEXPRESS','sa','FYIcenter');

  print("Calling 'LOCALHOST:SQLEXPRESS'\n");
  mssql_connect('LOCALHOST:SQLEXPRESS','sa','FYIcenter');

  print("Calling 'LOCALHOST:1269'\n");
  mssql_connect('LOCALHOST:1269','sa','FYIcenter');
?>

You will get:

Calling 'LOCALHOST'

Calling 'LOCALHOST\SQLEXPRESS'

Calling 'LOCALHOST,1269'

Calling 'LOCALHOST,SQLEXPRESS'
Warning: mssql_connect(): Unable to connect to server:  
LOCALHOST,SQLEXPRESS 

Calling 'LOCALHOST:SQLEXPRESS'
Warning: mssql_connect(): Unable to connect to server:  
LOCALHOST:SQLEXPRESS

Calling 'LOCALHOST:1269'
Warning: mssql_connect(): Unable to connect to server:  
LOCALHOST:1269

(Continued on next topic...)

  1. How To Download and Install PHP on Windows?
  2. How To Check Your PHP Installation?
  3. What Do You Need to Connect PHP to SQL Server?
  4. How to Turn on the MSSQL API Module?
  5. What Is Wrong with SQL Server Client Libarary DLL, ntwdblib.dll?
  6. What Happens If ntwdblib.dll Is Missing on Your Machine?
  7. Where to Find ntwdblib.dll Version 2000.80.194.0?
  8. How To Connect with Different Port Numbers?
  9. What Are Commonly Used MSSQL Functions in PHP?
  10. How To Disconnect from a SQL Server using mssql_close()?
  11. How To Select an Exiting Database using mssql_select_db()?
  12. How To Execute a SQL Statement using mssql_query()?
  13. How To Retrieve Error Messages using mssql_get_last_message()?
  14. How To Turn Off Warning Messages during PHP Execution?
  15. How To Receive Returning Result from a Query?
  16. How To Loop through Result Set Objects using mssql_fetch_array()?
  17. How To Retrieve Field Values using mssql_result()?
  18. How To List All Field Names in the Result Set using mssql_field_name()?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...