Unable to create database - SQL Server

Unable to create database - SQL Server

avatar

Trying to create a new Data Source using Microsoft SQL Server. I have tried SQL Server 2012 and 2019 with the same results:

Unable to create database!
Could not load file or assembly 'System.Data.SqlClient, Version=4.6.1.0, Culture=Neutral, PublicKeyToken=b03f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

I have a successful 'Test Host' and able to view all databases.

I have tested with:

  • 'Create Database'
  • creating a database manually and trying to 'Update Database'


They all fail with the same response, listed above.

All Comments (3)

avatar

Hello,

This error occurs because the file System.Data.SqlClient.dll is missing from the installation folder of RDM.

If RDM 2020.2.19.0 is not installed on your computer, just installing it should resolve the issue.
If it's already installed, download the .zip file of RDM and extract only the System.Data.SqlClient.dll file inside the installation folder of RDM.

You can download RDM here
https://remotedesktopmanager.com/home/download

Best regards,

Jeff Dagenais

avatar

That solved the issue.

Weird, I installed the new installation from the exe and it was missing the file. I downloaded the zip and manually included the dll.

Thanks!

avatar

Hello,

Thank you for your feedback! We are glad to see that it is now working.

Best regards,

James Lafleur