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'.
1, Utilize jTDS instead of Microsoft SQL Server JDBC driver
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.
分享到：
相关推荐
I will be taking some of the tips, like the Tools database and Aaron Bertrand's version of a great utility script to easily show the important info on active tasks, and putting them to use as early ...
Where appropriate, some level of discussion will be at the technical level. But, for the most part, the book is about issues and techniques. This book is meant to serve as a guideline for the designer...
An intent lock indicates that SQL Server wants to acquire a shared (S) lock or exclusive (X) lock on some of the resources lower down in the hierarchy. For example, a shared intent lock placed at the ...
data文件夹下面有SQL SERVER 数据库文件，附加到SQL SERVER 上即可， 然后更新连接字符串;Initial Catalog=IssueTrackerStarterKit2;Integrated Security=True"/> 建好虚拟目录后，根据实际访问路径，填写根目录，...
The integration of Microsoft SQL Server 2012 as the database ensures efficient data storage and retrieval. Continuous testing and optimization of the platform ensure stability and ease of operation, ...
The installation process is straightforward but requires some knowledge of command-line tools and system configuration. Once installed, the guide delves into configuring Lighttpd for optimal ...
SQL Server Compact support Code-First Development with Entity Framework 4 (data access) More flexible ACL implementation More user-friendly admin area Added unit tests Improvements ...
SQL Server Compact support Code-First Development with Entity Framework 4 (data access) More flexible ACL implementation More user-friendly admin area Added unit tests Improvements ...
Microsoft, Active Directory, Internet Explorer, Hyper-V, Silverlight, SQL Server, Windows, Windows Azure, and Windows PowerShell are trademarks of the Microsoft group of companies. All other ...
In future improvements, considering SQL Server as the database could address issues related to access speed and data sharing. This system aims for ease of use and has high expandability and ...
There is apparently some malware going around that blocks execution of Cheat Engine (Saying file missing, check filename, etc...) If you have been a victim of this then try this windows repair tool to...
and some scenarios of how you can use them. This chapter also guides you through the basics of testing your installation and configuration. Chapter 3, "Basic Features" This chapter covers the basic ...
* TDataSetProvider generates incorrect SQL in response to a RefreshRecord request in some cases and fails to update all fields properly (Quality Central 4014). * When TDataSetProvider obtains the DB ...
Examining Some Other File- and Site-Administration Issues G From Here G Chapter 11 Database Interaction Justifying Perl/Database Interaction G Examining the Database Options DBI and DBD Database ...
Keeping Track of Server Items What is Active When? Notes about Metafiles Transitions The In-Place Frame Menu Negotiation Updates UpdateAllItems() Verbs Serialization Serialize() Beyond ...
A DHCP server is scheduled to ship as part of Windows NT(TM) Server version 3.5. If you enable automatic DHCP configuration without a DHCP server available on your network, the following message ...