TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.
How to Create SQL Server Authenticated Login in SQL Server - SQL Server DBA Tutorial
In this video you will learn step by step how to create SQL server Login using SQL Server Authentication. It shows step by step process using SQL Server management studio as well as creating SQL Server Authentication login using T-SQL Script. It talks about different options such as password Policy management of SQL Server and default database best practices.
Script used in this video to Create SQL Server Login USE[master] GO CREATELOGIN [Techbrothers] WITHPASSWORD=N'Pa$$w0rd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
SQL Server DBA Tutorial - Create SQL Server Authenticated Login in SQL Server