In this post, we will try to show step by step Microsoft SQL Server 2016 installation on Windows Server 2012R2. Microsoft SQL Server 2017 is the latest stable version of SQL Server now. Latest Cumulative Update Package 9 for SQL Server 2016 SP2 – KB4515435. For demonstration purposes only I am installing SQL Server in my personal laptop on the mentioned OS.
Mount SQL Server 2016 installation iso file and start the installation by clicking setup.exe.
In the planning section click ‘System Configuration Checker‘, it will check all prerequisite and properties for the SQL Server installation environment.
It will show all prerequisite & properties for the SQL Server installation environment. Make sure that no ‘Failed’ should be on the list.
Firstly select New SQL Server Stand-alone installation choice like the following.
Enter Product key of SQL Server or select ‘Evalution‘
Accept the license terms.
Click the Next button to continue.
This step is very important, we need to choose the right features that we will use in the database. Here in the installation, I am excluding R-Services, PolyBase, Analysis Services, Reporting Services & Integration Services. By default Instance, the root directory will be in C drive.
Here we should name SQL Server instance in this step. If you don’t name it, you can choose the default Instance.
We should type service account information to run SQL Server services. Click on ‘Account Name’ drop down box and select browse.
Type account name and then check. Here ‘sanjay’ is a login in ‘beta.local’ domain.
Here email@example.com is my service account. Click OK
Use the same account for all or use different service accounts as per requirement. Put passwords respectively, check the tick in ‘Grant Perform….’
Define Collation ( Character set ) of SQL Server instance according to your application, software. This property cannot be changed after installation. So define it correctly.
We should specify the Authentication mode of SQL Server in this step. I recommend choosing Mixed mode ( Windows authentication and SQL Server authentication ). If you choose the mixed mode, you should type sa account password. We should add the current user to the SQL Server administrators.
Specify data directories of SQL Server ( Data, log and backup directory ) like the following.
Specify TempDB settings like the following.
Enable FILESTREM as per your requirement.
Select current user
No need to change, keep default
You can see the summary of the SQL Server 2016 installation in this step before installation start.
Click the Install button to start the installation.
Installation is completed
Open configuration manager and check the SQL Server status.
Now we can connect SQL server 2016 by using SQL Server management studio.
DMV ‘sys.dm_exec_requests’ provides details on all of the processes running in SQL Server.
Wait_Type, Wait_Time, Wait_Resource, SUBSTRING(st.text, (qs.statement_start_offset/2)+1,
WHEN -1 THEN DATALENGTH(st.text)
END - qs.statement_start_offset)/2) + 1) AS statement_text, GetDate() SnapshotDateTime,
ss.PROGRAM_NAME, ss.HOST_NAME, ss.Login_Name
FROM sys.dm_exec_requests AS qs INNER JOIN sys.dm_exec_sessions ss
ON qs.session_id = ss.session_id
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
WHERE Wait_Time > 0
ORDER BY Wait_Time DESC
“Please let us know if there…
Please help !!!