Failed to enumerate Microsoft SQL Server databases:

rdbox · May 7, 2019, 5:10pm

what to do in this situation?

duplicati is always launched with administrator rights

drwtsn32 · May 7, 2019, 5:51pm

I have no experience with SQL backups with Duplicati, but I do with other backup products.

Does the account Duplicati is running as have sysadmin rights on the SQL instance?

rdbox · May 7, 2019, 6:30pm

I don’t use MS SQL Server.
I have full administrator rights to Duplicati

rdbox · May 7, 2019, 6:31pm

but I have MS SQL Server installed in my system for my personal work.
How do I disable or fix this error?

drwtsn32 · May 8, 2019, 3:02am

Do you have MS SQL selected for backup?

rdbox · May 8, 2019, 4:39am

not. I did not change all the default settings.
And where can this be changed?

kees-z · May 8, 2019, 7:06am

Is the VC++ 2017 Redist package installed? If not, install it from here (32 bit version here).

Note: for older versions of Duplicati/AlphaVSS, the 2015 version was required, but for all current Duplicati versions, you need the 2017 version.

rdbox · May 8, 2019, 9:53am

that’s what you need to install?

rdbox · May 8, 2019, 9:55am

my version Duplicati - 2.0.4.5_beta_2018-11-28

rdbox · May 8, 2019, 11:22am

Please help me what to do ??

rdbox · May 8, 2019, 12:12pm

Installed version 2 did not help. The error persisted where support ?? i need help

Microsoft Visual C++ 2017 Redistributable (x86) - 14.16.27027
Microsoft Visual C++ 2017 Redistributable (x64) - 14.16.27027

drwtsn32 · May 8, 2019, 2:07pm

Well you must have configured a backup job. Edit that backup job and look at section 3 - Source Data. Can you post a screen shot of what you have selected?

rdbox · May 8, 2019, 3:21pm

@kees-z
@drwtsn32

this my problem

rdbox · May 8, 2019, 3:23pm

@kees-z
@drwtsn32
what should I do? what setting is needed

drwtsn32 · May 8, 2019, 3:47pm

Oh I see - thanks for that GIF (how did you make it, by the way?)

I am not sure what the issue is especially since you installed vcredist. Hopefully @kees-z has some more ideas.

Out of curiosity does the backup job run?

rdbox · May 8, 2019, 3:59pm

I use the excellent open-source program shareX
she can take screenshots and gif files

@kees-z
I’m waiting for you in search of a solution.

mnaiman · May 9, 2019, 9:19pm

Hi, code is here:

github.com

duplicati/duplicati/blob/master/Duplicati/Library/Snapshots/MSSQLUtility.cs

using Duplicati.Library.Common;
using Duplicati.Library.Common.IO;
using System;
using System.Collections.Generic;
using System.Linq;

namespace Duplicati.Library.Snapshots
{
    public class MSSQLDB : IEquatable<MSSQLDB>
    {
        public string Name { get; }
        public string ID { get; }
        public List<string> DataPaths { get; }

        public MSSQLDB(string Name, string ID, List<string> DataPaths)
        {
            this.Name = Name;
            this.ID = ID;
            this.DataPaths = DataPaths;
        }

This file has been truncated. show original

Do you have value here? Registry.GetValue(@“HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server”, “InstalledInstances”, “”)

Or there could be error with your VSS for SQL server which failed to enumerate.
What is in error log?

Do you have SQL Writer Service running?
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-writer-service?view=sql-server-2017

rdbox · May 9, 2019, 9:37pm

the service worked but I turned it off for a test to check how the duplicati service will work.

rdbox · May 9, 2019, 9:38pm

@mnaiman
what to do? how to remove the error

rdbox · May 9, 2019, 9:39pm

and what is it ? I do not have this kind of installed on my system