eazyBackup Knowledge Base
HomeLoginSupportContact
  • eazyBackup Knowledge Base
  • Guides
    • Getting Started Guide
    • Creating Protected Items
    • How to Backup Windows Network Shares and UNC Paths
    • How to Restore Files and Folders
    • Disk Image Backup Guide
    • Disk Image Backup Restore Guide
    • How to backup to a local storage vault (External or Internal Hard Drive)
    • Microsoft 365 Cloud Backup Guide
    • Microsoft 365 Cloud Backup Restore
    • Seed Load Walkthrough
    • eazyBackup Control Panel
    • Delete backup snapshots to reduce Storage Vault size
    • Kroll Pharmacy Management Database Backup
    • How to Backup Dentrix Database to the Cloud
    • How to Backup Patterson Eaglesoft Dental Software
    • Hyper-V Virtual Machine Backup Walkthrough
    • Storage Vault Usage Report
    • Linux Installation Guide (Debian, Ubuntu)
    • Two-Factor Authentication for Backup Accounts
    • Securing your Backup against Ransomware
    • How to move a backup to a new computer
  • Documentation
    • Add and Rename Storage Vaults
    • Available Storage Locations
    • How to Run Manual Backup
    • Backing up Windows Network Shares and UNC Paths
    • Browse Job History
    • Cancel a Running Backup Job
    • Commands
    • Backup Report Email Address
    • Custom Email Reports
    • Deleting a Protected Item
    • Disk Image Backup
    • eazyBackup Software Structure
    • Error “Access to the cloud file is denied” backing up OneDrive
    • Retention Concept
    • Confirm EFS keys are Exported (Windows EFS)
    • Data Encryption – Understanding Our AES-256 Encryption & Key Management
    • eazyBackup Chunking Overview
    • eazyBackup Chunking and Deduplication
    • Storage Vaults
    • Re-scan Unchanged Files
    • Required URLs and Ports for eazyBackup
    • Setting up a New Backup Account (license) in My Dashboard
    • Before and After Commands
    • eazyBackup Hotfix Install
    • Default File / Folder Exclusions From Backup
    • Restore from Deleted Protected Item
    • Random Job Delay – Protected Item Schedule
    • Copy a Protected Item Configuration to New Device
    • Manage Vaults on Protected Items – Add/Remove/Update
    • How to Remove a Registered Device
    • Retention Configuration and Cleanup
    • macOS Installation
    • Windows Installation
    • Linux (Other Distribution)
    • Linux (Red Hat Enterprise Linux (RHEL), CentOS)
    • Linux NAS (Synology, QNAP)
    • “Application-Aware Writer” Backups
    • “Microsoft Exchange Server” Backup
    • “Microsoft Hyper-V” Backup
    • “Microsoft SQL Server” Backup
    • “MySQL” Backup
    • “Program Output” items
    • “Windows Server System State” Backup
    • “Windows System Backup”
    • Silent installation for RMM (Windows advanced)
    • Microsoft 365 Backup
    • VMware vSphere Backup
  • Troubleshooting
    • Cannot proceed – another task needs to finish using the Storage Vault first
    • Change of hardware causes registration dialog to appear
    • Diagnosing Slow Backup Jobs
    • Error “EFS-encrypted files may be unusable once restored”
    • Error “Media is write protected” backing up OneDrive with VSS
    • Error “operation not permitted” macOS
    • Error “The target path ‘X:\WindowsImageBackup’ already exists – please safely remove this direct...
    • Error backing up item exit status 3 Couldn’t create virtual device set: Unknown error 0x80770005
    • Found packs in index but not appearing on disk. Reindex needed
    • Inactive / Abandoned “Running” Jobs
    • Lost connection to local service
    • Lstat: CreateFile \\?\UNC\ backup: Access is denied.
    • Mount path conflict: Can’t mount path inside real directory
    • OneDrive error “The tag present in the reparse point buffer is invalid”
    • Out of memory
    • Shared Memory Provider: Could not open a connection to SQL Server
    • VSS Error: Device is not ready
    • VSS Error: Couldn’t take snapshot. The shadow copy provider had an unexpected error while trying ...
    • Windows Backup encountered an error when writing data to the backup target.
    • Error “Access is denied” when backing up files and folders on Windows
    • Error “local error: tls: record overflow”
    • Microsoft SQL Server backup encountered a VDI error
    • Network Connectivity Errors
    • How to Locate All EFS Encrypted Files for Windows 10 and Server
    • Couldn’t save folder details: fs.TempFile: Access is denied
    • Couldn’t save Office 365 data for account – The requested user is invalid
    • WARNING Data error (cyclic redundancy check) occurred inside byte range
    • Set-Disk : Access Denied During Disk Image Backup
    • The System State encountered a problem: exit status 0xfffffffc
    • Runtime: VirtualAlloc of xx bytes failed with errno=1455 fatal error: out of memory
    • Disk Image Backup – Checking if device is ready: DeviceIoControl: The request could not be performed
    • Checking if device xx is ready: DeviceIoControl: The request failed due to a fatal device hardware..
    • x509 Certificate has expired or is not yet valid
    • Couldn’t load tree/xyz for subdirectory: tree/xyz not present in any index
    • Optimizing snapshot: not present in any index
    • Reading subdirectories of – Open: /Files/Documents/ operation not permitted
    • file truncated (expected xxxx bytes, got 0)
    • WARNING: Node (xxxx) filename.ext’ collision at position xxxx
    • How to easily find disks with read / write errors in Windows
    • Multiple connections to a server or shared resource error
    • Application failed to start because no Qt platform plugin could be initialized
    • OneDrive The cloud operation is not supported on a read-only volume
    • Hyper-V Error: Backing up exit status 1 (skipping)
  • FAQs
    • Account Devices and Billing
    • How can I restore my files to a new computer?
    • How to reset a backup account password
    • Can’t login to eazyBackup – Login information doesn’t work
    • Cloud Storage and Online Backup Service for Protected Health Information
    • How to cancel your eazyBackup subscription
  • eazyBackup Rebranding
    • Backup Client and Control Panel Branding
    • White Label Email Configuration
  • e3 Object Storage
    • e3 Object Storage Pricing FAQs
    • Manage Billing
    • Delete Account
    • How to configure QNAP Hybrid Backup Sync to S3 Compatible Object Storage
    • How to Use Arq Backup with eazyBackup e3 Object Storage
    • How to use Synology Hyper Backup with eazyBackup e3 Object Storage
    • How to use Duplicati with eazyBackup e3 Object Storage
    • How to use rclone with eazyBackup e3 S3 Compatible Object Storage
