Hello,
Would to ask your guidance, but to be honest I don't have any experience on SQL Server Administration, so probably need a clear "To do steps" over here.
So currently I have two VM that both have its SQL Server DB installed. The question is : if I want to query the other DB from my VM by using SSMS how am I going to achieve that ?
For example, I have VM A and VM B, VM A is my development VM, but if I need to query something I want to query DB in VM B.
Currently, using SSMS, when I try to Connect and put the Server name of VM B then using SQL Server Authentication and use VM B user (admin) and its password, it will say error "Network path not found"
What are the steps to connect and querying DB on another VM ?