How to find the port for MS SQL Server 2008?

I am running MS SQL Server 2008 on my local machine. I know that the default port is 1433 but some how it is not listening at this port. The SQL is an Express edition.

I have already tried the log, SQL Server Management Studio, registry, and extended stored procedure for finding the port. But, I could not find it. Please help me. Thanks.

Click on Start button in Windows. Go to All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager

Click on SQL Native Client 10.0 Configuration -> Client Protocols -> TCP/IP double click ( Right click select Properties ) on TCP/IP

You will find Default Port 1433.

Depending on connection, the port number may vary.

Microsoft SQL Server JDBC Driver

Installing and Configuring the Microsoft SQL Server JDBC Driver

Microsoft does not allow the redistribution of the JDBC driver for the Structured Query Language (SQL) server 

by other vendors, such as Oracle. So, you need to download it from the Microsoft website, and install it into the

 PS_HOME\class directory.

To load and configure the Microsoft SQL Server JDBC Driver:

1. Download the Microsoft SQL Server Driver for JDBC from Microsoft.
   Note: These drivers are not used by Tuxedo or the web server, so you can ignore any comments on
2.  this site about supported versions of various web servers.
3. Save the program to disk in c:\temp or desktop.
4. Double-click the sqljdbc_<version>_enu.exe file.
5. Accept all the defaults.
   The JDBC driver files are installed in C:\program files\microsoft SQL server <ver> JDBC Driver\lib.
6. Copy these files to PS_HOME\class:
• For Microsoft SQL Server 2005 1.0/1.1/1.2 JDBC drivers copy sqljdbc.jar.
• For Microsoft SQL Server 2008 2.0/3.0 JDBC drivers copy sqljdbc.jar and sqljdbc4.jar.

Microsoft JDBC Driver for SQL Server

The Microsoft JDBC Driver for SQL Server is available to all SQL Server users at no additional charge from Microsoft. It provides access to SQL Server 2000-2014 from any Java application.

Required File(s)

sqljdbc4.jar

Default Driver Class

com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC URL Format

jdbc:sqlserver://<host>[:<port1433>];databaseName=<database>

More information and download

Microsoft

jTDS JDBC Driver

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005, 2008, 2012) and Sybase (10, 11, 12, 15).

 This driver is co-packaged with DbVisualizer.

Required File(s)

jtds-1.2.5.jar

Default Driver Class

net.sourceforge.jtds.jdbc.Driver

JDBC URL Format

jdbc:jtds:sqlserver://<host>[:<port>][/<database>] 

Example:

jdbc:jtds:sqlserver://localhost:5000/myDB

jdbc:jtds:sqlserver://192.168.10.201:5000/SAMPLE

More information and download

jTDS web site

Notes

Installation Notes: Download the jtds-nn-dist.zip file, unzip it and then load the jtds.jar file in the DbVisualizer Tools->Driver Manager or in the Tools->Connection Wizard.

Page Navigation Header