If you are using SQL Express Edition, please download the SQL Server Management Studio from the link below...
Please download the file 'MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe' (For a 64 bit version of Windows)
1. Attaching MDF and LDF files to SQL Server....
Each SOHODOX DB will have 4 files. Lets assume you want to attach the MainDB_sdx. You should have the following files...
- MainDB_sdx.mdf
- MainDB_sdx_log.ldf
- MainDB_sdx_cache.mdf
- MainDB_sdx_cache_log.ldf
These files are usually located and need to be placed in the 'C:\Program Files\Microsoft SQL Server\MSSQL12.(Your Instance Name)\MSSQL\DATA' folder.
To attach the MDF and LDF File...
- Open
SQL Server Management Studio. Connect to the server using the SQL
credentials. (Make sure you login with SQL Server Authentication)
- Go to object explorer of the database engine instance. Right click on the Databases node and select Attach option.
- The Attach databases dialog will appear.
- Click on Add button.
- Select the .mdf file and click on OK Button. The below section will show the related mdf and ldf file details.
- Click the OK button.
Once done, you will need to point SOHODOX to the SQL DB...
Please open the command prompt and run the command below...
"C:\Program Files (x86)\Sohodox Desktop\Sohodox.exe" /reconfiguremssqlmaindb /dbname=MainDB_sdx
In the dialog which pops up, specify the SQL Server location and login credentials for the new installation.
Now open Sohodox again.
The DB will open.
That's it!