Configuring the setup application to use a non-default static port number for the database server
If the Microsoft® SQL Server® in your organization's environment does not use the default static port number (port 1433), the BlackBerry® Enterprise Server setup application cannot connect to the database server. Before you run the setup application, you must create an alias to the database server that specifies the port number that the database server is using. To configure an alias, you can use Microsoft SQL Server Configuration Manager or the cliconfg.exe tool. You can configure the name of the alias so that it is the same name as the Microsoft SQL Server. You must use the cliconfg.exe tool if the database server is Microsoft SQL Server 2000.
Create an alias to the database server using the Microsoft SQL Server Configuration Manager
- On the computer that you want to install a BlackBerry® Enterprise Server on, click Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.
- Expand SQL Native Client Configuration.
- Right-click Aliases. Click New Alias.
- In the Alias Name field, type the database server name.
- In the Port No field, type the static port number.
- In the Protocol drop-down list, click TCP/IP.
- In the Server field, type the database server name.
- Click OK.
Create an alias to the database server using the cliconfg.exe tool
- On the computer that you want to install a BlackBerry® Enterprise Server on, click Start > Run.
- Type cliconfg.exe.
- Click OK.
- On the Alias tab, click Add.
- In the Server alias field, type the database server name.
- In Network libraries, select TCP/IP.
- In the Connection Parameters, Server name field, type the database server name.
- Clear the Dynamically determine port check box.
- In the Port number field, type the port number.
- Click OK.