# Error: Failed to enumerate Microsoft SQL Server databases

**URL:** https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604
**Category:** Support
**Created:** [December 1, 2017, 10:27am UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604 "2017-12-01T10:27:23Z")
**Posts on this page:** 13
**Page:** 1

<div class="post-metadata">

### Author: ![Zusch](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/z/c77e96/32.png) [@Zusch](https://forum.duplicati.com/u/Zusch)
#### Post date: [December 1, 2017, 10:27am UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/1 "2017-12-01T10:27:23Z")

</div>

Hello,  
trying to edit a backup-job I get a Error-Popup showing:

> Failed to enumerate Microsoft SQL Server databases: Die Datei oder Assembly “AlphaVSS.x64.dll” oder eine AbhÃ¤ngigkeit davon wurde nicht gefunden. Das angegebene Modul wurde nicht gefunden.

Clicking OK I can edit the job.

How can I fix this?

Thanks,  
Zusch

---

<div class="post-metadata">

### Author: ![samw](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/s/9de053/32.png) [@samw](https://forum.duplicati.com/u/samw)
#### Post date: [December 2, 2017, 5:02am UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/2 "2017-12-02T05:02:22Z")

</div>

Hi @Zusch. Please make sure you are logged on as an admin. Run Duplicati in elevated mode by right clicking on the desktop icon and selecting “Run as Administrator”.

---

<div class="post-metadata">

### Author: ![Zusch](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/z/c77e96/32.png) [@Zusch](https://forum.duplicati.com/u/Zusch)
#### Post date: [December 2, 2017, 10:48pm UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/3 "2017-12-02T22:48:40Z")

</div>

Hi samw,  
I am running Duplicati 2 as Service under local system account. What should I change?

Thanks,  
Zusch

---

<div class="post-metadata">

### Author: ![samw](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/s/9de053/32.png) [@samw](https://forum.duplicati.com/u/samw)
#### Post date: [December 3, 2017, 1:16am UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/4 "2017-12-03T01:16:52Z")

</div>

@Zusch I didn’t realise that you ran it as a service. I would try to running the service as an admin user. So change it from local system to an actual user and see whether that resolves the issue. In the past this error popped up when Duplicati wasn’t started as an admin user, the process wasn’t elevated.

---

<div class="post-metadata">

### Author: ![Zusch](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/z/c77e96/32.png) [@Zusch](https://forum.duplicati.com/u/Zusch)
#### Post date: [December 3, 2017, 11:24pm UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/5 "2017-12-03T23:24:57Z")

</div>

Hi samw,  
that did not help. But I searched the net again with other search words and found out that I needed to install VS C++ redistributable 2017. I only installed the 2015 version which seems not to work.

Thanks,  
Zusch

---

<div class="post-metadata">

### Author: ![tophee](https://forum.duplicati.com/user_avatar/forum.duplicati.com/tophee/32/21_2.png) [@tophee](https://forum.duplicati.com/u/tophee)
#### Post date: [December 4, 2017, 8:54am UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/6 "2017-12-04T08:54:14Z")

</div>

Thanks for sharing the solution. If it worked for you, you can mark your own answer as the accepted solution to make it easier for others to find it.

---

<div class="post-metadata">

### Author: ![samw](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/s/9de053/32.png) [@samw](https://forum.duplicati.com/u/samw)
#### Post date: [December 4, 2017, 9:39am UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/7 "2017-12-04T09:39:56Z")

</div>

@Zusch Did the 2017 C++ redist work for you? I have mine working just fine with the 2015 release, although it does spit some errors into the event log under the “vss” entry.

---

<div class="post-metadata">

### Author: ![kees-z](https://forum.duplicati.com/user_avatar/forum.duplicati.com/kees-z/32/29_2.png) [@kees-z](https://forum.duplicati.com/u/kees-z)
#### Post date: [December 4, 2017, 1:57pm UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/8 "2017-12-04T13:57:16Z")

</div>

This is interesting. VC Redist 2015 is a [requirement](https://forum.duplicati.com/t/hyper-v-backup-on-server2016/758/2?u=kees-z) for AlphaVSS, according to @kenkendk.  
As far as I know, the opposite of your proposed solution is true: reported Duplicati problems with AlphaVSS were solved by installing the 2015 version instead of 2017.

---

<div class="post-metadata">

### Author: ![kenkendk](https://forum.duplicati.com/user_avatar/forum.duplicati.com/kenkendk/32/5305_2.png) [@kenkendk](https://forum.duplicati.com/u/kenkendk)
#### Post date: [December 10, 2017, 8:38pm UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/9 "2017-12-10T20:38:58Z")

</div>

It appears that AlphaVSS v1.4.0 requires VC Redist 2017:

> **[alphaleonis/AlphaVSS](https://github.com/alphaleonis/AlphaVSS/releases/tag/1.4.0)**
>
> AlphaVSS is a .NET class library released under the MIT license providing a managed API for the Volume Shadow Copy Service also known as VSS. - alphaleonis/AlphaVSS

I was not aware of this change, but I updated AlphaVSS to 1.4.0 back in May:

> <https://github.com/duplicati/duplicati/commit/b0be676dc4a63b387778f74aeef8c14502166330#diff-55921a8ae48b796ea7815f6cb1b6c8b1>

---

<div class="post-metadata">

### Author: ![mikaelmello](https://forum.duplicati.com/user_avatar/forum.duplicati.com/mikaelmello/32/2097_2.png) [@mikaelmello](https://forum.duplicati.com/u/mikaelmello)
#### Post date: [December 5, 2018, 6:13pm UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/10 "2018-12-05T18:13:39Z")

</div>

> [@Zusch](#):
>
> Hi samw,  
> that did not help. But I searched the net again with other search words and found out that I needed to install VS C++ redistributable 2017. I only installed the 2015 version which seems not to work.
> 
> Thanks,  
> Zusch

Just wanted to say that this helped me figure out this error a while ago. Should it be marked as the solution?

---

<div class="post-metadata">

### Author: ![kees-z](https://forum.duplicati.com/user_avatar/forum.duplicati.com/kees-z/32/29_2.png) [@kees-z](https://forum.duplicati.com/u/kees-z)
#### Post date: [December 6, 2018, 9:24am UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/11 "2018-12-06T09:24:52Z")

</div>

As it is a redistributable package, why not include it in the Duplicati packages and auto-install it if the correct version isn’t already installed?

Also, the automatic update could at least notice that the correct VS C++ version is not installed and point to the included installer, for example in the notification popup at the bottom of the Web UI.

---

<div class="post-metadata">

### Author: ![mikaelmello](https://forum.duplicati.com/user_avatar/forum.duplicati.com/mikaelmello/32/2097_2.png) [@mikaelmello](https://forum.duplicati.com/u/mikaelmello)
#### Post date: [December 6, 2018, 11:19am UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/12 "2018-12-06T11:19:08Z")

</div>

> [@kees-z](#):
>
> As it is a redistributable package, why not include it in the Duplicati packages and auto-install it if the correct version isn’t already installed?

I’d love to have that for my fork. I searched for it some time ago but couldn’t figure out how to include it along with the installer. Do you know how to do that?

---

<div class="post-metadata">

### Author: ![kees-z](https://forum.duplicati.com/user_avatar/forum.duplicati.com/kees-z/32/29_2.png) [@kees-z](https://forum.duplicati.com/u/kees-z)
#### Post date: [December 6, 2018, 11:38am UTC](https://forum.duplicati.com/t/error-failed-to-enumerate-microsoft-sql-server-databases/1604/13 "2018-12-06T11:38:28Z")

</div>

Unfortunately not. Installers of other software sometimes have a step in the installation wizard that detects and asks for installation of dependencies, something like this:

![image](https://forum.duplicati.com/uploads/default/original/2X/2/2bcae62a550b91523ad0aa9bc77dcc572f023fda.png)

Maybe this[this](https://docs.microsoft.com/en-us/previous-versions/dd293575%28v%3dvs.140%29) or [this](http://wixtoolset.org/documentation/manual/v3/howtos/redistributables_and_install_checks/install_vcredist.html) helps.
