How to: Connect on a Specified Port

This topic describes how to connect to SQL Server on a specified port with the Microsoft Drivers for PHP for SQL Server.

Verify the port on which the server is configured to accept connections. For information about configuring a server to accept connections on a specified port, see How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager).
Add the desired port to the $serverName parameter of the sqlsrv_connect function. Separate the server name and the port with a comma. For example, the following lines of code use the SQLSRV driver to demonstrate how to connect to a server named myServer on port 1521:
```
$serverName = "myServer, 1521";  
sqlsrv_connect( $serverName );  
```
The following lines of code use the PDO_SQLSRV driver to demonstrate how to connect to a server named myServer on port 1521:
```
$serverName = "(local), 1521";  
$database = "AdventureWorks";  
$conn = new PDO( "sqlsrv:server=$serverName;Database=$database", "", "");  
```

Feedback

Var den här sidan till hjälp?