Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when the network connection is disconnected on a computer that is running Store Operations: "Database connection lost, application will be closed Error #-2147467259"

Error message when the network connection is disconnected on a computer that is running Store Operations: "Database connection lost, application will be closed Error #-2147467259"

Symptoms

Consider the following scenario. You run Store Operations Manager or Store Operations POS against the Microsoft SQL Server 2005 database that is installed on the same computer. Then, the network connection is disconnected. In this scenario, you receive the following error message:
Database connection lost, application will be closed Error #-2147467259 [DBNETLIB][ConnectionWrite (send()).] General network error. Check your network documentation. (Source: Microsoft OLE DB provider for SQL Server) (SQL State: 08S01) (Native Error: 11) No Help file Available SELECT GETDATE() AS CurrentDateTime.
This problem occurs on a computer that is running Microsoft Dynamics Retail Management System Store Operations 2.0 and in Microsoft Retail Management System Store Operations 1.3.

↑ Back to the top

Cause

This problem occurs because the Local and remote connections option is enabled in the SQL Server Surface Area Configuration tool.

↑ Back to the top

Resolution

To resolve this problem, enable the Local connections only option instead of the Local and remote connections option. To do this, follow these steps:


  1. Exit all Microsoft RMS programs.
  2. Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.

  3. Click Surface Area Configuration for Services and Connections.

  4. Expand the instance of SQL Server 2005 that you use.


    Note By default, the name of the instance is MSSQLSERVER.
  5. Expand Database Engine, and then click Remote Connections.
  6. Click Local connections only, and then click Apply.

  7. Click OK.
  8. Restart the Database Engine service for this instance of SQL Server. To do this, follow these steps:
    1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.

    2. Click SQL Server 2005 Services.

    3. Right-click the instance of SQL Server 2005 that you use.

      Note By default, the name of the instance is MSSQLSERVER.
    4. Click Restart.

↑ Back to the top

Keywords: kbexpertiseinter, kbexpertiseadvanced, kberrmsg, kbmbspartner, kbexpertisebeginner, kbtshoot, kbmbsmigrate, kbprb, kb, kbarchive

↑ Back to the top

Article Info
Article ID : 937006
Revision : 1
Created on : 1/7/2017
Published on : 8/2/2011
Exists online : False
Views : 95