Microsoft-SQL-server-database Contents Download the SQL Server installation. Connect to the SQL Server Database Windows Authentication SQL Server Authentication Restore the database in SSMS Create a login using SSMS for SQL Server. Create a new login using Setup Authentication mode Allow-remote-connections-to-SQL-Server Create a new databse Diagram