If you open SQL configuration manager you will see that it has available protocols for each instance loaded. Those 3 are usually Shared Memory, Named Pipes, and TCP/IP. The first one is on by default and the final two are not. So a scan to a remote sql system (which could be a pc with express edition loaded even, will fail because nothing is enabled for network scans. Plus you have firewall ports to deal with as well.
So, My question is, does anyone have a way to scan for these'?
My ultimate goal here is to find any system with SQL loaded and all the associated databases there. Right now, I am seeing If no connections can be established, the All SQL Server Editions and Databases report in Lansweeper will not return machines loaded with SQL Server and databases.
The All SQL Server Editions and Databases report uses and Inner Join from tblSqlServers.
The assetid in the tblSqlServers table will not appear within the tblSqlDatabases since no connections could be made. No record is created tblSqlDatabases which contains names of databases.
The machine will appear in ALL SQL Server Editions but this report only utilizes the tblSqlServers table.