is there a way to scan for SQL server protocols and their status

[AZHockeyNut]

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.

[Esben_D]

Check out:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQLServer\SuperSocketNetLib

For me it has registry keys for all the protocols.

[AZHockeyNut]

Charles.X wrote:
Check out:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQLServer\SuperSocketNetLib

For me it has registry keys for all the protocols.

That's a start thanks. The trick will be calculating all the different versions and named instances....See if the instance name is other than SQLEXPRESS then that will vary and it is not the MSSQL14 it could be 13, 12, etc....you get the picture. Meaning a little trial and error will be in order but I think you got me on the right track. thanks!