Enabling TCP/IP on Microsoft SQL Server 2005

The information in this article applies to:

  • GFI EndPointSecurity 3
  • GFI EndPointSecurity 4
  • GFI EventsManager 7
  • GFI EventsManager 8
  • GFI FAXmaker for Exchange/SMTP 12
  • GFI FAXmaker for Exchange/SMTP 14
  • GFI LANguard Network Security Scanner 7
  • GFI MailArchiver for Exchange 4
  • GFI MailArchiver for Exchange 5
  • GFI MailArchiver for Exchange 6
  • GFI MailEssentials for Exchange/SMTP 12
  • GFI MailEssentials for Exchange/SMTP 14
  • GFI MailSecurity for Exchange/SMTP 10
  • GFI Network Server Monitor 7
  • GFI WebMonitor 2009 for ISA

Article ID: KBID002920

Query keywords: SQL Express

In order to connect to the Microsoft SQL Server 2005 remotely, TCP/IP needs to be enabled. This is disabled by default on Microsoft SQL Server 2005 Express edition. TCP/IP may also be manually disabled on other editions of Microsoft SQL Server 2005.

This article explains how to enable TCP/IP on Microsoft SQL Server 2005:

  1. From the Microsoft SQL Server 2005 -> Configuration Tools, open the 'Microsoft SQL Server Configuration Manager'.
     
  2. Expand ‘SQL Server 2005 Network Configuration’, and then click ‘Protocols for <Instance Name>’.
    <Instance Name> is the name of the instance of Microsoft SQL Express being used by the GFI product. 
     
  3. Right-click ‘TCP/IP’ and then click ‘Enable’. The icon for the protocol will change to show that the protocol is enabled.