{"id":2287,"date":"2021-10-21T15:37:32","date_gmt":"2021-10-21T15:37:32","guid":{"rendered":"https:\/\/www.solidxperts.com\/?post_type=techtips&p=2287"},"modified":"2024-12-03T16:52:36","modified_gmt":"2024-12-03T21:52:36","slug":"sql-express-installation-and-configuration-guide","status":"publish","type":"techtips","link":"https:\/\/www.solidxperts.com\/en\/blog\/sql-express-installation-and-configuration-guide\/","title":{"rendered":"SQL Express Installation and Configuration Guide"},"content":{"rendered":"

[vc_row full_width=”stretch_row_content” css=”.vc_custom_1634769939600{background-color: #0d1327 !important;}” el_class=”post-header”][vc_column][vc_row_inner el_class=”container”][vc_column_inner][vc_column_text el_class=”hideme subtitle”]BLOG[\/vc_column_text][vc_column_text el_class=”hideme title”]<\/p>\n

SQL Express Installation and Configuration Guide<\/h1>\n

[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row][vc_row el_class=”container post-featured”][vc_column][vc_column_text el_class=”return-link”]Return<\/a>[\/vc_column_text][vc_column_text el_class=”hideme”]

\"SQL<\/div>[\/vc_column_text][\/vc_column][\/vc_row][vc_row el_class=”sass_social_container”][vc_column][vc_column_text]
<\/path><\/svg><\/span><\/a><\/path><\/svg><\/span><\/a><\/path><\/svg><\/span><\/a><\/path><\/svg><\/span><\/a><\/div>
<\/div><\/div>[\/vc_column_text][\/vc_column][\/vc_row][vc_row el_class=”container post-content”][vc_column][vc_column_text]<\/p>\n

By Elene Teolis \u2013 PDM Application Specialist at SolidXperts<\/a><\/p>\n

How to Install SQL Express<\/strong> in Preparation for Installing SOLIDWORKS PDM Standard<\/strong><\/a>
\n*Your windows and menus may vary slightly depending on the server operating system.<\/p>\n

1. Server Preparation<\/strong>
\n1.1.<\/strong> Make sure the server meets the technical requirements:\u00a0View SOLIDWORKS and SW PDM System Requirements<\/a>
\nMake sure that .NET Framework 3.5 and 4.0 are installed, if necessary, configure the “Application Server” role on the server:
\n\"\"
\n1.2.<\/strong> Prepare file structure
\n– If possible, create 2 partitions. Reserve the C: drive for applications and another for the data.
\n– Create a folder structure in the disk to receive the data as specified below:<\/p>\n

\"\"
\nSuggested file structure<\/p>\n

*SQL cannot save its data to an external disk or hard disk storage (NAS or SAN).<\/p>\n

2. SQL Server Express Installation<\/strong>
\nThe installation of SQL Server Express is done by following the instructions in the PDM installation guide. Here are the steps followed for a typical SolidXperts installation.
\n– SQL Express can be found on the DVD or in SOLIDWORKS downloaded files.<\/p>\n

2.1.<\/strong> Start the installation as an administrator.<\/p>\n

\\SOLIDWORKS 2019 SP0\\PreReqs\\SQLServer\\sqlexpr_x64_enu.exe<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

2.2.\u00a0<\/strong>Choose a new installation.<\/p>\n

\"\"\"\"
\n2.3.\u00a0<\/strong>Accept the license terms.<\/p>\n

\"\"
\n3. Option Selection: Choose Database Engine Services.<\/strong><\/p>\n

\"\"
\n4. Instance Configuration<\/strong>
\n– If it is a new installation, choose Default instance.
\n– If SQL is already installed, choose Named Instance and enter a name.<\/p>\n

\"\"
\n4.1.<\/strong> Server Configuration: Leave default values for service account names.<\/p>\n

\"\"
\n4.2.<\/strong> Database Engine Configuration
\n– Select Mixed Mode.
\n– Create a password for the SQL System Administrator.
\n– Specify the SQL Administrator \u00e0 Click Add Current User and add the Domain Administrators group (domain admin) and\/or the local Administrators group.<\/p>\n

\"\"
\n– Change the following directories to conform to the file structure created in the server preparation step.<\/p>\n

\"\"
\n– Start the installation by clicking on Next.<\/p>\n

\"\"<\/p>\n

Installation complete<\/strong><\/p>\n

 <\/p>\n

5. SQL Express Configuration<\/strong>
\n5.1.<\/strong> Launch \u2018SQL Express Configuration Manager\u2019<\/p>\n

\"\"\"\"<\/p>\n

– In IPAll, clear<\/u> the value in Dynamic TCP Ports.
\n– Set the TCP Port to the static port number that you want the SQL Server Express instance to follow:<\/p>\n