SQLTeam.com | Weblogs | Forums

Finding the version details from IP and Port

sql2012

#1

Is it possible to find the version details from IP and Port.
For example I have IP and port number known to me ,but I don't have database credentials and other details.
I want to know which version of Sql server is running.

My purpose is to find the false vulnerabilities in security scanning.

Thank you


#2

For finding the SQL Server version name try:

SELECT SERVERPROPERTY('productversion') as VersioNumber
,SERVERPROPERTY ('productlevel') as SPLevel
,SERVERPROPERTY ('edition') as ServerEdition

There is also function

select @@version

For finding the TCP port of the SQL Server see: http://mangalpardeshi.blogspot.in/2009/06/tcp-port-of-sql-server.html


#3

Yes you can find the version details just open up the errorlog, this will have details on the edition and running version of sql server.

Know more about service and application version detection. https://nmap.org/book/vscan.html