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

Creating SQL Server logins and switching authentication modes - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

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,…

Contents