Some issues of SQL Sever

最新推荐文章于 2021-05-07 12:51:48 发布

原创最新推荐文章于 2021-05-07 12:51:48 发布 · 162 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#SQL #SQL Server #Sybase #JDBC #Microsoft

DataBase 专栏收录该内容

8 篇文章

订阅专栏

本文介绍了如何解决SQL Server无法启动及连接失败的问题，包括启用TCP/IP协议、配置端口及设置登录模式等步骤，并推荐使用jTDS作为连接驱动。

SQL Sever:

1. because protocol of VIA is enabled, SQL Server can not be started.

2. enable feature of connecting SQL Sever by TCP/IP
jdbc:jtds:sqlserver://192.168.1.100:2374;DatabaseName=***
open tool of 'SQL Server Configuration Manager', select sqlserver protocols， enable TCP/IP

3. check port of SQL Server
in sql server protocols, open property of TCP/IP, click tab of 'IP Addresses', view 'TCP Dynamic Ports' of 'IPALL'.

4. Login failed for user 'test'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
Solution: open 'SQL Server Management Studio', right-click the properties of SQL Server instance, click 'Security', enable 'SQL Server and Windows Authentication mode' of 'Server authentication'.

[b]1, Utilize jTDS instead of Microsoft SQL Server JDBC driver[/b]
1) Introduction of jTDS
jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005 and 2008) and Sybase (10, 11, 12, 15). jTDS is based on FreeTDS and is currently the fastest production-ready JDBC driver for SQL Server and Sybase. jTDS is 100% JDBC 3.0 compatible, supporting forward-only and scrollable/updateable ResultSets, concurrent (completely independent) Statements and implementing all the DatabaseMetaData and ResultSetMetaData methods. Check out the feature matrix for more details.
For more detail, refer to http://jtds.sourceforge.net/
2) It exists in Maven repository.