Connecting SQL Server Exceptions

Schneider's built-in SQL Server database uses the default Windows login mode so that we cannot remotely connect over IP, and this is where the modification method is recorded.

1. Modifying the TCP/IP protocol used by SQL Server services

A) Bring up SQL Server Configuration Manager in all programs, such as:

b) Select TCP/IP in SQL Server Configuration Manager

c) Right-click Properties, as Configured

d) Restart the SQL Server service to

2. Modify SQL Server default login mode

After pressing 1 to modify the service, we through the user password or unable to log in, this time the reason may be the installation of SQL Server instance, set it only allow Windows Authentication mode login, modified to Windows authentication can also be SQL Server authentication, can be modified as follows:

A) log in to the database by using SQL Server Management Studio as a certified method, such as:

b) Right-click the connection name check properties

c) under "Security" Select SQL Server and Windows authentication mode save

d) Select the "sa" User, right-click on the property, modify its password and access to the database

With the above modification, you can connect to SQL Server by using the following string in JDBC mode.

jdbc.driverclassname=com.microsoft.jdbc.sqlserver.sqlserverdriverjdbc.url=jdbc:sqlserver://localhost:1433; Integratedsecurity=true;databasename=taclogdata

Connecting SQL Server Exceptions