This article describes how to install Microsoft SQL Server manually for visitor id. Please follow these instructions if Microsoft SQL Server fails to install correctly during the visitor id installation, or if you chose to skip installing Microsoft SQL Server during the visitor id installation to install Microsoft SQL Server manually.
Step 1: Downloading Microsoft SQL Server 2017 Express
Microsoft SQL Server 2017 Express can be downloaded from the following link: https://www.microsoft.com/en-us/download/details.aspx?id=55994
Click the ‘Download’ button and save the file to the master visitor id PC.
Step 2: Installing Microsoft SQL Server 2017 Express
Run the downloaded installer and accept any UAC prompts.
Choose the ‘Custom’ installation type:
Press the ‘Install’ button:
Wait for the process to finish and the ‘SQL Server Installation Center’ window will appear.
Press the ‘New SQL Server stand-alone installation or add features to an existing installation’ option:
Wait for the ‘SQL Server 2017 Setup’ window to appear, then press tick the ‘I accept the license terms.’ checkbox and press the ‘Next >’ button:
The installation will now check for product updates and install the setup files. If the ‘Install Rules’ window appears and shows a warning for the ‘Windows Firewall’ just click the ‘Next >’ button. Instructions for updating the Windows Firewall for Microsoft SQL Server can be found in this article here:
In the ‘Feature Selection’ window, choose the following items as per the below image, then press the ‘Next >’ button:
Instance Features > Database Engine Services
Instance Features > SQL Server Replication
Shared Features > Client Tools Connectivity
Shared Features > Client Tools Backwards Compatibility
Shared Features > Client Tools SDK
Shared Features > SQL Client Connectivity SDK
In the ‘Instance Configuration’ window, make sure ‘Named instance’ is chosen and change the name to ‘VISITORID’, then press the ‘Next >’ button:
In the ‘Server Configuration’ window, change the ‘SQL Server Browser > Startup Type’ to ‘Automatic’, then press the ‘Next >’ button:
In the ‘Database Engine Configuration’ window:
Change the ‘Authentication Mode’ to ‘Mixed Mode’.
Type in a strong password into the ‘Enter password’ and ‘Confirm password’ text boxes. Keep a copy of this password in a password manager application for future use.
Press the ‘Next >’ button.
Microsoft SQL Server 2017 Express will now start installing. If there are any errors during this process they will be displayed on screen to troubleshoot. If you do receive errors during the installation, please take a screenshot of the errors and send an email to email@example.com .
If the installation was successful the ‘Complete’ window will be displayed. Press the ‘Close’ button to finish the installation:
Step 3: Downloading Microsoft SQL Server Management Tools
While the ‘SQL Server Installation Center’ window is still open, press the ‘Install SQL Server Management Tools’ item:
In the browser window that opens up, press the ‘Download SQL Server Management Studio (SSMS)’ link to start the download:
Step 4: Install Microsoft SQL Server Management Studio
Once the download has completed, run the installer and accept any UAC prompts.
In the ‘Welcome’ window, press the ‘Install’ button:
Microsoft SQL Server Management Studio will now start installing. If there are any errors during this process they will be displayed on screen to troubleshoot. If you do receive errors during the installation, please take a screenshot of the errors and send an email to firstname.lastname@example.org .
A restart of the PC may be required to complete the installation. Press the ‘Restart’ button:
Congratulations, you have now installed Microsoft SQL Server 2017 Express and Microsoft SQL Server Management Studio.
Was this post helpful?
Let us know if you liked the post. That’s the only way we can improve.
Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.
Essential Website Cookies
These cookies are strictly necessary to provide you with services available through our website and to use some of its features.
We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.
Other external services
We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.
Google Webfont Settings:
Google Map Settings:
Google reCaptcha Settings:
Vimeo and Youtube video embeds: