How to connect to a local database in SQL Server Management Studio? February 18, 2023 by Tarik Open SSMS -> Connect Server name: (LocalDb)\MSSQLLocalDB, Choose Windows Authentication. For a reference: