Skip to content

mssqlserver-1-database-engine-error.md

Latest commit

 

History

History
60 lines (46 loc) · 3.46 KB

mssqlserver-1-database-engine-error.md

File metadata and controls

60 lines (46 loc) · 3.46 KB
title MSSQLSERVER_-1 | Microsoft Docs
ms.custom
ms.date 04/04/2017
ms.prod sql
ms.reviewer
ms.technology supportability
ms.topic language-reference
f1_keywords
-1
helpviewer_keywords
-1 (Database Engine error)
ms.assetid bad25b91-eaed-46c0-a5b7-71117a32304c
author MashaMSFT
ms.author mathoma

MSSQLSERVER_-1

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

Details
Product Name [!INCLUDEssNoVersion]
Event ID -1
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name
Message Text An error has occurred while establishing a connection to the server. When connecting to [!INCLUDEssNoVersion], this failure may be caused by the fact that under the default settings [!INCLUDEssNoVersion] does not allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (Microsoft [!INCLUDEssNoVersion], Error: -1)

Explanation

The [!INCLUDEssNoVersion] client cannot connect to the server. This error could be caused by one of the following reasons:

  • A specified [!INCLUDEssNoVersion] instance name is not valid.

  • The TCP, or named pipes protocols are not enabled.

  • The firewall on the server has refused the connection.

  • The [!INCLUDEssNoVersion] Browser service (sqlbrowser) is not started.

User Action

To resolve this error, try one of the following actions:

  • Check the spelling of the [!INCLUDEssNoVersion] instance name that is specified in the connection string.

  • Use the [!INCLUDEssNoVersion] Configuration Manager tool to enable [!INCLUDEssNoVersion] to accept remote connections over the TCP or named pipes protocols. For more information about the accepting remote connections, see Enable or Disable a Server Network Protocol.

  • Make sure that you have configured the firewall on the server instance of [!INCLUDEssNoVersion] to open ports for [!INCLUDEssNoVersion] and the [!INCLUDEssNoVersion] Browser port (UDP 1434).

  • Make sure that the [!INCLUDEssNoVersion] Browser service is started on the server.

See Also

Configure a Windows Firewall for Database Engine Access
Configure Client Protocols
Network Protocols and Network Libraries
Client Network Configuration
Configure Client Protocols
Enable or Disable a Server Network Protocol