Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Next up is an optional step, but it's one I want to spend a couple of minutes on. You see once SQL Server is installed, it won't just be running as one piece. As I mentioned before, it will really be running in the background as several different components and the recommended best practice is that each of these components has its own unique identity that it runs under an account that was created just for that piece. Now it's certainly arguable that you don't need to go to all this trouble when setting up a simple development SQL Server, that you can just give them all the same account.
But I want to show this process. So I'm going to go ahead and set up five accounts. One for the core database engine, one for the part of SQL Server called the SQL Server Agent, and that handles a lot of background jobs and processes to keep everything running, and three for the big junk pieces, Reporting Services, Analysis Services and Integration Services. While there are a couple of other components of SQL Server that could have their own accounts, like full text search and the SQL browser, I'm going to use one of the built-in low-privileged accounts on this machine when it comes to the installed.
So I am on Windows 7. I'm going to go to the entry for My Computer, right-click it, and select Manage. This might be a little different if you're on another operating system. I'm going to expand my Local Users and Groups. Now this machine that I'm on is not connected to a domain. So I'm just creating local users. I need to create five accounts here. I'll right-click, saying New User, and make the first one. I will call this one SQLEngine.
We give it a password, whatever you want there. This is not a real user, so they can't change the password of the next logon. So I'm going to uncheck that and select that for our purposes Password never expires is OK, and click Create. I'm just going to repeat the process for the other four accounts. Now it doesn't matter what the names are. It's just useful if when you're later looking at these you can recognize why a particular account was set up in the first place.
So I now have my five accounts ready to go. You'll see that during the install I will have a chance to plug these into the right places. I don't need to make any security changes to these accounts as the SQL Server install will grant any necessary privileges during that install procedure.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 80593 Viewers
80 Video lessons · 132842 Viewers
52 Video lessons · 66348 Viewers
59 Video lessons · 52117 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.