SQL Server is essential for the operationalization of PIS. It is essential that we have access to a server and a database in this environment to create and store metadata data. If the customer already has a corporate SQL Server, we can use this existing server.


In scenarios where the PIS server is hosted in the cloud, the SQL Server license is the responsibility of the provider. There is likely to be an additional cost when subscribing to this service. In the absence of a SQL Server, you can choose to install SQL Server Express, which is free and meets the size requirements for metadata databases.


The Developer version, on the other hand, is recommended for educational or training purposes only and is not suitable for commercial use. For teaching purposes, we will use the Developer version:


  • In the browser, search for Microsoft SQL Server Downloads.


  • Select the link indicated for SQL Server Downloads. Below, choose the Developer version and click Download Now. If you prefer, the Express version is also available.


  • Proceed by opening the downloaded file and selecting the Custom option. Click Install.


  • In the SQL Server installation interface, select Installation and choose New SQL Server Standalone Installation. Continue with the Developer version and move forward.


  • Accept the licensing terms and proceed.


  • Always choose the most up-to-date SQL Server settings and proceed through the following steps.


  • Uncheck "Azure Extension for SQL Server" and proceed. In the subsequent step.


  • Select Database Engine Services as an option. Proceed with the installation.


  • Keep the default name for the server instance and continue.


  • Do not change the names of the suggested services, proceeding to the next step.


  • At this point, select the Mixed Mode option and define a password for the sa user, who will be the SQL Server administrator. Remember to keep this password.


  • Add the current Windows user as the SQL Server user and proceed.


  • Review all installation settings and begin the installation.


  • Upon completion, SQL Server will be properly installed on your device.