Re: How to user mssql_connect to connect to a sql server other than on port 1433?

You can't specify the port when connecting with mssql_connect() but you can use the Client Network Utility (this is installed when you install the MS SQL Client tools on your PHP server) to create a server alias. The server alias includes the protocol, host name and port number you are using and you can use the alias as the host name parameter in mssql_connect(). - Frank > I am recently have a problem with the mssql_connection function: > > I have to connect to a sql server which it's service port has been modified > other than 1433. > > How should I define the server address? I had tried those ways(suppose the > port number:1111): > > 1. (local):1111 > 2. servername:1111 > 3. 127.0.0.1:1111 > > None of them worked. Thanks for your help.:) > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >