Join Gerry O'Brien for an in-depth discussion in this video Creating logins, part of Securing SQL Server 2012.
Logins are where you begin to establish the accounts…for users and applications connecting to your SQL Server instance.…Knowing how to create logins for each type of account is imperative…to ensure that only authorized users have access to your SQL instance.…Let's go ahead and take a look at what…is required to add a Windows Login to SQL Server.…To start with, we'll need to ensure that a Windows account exists.…Depending on your operating…system, the creation of local Windows account may differ.…In our case, we're using Windows 8, and we will use the…Manage Accounts portion of the User Accounts from within the Control Panel.…
Clicking the Add a new user in PC settings link, opens up the…PC settings dialogue box and allows us to create a new Windows user.…Note that this will be a local account for this computer only.…Our demo machine is not connected to a…Microsoft Windows Active Directory Domain, Domain Controller.…Therefore we will not demonstrate how to create a domain account…or to add a domain account to your SQL Server instance.…
- Understanding security best practices
- Managing logins and users
- Understanding how SQL Server checks permissions
- Creating and assigning logins and roles
- Securing SQL on the network