FuseCP / SolidCP

Multi Server Control Panel for Windows based on C#
https://solidcp.com
Other
85 stars 76 forks source link

1.4.9 Installer Standalone Server - Unable to create Database #166

Closed Sharky521 closed 8 months ago

Sharky521 commented 10 months ago

Describe the bug No matter what Windows Server OS or SQL Express version, the same error can be encountered. The Database is unable to be created via the Installer. I've tried Windows OS versions 2016, 2019, and 2022 as well as SQL Express 2012, 2014, 2016, 2019, and 2022. All have given the same issue.

To Reproduce Steps to reproduce the behavior:

  1. Go to 1.4.9 installer
  2. Click on Standalone Server
  3. Proceed through install and wait.
  4. See error

Expected behavior It's expected to complete the installation accordingly.

Screenshots If applicable, add screenshots to help explain your problem.

SolidCP Info

Desktop (please complete the following information):

Additional context [12/17/2023 10:36:57 PM] ERROR: Create database error System.Data.SqlClient.SqlException (0x80131904): Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\SolidCP.mdf' because it already exists. Change the file path or the file name, and retry the operation.

FuseCP-TRobinson commented 8 months ago

Hello,

The installer for 1.4.9 does work with SQL 2019. Following your error it looks like an SolidCP database already exists on the server.

If there is no database on the server please make sure to remove the .mdf and .log files from the MSSQL Data path.

Regards,

Trevor