SQL Server 2012 Installation configuration (PART3)

SQL Server 2012 Installation configuration (PART1)

SQL Server 2012 Installation configuration (PART2)

?

3 Client Installation

3.1 Installing the Client

function selection before the same operation as the SQL Server installation method, no longer mentioned here, the following will be directly from the feature selection start.

Figure 3-1 Feature Selection

Select the features shown (Administrative Tools-Basic and SQL Client connection SDK), click < Next > button to enter the Installation Rules dialog box.

Figure 3-2 Installation Rules

After checking, click < Next > button to enter the disk Space Requirements dialog box.

Figure 3-3 Disk Space requirements

Click < Next > button to enter the Error Reporting dialog box.

Figure 3-4 Error Reporting

Without any configuration, click < Next > button to enter the Install Configuration Rules dialog box.

Figure 3-5 Installation Configuration rules

Click < Next > button to enter the ready to Install dialog box.

Figure 3-6 Preparing the installation

Click the < install > button to enter the installation Progress dialog box.

Figure 3-7 Installation Progress

After the installation is complete, the "need to restart the Computer" dialog box pops up, click the < OK > button to enter the Completion dialog box.

Figure 3-8 Complete

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

3.2 Testing the connection to the database server

After the client installation is complete, follow the steps below to test the connection to the SQL Server server, confirming that the client and server are connected properly.

1. Select the system [Start/Run] menu item, enter CMD in the Run window, enter command line mode, or use PowerShell.
2. Enter the following command:
   1. Osql–s 192.168.20.110–u sa–p 123456
   1. Where 192.168.20.110 is the SQL Server server IP address, SA is the default superuser, and 123456 is the password for the SA user.
3. If SQL Server does not use the default instance name, you also need to specify the instance name in the command:
   1. Osql–s 192.168.20.110\instancename–u sa–p iMC123456 InstanceName is the instance name.
4. If you are able to enter SQL command mode, it indicates that you can connect to the server normally, as shown in.

Figure 5-9 Testing the connection to the database server

?

SQL Server 2012 Installation configuration (PART4)

SQL Server 2012 Installation configuration (PART3)