INSTALLATION OF SERVICES ON WINDOW SERVER 2016 IN DATABASE ZONE (SQL SERVER 2017)

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.

0 views

Our Office :

OSI TECHNOLOGY SDN BHD

16-1 Jalan Opera D U2/D,

Taman TTDI Jaya,

40150 Shah Alam,

Selangor Darul Ehsan

Tel : 603 7846 3080

Fax : 603 7848 3180

Email : info_osi@osi.com.my

Training Centre & Exam Centre : 

OSI TECHNOLOGY SDN BHD

20-1 Jalan Opera G U2/G,

Taman TTDI Jaya,

40150 Shah Alam,

Selangor Darul Ehsan