Default SQL Server Port

sql-server database networking port
user3211604 picture user3211604 · Jan 19, 2014 · Viewed 129k times · Source

I have a VB6 application that uses SQL server. It needs to access it through a LAN. Therefore I want to make an exception in firewall.

What is the default port of microsoft SQL server ?

(I am using Microsoft SQL Server 2005)

Answer

Buddhika Ariyaratne picture Buddhika Ariyaratne · Jan 19, 2014

The default port of SQL server is 1433.

Related questions

MS SQL Server - Bulk Insert Across a Network

I have an application that uses MS SQL Server for which I'll need to do a bulk insert from a file. The sticking point is that the database and my application will be hosted on separate servers. What is the …

Read More
Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More