Navigate in Microsoft SQL Server Management Studio

You must be connected to a server to manage it in Microsoft SQL Server Management Studio.

After you connect to the server, you can view the entire console tree associated with the server, including all of the devices and databases. You can expand folders just as you do in Windows Explorer.