SQL Server 2017 Step by Step Installation -2

Mehmet Salih Deveci April 4, 2019 3 Comments

Hi,

I will continue to tell you step by step Microsoft SQL Server 2017 installation on Windows Server 2016 in this post.

 

Read first article before this post with following link.

SQL Server 2017 Step by Step Installation -1

 

You should name SQL Server instance in this step. If you don’t name it, you can choose default Instance.

 

 

You should type account informations of SQL Server services and  decide which account will run these services.

 

 

Define Collation ( Character set ) of SQL Server instance according to your application, software. This property cannot be changed after installation. So define it correctly.

 

You should specify Authentication mode of SQL Server in this step. I recommend choosing Mixed mode ( windows authentication and SQL Server authentication )

If you choose mixed mode, you should type sa account password.

You should add current user to the SQL Server administrators.

 

 

 

Specify data directories of SQL Server ( Data, log and backup directory ) like following.

 

 

Specify TempDB settings like following.

 

You can see summary of SQL Server 2017 installation in this step before installation start.

 

 

Click Install button to start installation.

Installation is completed thus, you can connect sql server 2017 by using SQL Server management studio.

 

 

 

Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.

https://ittutorial.org/sql-server-tutorials-microsoft-database-for-beginners/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

3 comments

  1. Ramreddy
    June 28, 2019 at 3:49 pm

    Hello Sir,

    I am planning to learn Azure sql Dba. Is it
    Possible to you teach.

    Thanks,
    Ramreddy

    Reply
  2. Ritika
    August 31, 2019 at 2:35 am

    I often read your article and they are quite informative and descriptive. But for this one I see the tempdb best practices were not mentioned while installation which play an important role later as well! May be you can have those kind of important details in your upcoming article!!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Powered by IT Tutorial | Designed by SysDBASoft IT
IT Tutorial © Copyright 2024, All Rights Reserved