Locate SQL servers on network

Buckaroo · 10-26-2006, 09:02 AM

What is the best way to locate all of the SQL servers on my network?

Will.Spencer · 10-26-2006, 09:29 AM

Run a port scanner like NMAP on your network.

Scan for the ports commonly used by SQL servers:

Code:

sql*net          66/tcp    #Oracle SQL*NET
sql*net          66/udp    #Oracle SQL*NET
sqlserv         118/tcp    #SQL Services
sqlserv         118/udp    #SQL Services
sql-net         150/tcp
sql-net         150/udp
sqlsrv          156/tcp    #SQL Service
sqlsrv          156/udp    #SQL Service
ms-sql-s        1433/tcp   #Microsoft-SQL-Server
ms-sql-s        1433/udp   #Microsoft-SQL-Server
ms-sql-m        1434/tcp   #Microsoft-SQL-Monitor
ms-sql-m        1434/udp   #Microsoft-SQL-Monitor
watcom-sql      1498/tcp
watcom-sql      1498/udp
postgresql      5432/tcp   #PostgreSQL Database
postgresql      5432/udp   #PostgreSQL Database

If anything answers on one of these ports, it's probably an SQL server.