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 Browser Service on Instances for sqljdbc Test
How to run SQL Server Browser service on my local computer? I want to use SQL Server instance name instead of port number in sqljdbc JDBC driver connection URL string.
✍: FYIcenter.com
If you are running multiple SQL Server instances on a single SQL Server host
with different TCP port numbers,
you can run SQL Server Browser service
to allow clients to lookup port number by instance name.
You can follow these steps to turn on Browser service to start using SQL Server instance name in your sqljdbc JDBC driver connection URL string:
1. Go to "Control Panel > Services".
2. Find "SQL Server Browser" and click "Start" to run it.
3. Find all "SQL Server (*)" services that are running and write down their instance names (inside parentheses). For example, if you see "SQL Server (SQLEXPRESS)" service, SQLEXPRESS will be the SQL Server instance name.
4. Go back to your sqljdbc JDBC connection URL string, and use one of the following formats:
1. Append instance name to server name without port jdbc:sqlserver://<server>\<instance> [;<property>=<value>[;...]] Example: jdbc:sqlserver://localhost\SQLEXPRESS;user=sa;password=fyicenter 2. Add "instanceName" property without port jdbc:sqlserver://<server>[;instanceName=<instance>] [;<property>=<value>[;...]] Example: jdbc:sqlserver://localhost;user=sa;password=fyicenter;instanceName=SQLEXPRESS
⇒ SqlServerInstanceJdbcUrl.java - sqljdbc JDBC URL for Instance
⇐ SqlServerJdbcUrl.java - sqljdbc JDBC Connection URL Example
2016-12-24, 1205🔥, 0💬
Popular Posts:
What JAR files are required to run sax\Writer.java provided in the Apache Xerces package? 1 JAR file...
Apache Log4j provides the interface that applications should code to and provides the adapter compon...
JDK 17 java.base.jmod is the JMOD file for JDK 17 Base module. JDK 17 Base module compiled class fil...
Jackson is "the Java JSON library" or "the best JSON parser for Java". Or simply as "JSON for Java"....
What Is javamail-1_2.zip? javamail-1_2.zip is the binary package of JavaMail API 1.2 in ZIP format. ...