Update from older SQL Server versions

If your installation is based on a no longer supported version of Microsoft SQL Server, the VTS installer will display a corresponding message. In this case, installation is not possible without certain manual adaptations before running the VTS setup. Which version of Microsoft SQL Server is supported is stated on the page: System requirements.

Installation with a user-defined database

If you have installed your VTS server using scripts (see Manual installation of the VTS SQL database ), you must first update your SQL server before updating the VTS database to the latest version. Follow the instructions here Manual update of the VTS SQL database.

Standard installation

For a standard installation, please perform the following steps before starting the setup:

1. Open the VTS administration software.

2. Use the Set backup path button to specify a storage location for the database backup.

3. Go to Settings → General settings → Database → Start backup and start the database backup.

   1. The database backup may take some time. Depending on the size of your database and your hardware, the process may take several minutes or hours.

   2. When the backup is complete, the following dialog box appears:

      

4. Close the VTS administration software.

5. Right-click on the taskbar and select Task Manager from the context menu.

6. When the Task Manager appears, go to Services → WTS Service.

   1. Right-click on WTS Service and select Stop from the context menu.

   2. Wait until the service has stopped.

7. Right-click on the Start button in Windows OS. A pop-up window will appear.

8. Click on Installed Apps in the context menu.

9. A Windows dialog box will appear showing all your installed apps.

10. Scroll to Microsoft SQL Server. There may be several apps installed that start with this name. Here is an example:

    

11. Uninstall the version that does not contain any words after the year, version, and description of whether it is a 32-bit or 64-bit version. (The version selected on the screen may differ depending on the version of SQL Server you are using.)

    1. Click the Uninstall button to uninstall SQL Server.

    2. The following (or a very similar) dialog will appear:

       

    3. Click the Remove link. Windows OS may prompt you to install additional features, such as .NET Framework 3.5. If this happens, simply click Download and install this feature.

    4. Depending on your SQL Server version, the SQL Server uninstall program will display the following (or a very similar) dialog:

       

    5. Click Next.

       

    6. Select all check boxes and click Next.

       

    7. Click Next.

       

    8. Click Remove and wait for the deinstallation to complete.

       

    9. Click Close.

12. Restart your computer.

13. Open File Explorer and navigate to the C: drive and then to the path C:\Program Files\Microsoft SQL Server.

14. The name of one of the subfolders ends with WTSNXEXPRESS, e.g.:

    

    1. Go to this folder and then to the path of the subfolder MSSQL\Data.

    2. Windows will ask for administrator rights.

       

    3. Grant administrator rights by clicking on the Continue button.

    4. You should now see two files named dtc.mdf and dtc_log.LDF:

       

    5. Open another File Explorer window and enter the following path in the address bar: %PROGRAMDATA%\schuhfried\sqldatabase. Confirm with the Enter key.

    6. Cut the files dtc.mdf and dtc_log.LDF from the MSSQL\Data folder and paste them into the folder %PROGRAMDATA%\schuhfried\sqldatabase.

15. Go to the folder containing the latest version of the VTS installer and start it again. It should install the newer version of Microsoft SQL Server while preserving your database files. If the installer does not run properly, please contact support.