From the course: SQL Server 2014 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Instance-level logins

Instance-level logins - SQL Server Tutorial

From the course: SQL Server 2014 Essential Training

Start my 1-month free trial

Instance-level logins

“

- In this section, I'd like to look at creating a login at the instance level of SQL Server. The inside of Management Studio, I'm going to open up the Security tree, and the top option we see there is Logins. I'll go ahead and open that up. And we'll see a list of the existing logins. I'm going to right click on Logins, and say New Login. And that'll take me to a dialog box with multiple tabs. The first tab, which is the General tab. I'll need to specify a Login name, and I could do that as a Windows user, but instead for this one, I'm going to do a SQL Server authenticated user, because I'd like to store and manage the password here in SQL Server. For the Login name, I'll give it a name of TestLogin, and I'll choose a password that I can remember. On the checkboxes, I'm going to clear out the User must change password at next login, just not necessary for this demo. And I'll leave the rest of the defaults on this tab. Now looking at the Server Roles tab, here is where I can set up…

Contents