Powered by GitBook
On this page
  • SQL Server Connection Details:
  • Server Address:
  • Drivers

Was this helpful?

  1. Troubleshooting

Shared Memory Provider: Could not open a connection to SQL Server

PreviousOut of memoryNextVSS Error: Device is not ready

Last updated 10 months ago

Was this helpful?

When performing a backup of an MSSQL database, you may receive the following errors in your job logs.

Couldn't connect to database: Shared Memory Provider: Could not open a connection to SQL Server [2].
Couldn't connect to database: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

This article aims to explain how eazyBackup connects connects to MSSQL databases and offer some basic troubleshooting steps.

SQL Server Connection Details:

Connection details should be supplied before selecting databases. eazyBackup will only connect to an SQL Server running on the local machine. You must enter the instance name, or leave the field blank to use the default instance.

Server Address:

The address is always localhost, eazyBackup does not use TCP addresses or TCP ports to connect to SQL Server instances. eazyBackup makes use of "Shared Memory" to connect to SQL Server instances.

If you encounter authentication issues connecting to your SQL Server, you must ensure that "Shared Memory protocol" is enabled in SQL Server Configuration Manager.

Open the SQL Server Configuration Manager:

Check that you have the Shared Memory protocol enabled

Drivers

Ensure you have the correct drivers installed so that eazyBackup can connect to your database.

OLE DB and ODBC are data access methods that use pluggable "drivers" / "providers" for connecting to databases like SQL Server. The following drivers for OLE DB / ODBC support SQL Server:

Driver
TLS 1.2 Support
Notes

MSOLEDBSQL

Yes

SQLNCLI11

Yes

SQLNCLI10

No

Included with SQL Server 2008

SQLNCLI

No

Included with SQL Server 2005

SQLOLEDB

No

Included with SQL Server (all versions); Included with Windows since XP / Server 2003

Find out which drivers you have installed.

  • for

    ODBC, Open the Run dialog and enter odbcad32.exe > check the "Drivers" tab; or

  • for

    OLE DB, via .

eazyBackup defaults to using the MSOLEDBSQL driver if available. If this driver is not available, the SQLNCLI11 and SQLOLEDB drivers will be used as a fallback. Authentication eazyBackup allows you to connect to SQL Server using either Windows authentication or native SQL Server authentication. If you are using SQL Server authentication, you must enter a valid username and password to connect to SQL Server. If you are using Windows authentication, you can either:

    • enter valid Windows credentials to impersonate that user account; or

    • leave the field blank, to connect as the logged-on account of the background backup.elevator service (normally running as the LOCAL SYSTEM Windows user account); or

    • enter NT SERVICE\backup.delegate with no password, to connect as the logged-on account of the background backup.delegate service (normally running as the NT SERVICE\backup.delegate Windows user account)

In addition, you may assign any Windows user account to have sysadmin rights within SQL Server. Multiple instances eazyBackup supports backing up multiple instances from SQL Server. You can select an instance for backup, by entering the instance name in the "Instance Name" field. Leave this field blank to use the default instance. eazyBackup automatically lists available instances for selection in the drop-down menu. Confirm the SQL Server is running.

All Programs >> Microsoft SQL Server xxxx >> Configuration Tools >> 
SQL Server Configuration Manager >> SQL Server Services, 
check if SQL Server service status is “Running”.


Included with SQL Server 2016 and 2017; Optional download from

Included with SQL Server 2012 and 2014; Optional download from

eazyBackup
https://www.microsoft.com/en-us/download/details.aspx?id=56730
https://www.microsoft.com/en-us/download/details.aspx?id=50402