| title | Shared Memory Properties | |
|---|---|---|
| ms.custom | seo-lt-2019 | |
| ms.date | 03/14/2017 | |
| ms.prod | sql | |
| ms.prod_service | sql-tools | |
| ms.reviewer | ||
| ms.technology | configuration | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | dc1704da-eacd-4d26-b529-c996f958ca4b | |
| author | markingmyname | |
| ms.author | maghan | |
| monikerRange | >=sql-server-2016||=sqlallproducts-allversions |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly] Use the Protocolpage on the Shared Memory Properties dialog box to enable or disable the shared memory protocol. Shared memory is the simplest protocol to use and has no configurable settings. Because clients using the shared memory protocol can only connect to a [!INCLUDEmsCoName] [!INCLUDEssNoVersion] instance running on the same computer, it is not useful for most database activity. Use the shared memory protocol for troubleshooting when you suspect the other protocols are configured incorrectly.
[!INCLUDEssNoVersion] must be restarted to enable or disable the protocol.
Enabled
Possible values are Yes and No. The shared memory protocol is enabled by default.
Choosing a Network Protocol
Creating a Valid Connection String Using Shared Memory Protocol