79308140

Date: 2024-12-25 18:29:18
Score: 1
Natty:
Report link

It's may be, that SQL Server fully local and it have not remote access. By example, SQL Server Express is local. So, sqlcmd -L cannot find the local server because this server is not responding to the broadband access request.

I use this command

sc queryex | grep "MSSQL" It return, for example

Service_Name: MSSQL$SQLEXPRESS2 Service_Name: MSSQL$SQLEXPRESS It get list of all system services and find services with name constraints "MSSQL". It return list of system services for every MS SQL instances. But it return only local instances, on current machine, for remote server, on remote machine, use sqlcmd -L.

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Dmitry Bykov