first confirm by TCP IP to connect to SQL Server 2012
??
- ensure that Server Authentication selected SQL Server and Windows authentication mode
??
- open SQL SERVER CONFIGURATION MANAGER, Select db instance, put Named pipes TCP/IP Status Enabled
- double click tcp/ip, select IP addresses IP enabled Yes, put IPAll TCP Port 1433
Span style= "color:black; font-family: Microsoft ya black; Font-size:10pt ">
??
??
through Intellij idea to connect SQL Server config
??
- Open Intellij idea, select the Database window and click Add -Data source-sql Server-microsoft
- input configuration information for SQL Server
??
- Driver files Select SQL server/microsoft, click Download,Intellij idea will download the driver automatically.
??
??
- Click Test Connection, the following dialog box appears, indicating that the connection is successful.
??
Intellij idea Configuring database connection to SQL Server 2012