Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
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 (309)
Collections:
Other Resources:
SQL Server SQLEXPRESS Service for sqljdbc Test
How to run SQL Server SQLEXPRESS Service on my local computer to test sqljdbc JDBC driver?
✍: FYIcenter.com
If you want to test sqljdbc 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 sqljdbc JDBC connections now.
⇒ SqlServerJdbcConnection.java - sqljdbc JDBC Connection Example
⇐ sqljdbc JDBC Driver Connection Properties and Defaults
2016-12-24, 1385🔥, 0💬
Popular Posts:
What is the dom\GetElementsByTagName .javaprovided in the Apache Xerces package? I have Apache Xerce...
JDK 11 java.security.jgss.jmod is the JMOD file for JDK 11 Security JGSS (Java Generic Security Serv...
pache Derby is an open source relational database implemented entirely in Java and available under t...
JDK 17 jdk.compiler.jmod is the JMOD file for JDK 17 Compiler tool, which can be invoked by the "jav...
JDK 11 jdk.crypto.ec.jmod is the JMOD file for JDK 11 Crypto EC module. JDK 11 Crypto EC module comp...