How Do I Enable SQL Server Protocols?

If you receive “Unable to connect to database server”, On the server, Start > Programs > Microsoft SQL Server folder > Configuration Tools > SQL Server Configuration Manager >Protocols for ACCTIVATE>Enable Named Pipes and TCP/IP protocols

When an instance of SQL Server is manually installed some connection protocols may be disabled by default.  After configuring Acctivate to connect to SQL Server, Acctivate may launch on the server, however you may receive an “Unable to connect to database server” error when launching Acctivate on the workstations.  To remedy this, you will need to enable these protocols.

  1. On the server, go to Start -> Programs -> Microsoft SQL Server folder.  Expand this folder, then Configuration Tools.
  2. Select to open SQL Server Configuration Manager.
StartSQLConfigMgr

  1. Expand the SQL Server Network Configuration section on the left hand side.
  2. Select the “Protocols for ACCTIVATE”, which is the named instance Acctivate is configured to connect to.  Your instance name may be different.
  3. On the right hand side, you should see four different protocols.  Enable Named Pipes and TCP/IP protocols.
SQLConfigMgr

  1. If either of these protocols were disabled, you will be prompted to restart the SQL Server Service.  Make sure to do this as changes will not take effect until this is done.