Installation Guide – Microsoft SQL Server The installation of Microsoft SQL Server is required. If you already have a MS SQL Server installation located on your computer or on your server, you can make the configuration in the REBEAT Digital software by clicking at the menu "Accounting -> Data base settings". Or you can download and install the MS SQL Server 2008 express edition for free from the Microsoft website. Microsoft® SQL Server® 2008 R2 Express is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for applications, and local data stores. 1.1 System requirements Supported operating systems: Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP 32-bit systems o 64-bit systems o 1.2 Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended.) 1.4 GHz or faster processor Minimum of 512 MB of RAM (2 GB or more is recommended.) 2.2 GB of available hard disk space Instructions We recommend you read the Microsoft® SQL Server® 2008 R2 Release Notes and Microsoft® SQL Server® 2008 R2 Readme before installing Microsoft® SQL Server® 2008 R2. Step 1: Download and install Microsoft .Net Framework 3.5 SP1. Step 2: Download and install Windows Installer 4.5. Step 3: Download and install Windows PowerShell 1.0. Step 4: Download SQL Server 2008 R2 Express with Management Tools by clicking the appropriate link below. Step 5: Enabling Remote SQL Express 2008 Network Connections on XP/Vista/Win7/Win8 SQLEXPRWT_X86 Executable SQLEXPRWT_X64 Executable InstallationGuide_MicrosoftSQL_Server.doc Seite 1 von 16 REBEAT Digital 1.3 Installation MS SQL Server 2008 R2 Express After successful downloading, run the setup and click the links and buttons that are highlighted red in the following screenshots. fig. 1.3.1 InstallationGuide_MicrosoftSQL_Server.doc Seite 2 von 16 REBEAT Digital fig. 1.3.2 InstallationGuide_MicrosoftSQL_Server.doc Seite 3 von 16 REBEAT Digital fig. 1.3.3 InstallationGuide_MicrosoftSQL_Server.doc Seite 4 von 16 REBEAT Digital fig. 1.3.4 InstallationGuide_MicrosoftSQL_Server.doc Seite 5 von 16 REBEAT Digital fig. 1.3.5 InstallationGuide_MicrosoftSQL_Server.doc Seite 6 von 16 REBEAT Digital fig. 1.3.6 InstallationGuide_MicrosoftSQL_Server.doc Seite 7 von 16 REBEAT Digital fig. 1.3.7 fig. 1.3.8 InstallationGuide_MicrosoftSQL_Server.doc Seite 8 von 16 REBEAT Digital fig. 1.3.9 InstallationGuide_MicrosoftSQL_Server.doc Seite 9 von 16 REBEAT Digital 1.4 Database settings Change database settings in the REBEAT Digital Software by clicking on „Menu -> Accounting -> Database settings…“ and follow the steps as the images show below. fig. 1.4.1 InstallationGuide_MicrosoftSQL_Server.doc Seite 10 von 16 REBEAT Digital fig. 1.4.2 InstallationGuide_MicrosoftSQL_Server.doc Seite 11 von 16 REBEAT Digital fig. 1.4.3 InstallationGuide_MicrosoftSQL_Server.doc Seite 12 von 16 REBEAT Digital Server installation: Enter the name of the server where the MS SQL Server Instance is installed, like {server name}\{instance name} or without instance name then type only {server name} For local installation: Enter „localhost\sqlexpress“ like the image shows below fig. 1.4.4 InstallationGuide_MicrosoftSQL_Server.doc Seite 13 von 16 REBEAT Digital fig. 1.4.5 InstallationGuide_MicrosoftSQL_Server.doc Seite 14 von 16 REBEAT Digital fig. 1.4.6 InstallationGuide_MicrosoftSQL_Server.doc Seite 15 von 16 REBEAT Digital fig. 1.4.7 The REBEAT Digital software will be restarted. Finish. InstallationGuide_MicrosoftSQL_Server.doc Seite 16 von 16 REBEAT Digital