FAQ ID # 41
Last Update : 2012/12/06
Print this FAQ

Question / Issue
Error connecting to SQL Server. A network-related or instance-specific error occured while establishing a connection to SQL server!

Answer / Solution

Error connecting to SQL Server.

Possible resolutions:

  1. Verify that the instance name is correct
    1. COMPUTERNAME\SQLINSTANCENAME
  2. Verify SQL Server is configured to allow remote connections.  (provider: Named Pipes Provider, error: 40)
    1. SQL Server Configuration Manager
      1. SQL Server Network Configurations
        1. Protocols for "SQLEXPRESS"
          1. Shared Memory - Enable
          2. Named Pipes - Enabled
          3. TCP/IP - Enabled
          4. VIA - Disabled (not nessassary.
    2. Restart SQL
  3. Verifly SQL Server Browser is running
    1. Services
    2. SQL Server Browser
      1. Status type - Automatic
      2. Status - Running


Direct Link to This FAQ
http://kb.hogandata.com/?f=41

Back to Top