From the course: SQL Server 2008 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Creating SQL Server logins and switching authentication modes - SQL Server Tutorial
From the course: SQL Server 2008 Essential Training
Creating SQL Server logins and switching authentication modes
One of the best practice for defining your principals is to make sure that they already exist as users on your domain or on your local machine and that way we're using Windows authentication as that first barrier to entry, they have to have logged on to your machine or to your domain to get there, it's not the only choice that we have. When I'm creating a new login one of the options I'll have here is to switch from Windows Authentication to SQL Server Authentication. This is not a minor difference. This is a big deal. With Windows Authentication selected the login name that I type has to exist outside. It must exist on this machine or on that domain. When I select SQL Server Authentication it really means define a new user, give them a name, give them a password. They didn't exist before. I'm just writing them and they may now exist in SQL Server. A very common reason to do this is that you have, for example, a web service application, something that needs to connect to this machine,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.