4.0.0 HP PolyServe Software for Microsoft SQL Server Administration Guide (T5392-96056, March 2010)

NOTE:
HP PolyServe Software needs to know the port that SQL clients will use to access the SQL database.
This means that SQL clients cannot use dynamic port assignment.
Certain SQL applications provide their own method to specify this information. If this is not the case
for your application, you can create an alias to simplify the amount of information that needs to be
entered. You can obtain the information needed for an alias on the HP PolyServe Management
Console.
To create an alias, use the SQL Server Client Network Utility (C:\winnt\system32\cliconfg.exe).
Select the Alias tab and then click Add.
You will need to enter the following information on the Add Network Library Configuration window.
Server alias: Specify the alias that you want to use for this instance.
Network library: Select TCP/IP.
Connection parameters: Enter the Virtual SQL Server’s fully qualified name or its IP address as the
server name. Then uncheck Dynamically determine port and specify the port number associated with
the SQL instance.
The following example creates the alias mySQL for Virtual SQL Server vqar4s6. Port number 40001
is assigned to the SQL instance associated with the databases to be accessed.
HP PolyServe Software for Microsoft SQL Server administration guide 67