Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In SQL Server 2008 Essential Training, Simon Allardice explores all the major features of SQL Server 2008 R2, beginning with core concepts: installing, planning, and building a first database. Explore how Transact-SQL is used to retrieve, update, and insert information, and gain insight into how to effectively administer databases. The course also covers features outside SQL Server's database engine, including technologies that have grown up around it: SQL Server Reporting Services and Integration Services. Exercise files are included with the course.
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.
Find answers to the most frequently asked questions about SQL Server 2008 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.