Before we start installing SQL server 2017 on this virtual machines. Let us start by some basic configuration on network and rename this server.
On search menu, type this PC, right click and click properties
Click change settings
Click change
Rename computer name as above and click ok
Click ok
Click restart now
How to set static IP address:
Right click on the ethernet icon located on taskbar, click open network and sharing center
Click change adapter settings
Right click on the network adapter and click properties
Double click on Internet protocol version 4(TCP/IPv4)
Configure as above and click ok
HOW TO INSTALL SQL SERVER 2017 ON WINDOW SERVER 2016 IN DATABASE ZONE:
Open chrome browser and search for SQL server 2017, click download now for developer
Open then installer after download is complete, click run
Click basic
Click accept
Click install
Click install SSMS
It will bring you to a web page to download SSMS
Scroll down until you find the download link stated download SQL server management studio and click on it
Click run
Click install
Click close
Open Microsoft SQL server management studio 2017
Click browse for more in the server name section
Select current computer name and click ok
Click connect
Setup is complete.
Comments