I checked out How can I decide put in SQL Server situations and their variations? already however CMD returns nothing:
C:Windowssystem32>sqlcmd -L C:Windowssystem32>
However when utilizing Visible Studio (v2019), I am going to View > SQL Server Object Explorer, I see two SQL Server situations with system databases inside. One is named (LocalDB)MSSQLLocalDB and the opposite (LocalDB)ProjectsV13.
Each are utilizing SQL Server 2016 (v13.0.4001). Utilizing that I used to be capable of join by way of SSMS 2018 as nicely.
My query is: why aren’t these situations exhibiting up within the command line? And might I delete one of many server occasion? Why are there two?
I checked my companies and I there may be solely SQL Server VSS write. every thing else is irrelevant to SQL. I appeared up in SQL Server configuration supervisor however SQL Server companies is empty there as nicely. I checked in C:Program Information (x86)Microsoft SQL Server90Shared and sqlbrowser.exe was not there additionally.
I simply tried organising inbound and outbound guidelines on TCP 1433 and UDP 1434 to permit connections. Failed once more with nothing returned from cmd.
I turned on firewall logs and checked the logs after working the command a couple of instances however nothing is being recorded (success or failure). I opened powershell and did test-netconnection to my ip and port 1433 and 1434 however the ping failed. Nonetheless nothing written to the firewall log recordsdata.