Java Web Database (SQL 2008+idea 14) environment configuration

Needless to say, after the IDEA+TOMCAT environment has been configured before, the database configuration is now required:

1. First, the installation of the SQL SERVER2008 database

(1) Unzip the downloaded SQL Server 2008 database and click on the Setup.exe file to install it (you must install it with Administrator privileges , or the latter will fail because of insufficient permissions).

(2) Select "Install" and click on the right "new SQL Server standalone installation or add features to an existing installation"

(3) If the following screen appears, restart the computer after the installation

(4) After restarting, choose Next, Baidu next SQLSERVER2008 key, choose Next, enter the installation interface,

(5) Function selection "Select All",

(6) Next, you can specify the default instance name, or you can fill out the instance name yourself

(7) Next, select "Use same user", "System User"

(8) Authentication select mixed mode, set the password yourself, and add the current user, select Next

(9) Also select "Add Current User", default state, choose Next,

(10) The following will be installed

(11) After the installation is complete, select SQL Server Management Studio in the program, the following interface appears, you can use Windows default login, you can also use the SA user, Password to log in to the password you previously set.

(12) After successful login, the following interface will appear

This completes the database installation.

2. Configuring the TCP service port

In the taskbar, click Start , point to All Programs , clickMicrosoft SQL Server SQL Server2008, configure tools, and then clickSQL Server Configuration Manager. such as:

When clicked, a new window pops up. ExpandSQL Server network configuration, select the protocol for <</span> DB instance >, such as:

Double-click TCP/IP on the right, pop-up window, select "Enabled" to "yes", such as:

Then click on the "IP Address" tab, set the port and status, click on the "OK" button to save the settings information.

Now that the TCP protocol is configured, the next step is to connect to the database in idea.

3.IDEA connecting the SQL Server database

First find the Datebase, if not, in the View menu bar to select,

Then add the database connection as shown below,

Fill in the relevant parameters, click the driver download button, download the relevant driver, such as:

Finally click the Test button, if the connection is successful, the following interface will appear

At this point, Idea and SQL Server2008 database are connected successfully!

Java Web Database (SQL 2008+idea 14) environment configuration