]> 2026-04-28T00:35:47+02:00 StuertzCloud - Creating Local SQL Database 0 en Draft How to create a SQL Database instance on the local network to enable factory machines to communicate with StuertzCloud Hard 30 minute(s) See [[StuertzCloud - Setup Overview]] for an overview of the setup. This tutorial covers the setup of the Local SQL Express database instance and creating a "ProOpt" database structure on it. <br/> *This database installed on the 'Location' local network. *The 'Machines' write their production data to it *The 'Gateway' software uploads this data to the StuertzCloud server See Also [https://stuga.dokit.app/wiki/StuertzCloud_-_Installing_Gateway StuertzCloud - Installing Gateway] [https://stuga.dokit.app/wiki/StuertzCloud_-_Setting_up_Stuga_Machine_to_Write_Production_Data StuertzCloud - Setting up Stuga Machine to Write Production Data] [https://stuga.dokit.app/wiki/StuertzCloud_-_Creating_a_Customer_Location StuertzCloud - Creating a Customer Location] <br/><div class="icon-instructions info-icon"> <div class="icon-instructions-icon"><i class="fa fa-info-circle"></i></div> <div class="icon-instructions-text">...You must have SQL Server Management Studio (SSMS) installed to manage the databases</div> </div> <br/> false en none This is stored on the [https://stugaltd.monday.com/boards/4881973586 Software versions] Monday Board 👉 [https://www.microsoft.com/en-us/download/details.aspx?id=104781 Download SQL Server Express 2022] *'''Run the Installer''': Locate the downloaded file named <code data-start="33" data-end="56">SQL2022-SSEI-Expr.exe</code> *and double-click it to launch the installer. *'''Choose Installation Type''': In the installer window, select the '''Basic''' installation option. This will install SQL Server Express with default settings. *'''Accept License Terms''': Read and accept the license terms to proceed with the installation. *'''Installation Progress''': The installer will download and install the necessary components. This process may take several minutes. *'''Installation Complete''': Once the installation is complete, you'll see a confirmation screen. You can note the instance name (usually <code data-start="109" data-end="121">SQLEXPRESS</code>) for future reference. *SA password <br/> After installation, you can verify that SQL Server Express is running by: *Opening '''SQL Server Management Studio (SSMS)'''. *Connecting to the server using the instance name (e.g., <code data-start="56" data-end="70">.\SQLEXPRESS</code>) <br/> *Ensuring that the connection is successful and that you can see the server objects. <nowiki>Launch SSMS and connect to your local server. If you used default settings, the server name will be:<br /><br/><div class="mw-highlight mw-content-ltr" dir="ltr"><pre>.\SQLEXPRESS</pre></div><br /><br /><br />Use “Windows Authentication”<br /><br />Tick trust Server certificate<br/><div class="icon-instructions info-icon"><br /><div class="icon-instructions-icon"><i class="fa fa-info-circle"></i></div><br /><div class="icon-instructions-text">...We will set up SQL Authentication later</div><br /></div><br /><br /><br /><br/></nowiki> * In '''Object Explorer''', right-click your server and select '''Properties'''. * Go to the '''Security''' page. * Under ''Server authentication'', select: '''SQL Server and Windows Authentication mode''' * Click '''OK'''. # In SSMS, open '''Object Explorer'''. # Right-click the server name at the top # Click '''Restart''' and confirm. Alternatively, you can use '''SQL Server Configuration Manager''' if SSMS doesn’t show the restart option: * Open <code data-start="340" data-end="374">SQL Server Configuration Manager</code> <br/> * Expand '''SQL Server Services''' * Right-click '''SQL Server (SQLEXPRESS)''' and choose '''Restart''' * In SSMS, expand: <code data-start="592" data-end="611">Security > Logins</code> * Right-click on sa and choose '''Properties''' * In the '''General''' page: ** Set a strong password (and confirm it) * Switch to the '''Status''' page: ** Set '''Login''' to: '''Enabled''' * Click '''OK''' to save changes confirm that SQL Authentication works: # Disconnect your current session in SSMS. # Click '''Connect''' again. # Set: #* '''Server name''': <code data-start="234" data-end="248">.\SQLEXPRESS</code> #* '''Authentication''': '''SQL Server Authentication''' #* '''Login''': <code data-start="320" data-end="324">sa</code> #* '''Password''': (use the one you just set) # Right click on Databases->New Database # Call it ProOpt *Go to '''File > Open > File…''' *Browse to and open the script file: <code data-start="533" data-end="590">ProOpt-StuertzCloud-Reference-Database-20240131 (4).sql</code> # Select the ProOpt database in the drop down query menu # Execute the script # Check the proOpt tables have been created Uncheck Enforce Password Policy Password in text file Set permissions all bar denydatareader and denydatawriter User Mapping->Map to ProOpt should then appear in ProOpt->Security->Users folder <br/> * Use an online GUID generator https://guidgenerator.com/ * Copy the GUID * Right click -> Edit top200 rows * Paste GUID in ID field Download and Install SQL Server Express 2022 Verify Installation Download the ProOpt sql schema Open SQL Server Management Studio (SSMS) Open the SQL Script Enable SQL Server Authentication Mode Restart SQL Service Enable the "sa" Login and Set a Password Test the sa Login Create a ProOpt Database Run the script in the ProOpt database Create a SQL Server login for StuertzCloud Set configuration compatibility with StuertzCloud gateway Get a new GUID Add GUID to StuertzCloud_Metadata 2025-04-24T16:01:43Z 2460790.1678588 StuertzCloud - Creating Local SQL Database 0 false false 0 0 0 1 plainlist 3 [[:Dokit:DocOptions]] [[DokitEPIEnable::yes]] StuertzCloud - Creating Local SQL Database# QUERYee7a61aae48f1c3f91d8e4d7736360be