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, ∼2254🔥, 0💬
Popular Posts:
What is ojdbc.jar - JDBC Driver for Oracle? ojdbc.jar is a JDBC driver from Oracle that provides dat...
JDOM provides a solution for using XML from Java that is as simple as Java itself. There is no compe...
jlGui is a music player for the Java platform. It is based on Java Sound 1.0 (i.e. JDK 1.3+). It sup...
JDK 17 java.xml.jmod is the JMOD file for JDK 17 XML (eXtensible Markup Language) module. JDK 17 XML...
JLayer is a library that decodes/plays/converts MPEG 1/2/2.5 Layer 1/2/3 (i.e. MP3) in real time for...