Configure the Client Alias

This topic continues our discussion of the ODBC DSN setup for Crystal Reports that began in Setup ODBC DSN for Crystal Reports.

To change the client alias, you will need to open SQL Server Client Network Utility. Depending on your version of Windows, the executable for this application may reside in multiple locations on your computer. Choose the correct executable for your operating system based on the information provided below.

64-Bit Operating Systems

For 64-bit operating systems, you must start SQL Server Client Network Utility from the C:\Windows\SysWOW64 folder. Use the steps that follow to start the application.

  1. Browse to the C:\Windows\SysWOW64 folder.
  2. Double-click cliconfg.exe.

32-Bit Operating Systems:

For 32-bit operating systems, you must start SQL Server Client Network Utility from the C:\Windows\system32 folder. Use the steps that follow to start the application.

  1. Browse to the C:\Windows\system32 folder.
  2. Double-click cliconfg.exe.

  1. As an alternative, for 32-bit systems only, click Start, and then click Run or click in the Search box.
  2. Type cliconfg.exe and launch the executable to open SQL Server Client Network Utility.

SQL Server Client Network Utility

We will now show you how to add a new reports alias to SQL Server Client Network Utility.

  1. In SQL Server Client Network Utility, click the Alias tab.
  2. Click Add.

  1. In the Server alias box, type Reports.
  2. In the Network libraries pane, select TCP/IP.
  3. In the Server name box, located in the Connection parameters pane, type the name of your SQL server.
  4. Click OK.

Concept Link IconSee Also