SQL Server Client Network Utility

 

Back Office > Administration > SQL Tools > Miscellaneous Tools > SQL Server Client Network Utility

 

Description

 

This menu item is used to setup SQL Server aliases, database library options and more.

 

Adding an Alias to an SQL Server

 

This menu item allows, amongst other things, the user to perform a number of useful tasks, including setting up aliases for logging into SQL Servers. This allows users to setup an alias for a connection to a server that may exist over a wide area network and have it appear in the list of local servers. To setup an SQL Server login alias, follow these steps:

 

  1. Select the Alias tab.
     

 

  1. Select Add.
     

 

  1. Enter the Server alias. For example : BRISBANE.
  2. Select the Network libraries (Protocol) used to connect to the server. For example : TCP/IP.
  3. In the Server Name field, enter either the name or IP address of the server. For example : swiftpos.com.
  4. If you wish to specify the Port Number, un-tick the Dynamically determine port field and enter the port number used by the server. For example : 1433.
  5. Select OK, then press OK again.

 

Related Topics

 

  1. Installation
  2. SQL Server Management Studio
  3. SQL Tools

 

Published 28 Mar 2024