As WipeDrive, Detalys and Hardware Inventory can save the information and result of their operation directly to a SQL database, we decided to provide a basic manual with instructions on how to set up a Microsoft SQL Server Express in your Windows machine.
These instructions will apply for Windows 10 Pro, Windows Server 2019 and 2016, but might not be limited to those versions.
Your SQL server must be accessible from any machine from you want to save the log. In this manual, we will not mention any IP settings because that will depend on your environment and network layout.
1.- You will need to download SQL Express; you can find it going to google.com and searching for it.
2.- Ones you downloaded the installer it will display a window like below and let you select which option you want to run, in our case we select "Custom", then it will ask where to download the SQL Server Installation Center.
3.- When the Installation Center is download it will open and you need to select the first option "New SQL Server Stand-alone installation..."
4.- It will require you to accept the terms. There is no need to choose the Microsoft Update unless you want to. Then it should install the setup files.
After the setup files are installed, click next. Don't add any instance features, just click next.
Then it will request to name the instance, you can use the default name (SQLEXPRESS) or specify one for your instance. In our case we are going to use the default one.
5.- For following windows select next until appear database Engine Configuration, here you need to click in "Mixed Mode" this will allow you to connect to the database using your windows account or user and password from the SQL server. It will require to enter a password.
6.- To manage the database, you will need to install SQL Server Management Tools, this tool will connect to the database with a user and password (step 5) and allow you to manage it. To proceed with the installation, you need to open the SQL Service Installation Center and click in "Install SQL Server Management Tools"
7.- It will take you to a new website where you will need to scroll down and click on Download SQL Server Management Studio (SSMS).
8.- As soon it finishes the download process of the SSMS, you will need to run the installer, it shouldn't take longer and will be required to restart the machine when the installation was completed. After that you will see in the start menu "SQL Server Configuration" and "Microsoft SQL Server Management".
Creating a new SQL Database.
A) From the start menu, click in SQL Server Management and stablish connection using the user and password or with a local user added during the installation process.
B) In the explorer you need to look for the Database folder and right click on it, from the new menu you need to select new database.
C) It will open a new window and request to enter the Database name and click “ok”.
Creating a User in Microsoft SQL Server Management Studio
1) If you prefer to create a new user to your new database, you need to expand folder, then right click in Login, and select New Login.
2) It will open a new window where you will need to enter the Loge name, Password and Confirm it.
3) Finally you need to go into the “User mapping” options and select the database you want this user to connect with. Make sure is marked the publish and owner role for your database
SQL Server Configuration Manager
A) To stablish connection with the SQL database you will need to go into the SQL Server Configuration Manager, which will be in the start menu, click on it and it will open a window.
B) Click on Protocols for SQLEXPRESS Then double click on TCP/IP and a new Window will pop up, where under General you need to enable it.
C) Then go to the IP address tab and add the port 1433 to every TCP port option for each IP, click apply and restart the SQL server.
Change your firewall settings
Finally, but not less important is to make sure the Firewall will allow the inbound traffic to our SQL server using the port mentioned previously. For this we will need to add a rule in the firewall, for that:
1) Open Windows Defender Firewall with Advanced Security on Local Computer.
2) Once that is open you will need to create a new inbound rule. That allows the TCP port for 1433 or whatever you have chosen.
3) You will need to select the Protocol and the Port, in our case TCP/1433.
4) For actions leave it on the allow the connection. For Profile click on all boxes then name the new rule, this can change depending on your network setup.
5 )To finish the rule, you will need to name it and click on finish to be created.
WipeDrive Database Initializer
After the database is created and the new rule is created in the Firewall, you need to prepare the database with all the schema for WipeDrive, in order to do that, we provide a tool who will create all the tables automatically, you will need to go to https://support.whitecanyon.com/kb/article/212-how-to-update-the-wipedrive-schema-version/ and download WhiteCanyon SQL Database Initializer.
You can install this tool in the same machine or in any computer with connection to the machine with the SQL database. After downloading and installing the SQL initializer, go to the start menu, look for the WipeDrive Database Initializer and run it.
You will see a window like below, where you need to:
- Select the database (MSSQL, MySQL, Postgre SQL),
- Enter the Database name
- Enter the Host (IP or host name)
Once that is filled out click populate Database.
After that is finished your new SQL database should be ready for saving your wiping reports.
Note: We don't necessarily suggest using the same options we are using on this guide, you will need to select the options that are appropriate for your environment and network.