SQL Server
      Back to home
      1. Knowledge Base
      2. Installation
      3. SQL Server

      Using Named Pipes for Microsoft SQL Server.

      Acctivate is configured to use the TCP/IP network option for connecting to the database server (i.e., Microsoft SQL Server).  TCP/IP is a standard, reliable protocol for network connections.

      However, some computers may have trouble with one or more client workstations connecting to the SQL Server using TCP/IP.  For example, the following Unable to login to the database server message may appear on one or more workstations.

      We’ve found that switching to the Named Pipes protocol usually resolves this problem.  Use the following procedure only on the workstation(s) with the connection problem.

      1. Hit the Windows key + 'R' to open the Window's "Run" window.
      2. Type in "cliconfig" without the quotes and click "OK" or hit the enter key.
        1. cliconfig
      3. In the window that appears, click on the "Alias" tab
      4. In the Alias tab, click on the "Add" button.
      5. Enter the SQL Server Name\Instance in the Server Alias field and click OK.  “ServerName” is the Windows Computer Name for your SQL Server.
        net lib
      6. Click OK to save the settings and close the Client Network Utility.
      7. Launch Acctivate again and confirm there are no connection warnings.