Enabling Network Connection Protocols for New SQL Server 2005 Instances.

March 12, 2007 | KB: 1011774
Agenda Manager 7.1, Agenda Manager 7.2, Laserfiche Server - Team (MSDE) 7, Laserfiche Server - United (MS SQL) 7, Workflow Suite 7

Summary

By default, SQL Server 2005 does not enable network connectivity for new database instances. This affects any application trying to access the SQL Server instance from a network location.

Note: If you are upgrading a previous SQL Server 2000 instance, the network protocol settings are preserved.

More Information

Use the SQL Server Configuration Manager to enable network protocols.

To enable network protocols

  1. Click Start, point to All Programs, Microsoft SQL Server 2005, Configuration Tools, and select SQL Server Configuration Manager.
  2. Expand the SQL Server 2005 Network Configuration item.
  3. Select you SQL Server 2005 instance name.
  4. In the right-hand pane, perform one or both of the following:
    • For Agenda Manager 7.1/7.2: Double-click Named Pipes and set the Enabled option to Yes.
    • For Laserfiche Server 7.2 and Workflow Suite 7: Double-click TCP/IP and set the Enabled option to Yes.
  5. You must restart the SQL Server service before the changes take effect.