Today you will learn how to install and configure MS SQL server in Windows 10 operating system.
- Download setup file ENU\x64\SQLEXPR_x64_ENU.exe
- Download setup file ENU\x86\SQLManagementStudio_x86_ENU.exe from here
- Download heidisql tool
Configure SQL express setup
Open the 1st download file for SQL server installation and run as administrator. Click on installation then go with New SQL server standalone installation.
To install sql server2012 follow given below three steps:
- License terms
- Product updates
- Install setup files
Here enable the check box for “I accept the license terms” and click on next.
Enable the check box for “Include SQL server product updates” to enhance the SQL server security and performance. It found 26 MB setup online which will get installed when you will click on next.
Now it will start installing SQL server setup file on your system which takes some time. As soon as setup gets installed you will get new window screen of feature selection for your SQL server.
Now select the features you want to install from the given image you can see I had enabled check box for following features.
- Database Engine service
- SQL Server Replication
- SQL Client Connective SDK
Click on next.
Specify the name and instance ID for instance of SQL server. The directory structure, registry structure, and service names all replicate the instance name and a specific instance ID. Instance ID becomes part of the installation path.
- Enter SQLExpress in the text filed for Name Instance
- Enter SQLExpress in the text filed for Instance ID
After then click on next
You can select Default Instance also if an instance of SQL Server is not installed previously. It does not need a user to give the name of the instance to create a connection.
Database Engine Configuration
Specify Database Engine authentication for its security mode
By default, sa is the administrator of MS SQL
Under the panel of authentication mode:
- Click on mixed mode which is a combination of both type authentication SQL server and Windows.
- Type your password and confirm the password for administrator account.
From the given image you can observe that selected user will be part of administrator account of SQL server who has the unrestricted access over database engine.
After then click on next and next.
Your SQL server 2012 installation completed successfully, here you can check the status for installed features.
Now open the SQL server configuration manager where you will see left and right panel.
Click on the protocol for SQLExpress in the left panel and then after select protocol name “TCP/IP” in the right panel.
Under IP Addresses specify TCP port 1433 tab, Click on Apply and Enable the TCP/IP.
Configure SQL Management Studio setup
Now open 2nd downloaded application for SQL server management setup and add a new feature in it.
No updates for SQL server 2012 click on next.
Since we have already created instance “SQLExpress” now we can add featured in SQLExpress instance of SQL server 2012.
From given below image you can observe the table for installed instance. Click on next
For installation of the instance, the feature enables the checkbox for Management tool basic as shared featured then click on next and next.
Management tool basic installation completed successfully, here you can check the status for installed features. Click on installation then go with New SQL server standalone installation.
Now login into SQL Server using admin credential and click on connect.
Once you are login into SQL server then Explore security folder and create a new login account for other users.
Enter the user name as I had given “ignite” and set a password by choosing SQL server authentication for this user.
From the given image you can observe that master is the default database.
Connect to server
Run heidisql tool to connect with MS SQL Server through Ignite user as given below:
Network type: TCP/IP
Hostname /IP: 192.168.1.104
HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases, and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers, and scheduled events.
Now click on open
Great!! We have successfully access the database system of the MSSQL server. You can modify or create a new table or new database and much more things.
Author: Sanjeet Kumar is an Information Security Analyst | Pentester | Researcher Contact Here