Views:

On the TMCM or IMSS server, set up an alias pointing to SQL server database instance on the specified port. You must configure this in both 32-bit and 64-bit SQL Server Client Network Utility.

  1. Open the following:
    • C:\Windows\SysWOW64\cliconfg.exe
    • C:\Windows\cliconfg.exe
  2. Under General tab, add TCP/IP to the Enabled protocols by order field.
  3. Click Properties and change the value of the Default port field to the custom port used by the SQL server.
  4. Go to Alias tab, then click Add.
  5. Add a new alias in the Server alias field. Take note of this alias because you will need it during installation.
  6. In the Network libraries section, select TCP/IP radio button.
  7. In the Connection parameters section, specify the SQL server in the Server name field.
  8. Untick the Dynamically determine port check box.
  9. In the Port number field, enter the port number that SQL server is listening to.
  10. Click OK > OK. You can now specify the server alias name used in Step 5 during the production installation phase corresponding to the database.