`
7wolfs
  • 浏览: 176989 次
  • 性别: Icon_minigender_1
  • 来自: 济南
社区版块
存档分类
最新评论

Some issues of SQL Sever

阅读更多
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.


分享到:
评论

相关推荐

    Beginning SQL Server 2005 Administration

    Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration.Drawing ...

    Professional Microsoft SQL Server 2008 Administration

    Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the ...

    基于sql server课程设计

    关于数据库开发的 I originally approached Java as “just another programming language,” which in many senses it is. But as time passed and I ...point there were always other issues that were consid

    sql 2005 new feature

    SQL Server 2005 is the most exciting release of SQL Server for years. It may be the only release in the last five years, but it’s genuinely an exciting release full of new and useful features. In ...

    SQL Server MVP Deep Dives in Action

    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 ...

    Microsoft SQL Server 2008 - T-SQL Querying

    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...

    微软内部资料-SQL性能优化3

    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 ...

    Oracle PL/SQL programming(5th Edition)

    on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database ...

    Infinity Science – Software Engineering and Testing.pdf

    25.3 Creating Reports Using DSN of the SQL Server 2000 Database 451 25.4 Creating Connection Using DSN 456 Chapter 26. Error Handling 465 26.1 Key Handling 465 26.2 Key Locking at Key Press ...

    IssueTracker Issue Tracker 问题跟踪系统

    data文件夹下面有SQL SERVER 数据库文件,附加到SQL SERVER 上即可, 然后更新连接字符串;Initial Catalog=IssueTrackerStarterKit2;Integrated Security=True"/> 建好虚拟目录后,根据实际访问路径,填写根目录,...

    The.New.Relational.Database.Dictionary.Terms.Concepts.and.Examples

    No matter what DBMS you are using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can always arise over the precise meanings of terms, misunderstandings that can have a serious effect ...

    NopCommerce (ASP.NET商城) v2.0 源码包.zip

    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 ...

    NopCommerce (ASP.NET商城) v2.0.zip

    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 ...

    AppController.Beta

    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 ...

    CE中文版-启点CE过NP中文.exe

    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...

    JDBC Developers Guide Reference.rar

    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 ...

    Delphi7.1 Update

    * 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 ...

    Using Perl For Web Programming.pdf

    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 ...

    Professional.MFC.with.VC6

    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 ...

Global site tag (gtag.js) - Google Analytics