SQL Server 2012 installation configuration (Part3)

SQL Server 2012 installation configuration (Part1)

SQL Server 2012 installation configuration (Part2)

3 client installation

3.1 install the client

The operation before the feature selection is the same as the SQL Server installation method. I will not repeat it here, but I will start directly from the feature selection.

Figure 3-1 function selection

Select the features shown above (Administrative tools-basic and SQL client connection SDK) and click the button to enter the installation rules dialog box.

Figure 3-2 installation rules

After passing the check, click the button to enter the disk space requirements dialog box.

Figure 3-3 disk space requirements

Click the button to enter the error reporting dialog box.

Figure 3-4 error report

Without any configuration, click the button to enter the installation configuration rules dialog box.

Figure 3-5 installation configuration rules

Click the button to enter the prepare installation dialog box.

Figure 3-6 preparing for installation

Click the button to enter the installation progress dialog box.

Figure 3-7 installation progress

After the installation is complete, pop up the "need to restart the computer" dialog box, click the button to enter the completion dialog box.

Figure 3-8 complete

Click the button to close the dialog box. Restart the computer and the client installation is complete.

3.2 Test the connection to the database server

After the client is installed, please follow the steps below to test the connection with the SQL Server server to make sure that the client and server can connect normally.

Select the system [start / run] menu item, enter cmd in the run window to enter command line mode, or use PowerShell.

Enter the following command:

Where 192.168.20.110 is the SQL Server server IP address, sa is the default superuser, and 123456 is the password of the sa user. Osql-S 192.168.20.110-U sa-P 123456

If SQL Server does not use the default instance name, you also need to specify the instance name in the command, which is:

Osql-S 192.168.20.110\ instancename-U sa-P iMC123456 instancename is the instance name.

If you can enter SQL command mode, you can connect to the server normally, as shown in the following figure.

Figure 5-9 testing the connection to the database server

SQL Server 2012 installation configuration (Part4)