Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (102)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (322)
Collections:
Other Resources:
SQL Server SQLEXPRESS Service for jTDS Test
How to run SQL Server SQLEXPRESS Service on my local computer to test jTDS JDBC driver?
✍: FYIcenter.com
If you want to test jTDS JDBC driver and do not have any SQL Server database to access,
you can follow these steps to run SQL Server SQLEXPRESS Service on my local computer.
1. Download SQL Server 2014 Express edition from Microsoft Website.
2. Install SQL Server 2014 Express edition by double-clicking the downloaded file, SQLEXPRWT_x86_ENU.exe.
3. Change the default password of "sa" account to "fyicenter" during the installation.
4. Run "SQL Server 2014 Configuration Manager". And go to "SQL Server Network Configuration > Protocols for SQLEXPRESS".
5. Enable the TCP/IP protocol. And open its properties.
6. Set TCP Port to "1433", the default port number for SQL Server, on the "IP Addresses" tab.
6. Go to "SQL Server Services". And restart "SQL Server (SQLEXPRESS)".
Your SQL Server is ready to take jTDS JDBC connnections now.
⇒ JtdsSqlServerJdbcConnection.java - jTDS JDBC Connection Example
⇐ jTDS JDBC Driver Connection Properties and Defaults
2017-02-03, ∼3025🔥, 0💬
Popular Posts:
JAX-RPC is an API for building Web services and clients that used remote procedure calls (RPC) and X...
commons-lang-2.6.jar is the JAR file for Apache Commons Lang 2.6, which provides a host of helper ut...
Apache Commons Lang 3 is the 3rd version of Apache Commons Lang, which provides a host of helper uti...
What Is poi-scratchpad-5.2.3.jar ?poi-scratchpad-5.2.3.jar is one of the JAR files for Apache POI 5....
What Is mail.jar of JavaMail 1.4.2? I got the JAR file from javamail-1.4.2.zip. mail.jar in javamail...