May 29, 2009 at 1:33 pm
Warning...newbie at the wheel:
I've installed SQL Server 2000 a couple of dozen times now (which isn't much) and nowhere did it ask for what login to use to run the services. I'm in the middle of setting up a Virtual environment with SQL Server 2008 and it's asking what account names I want to run 4 services in. Seems to me like I should've been taken to a screen to create accounts before being brought to this screen if I truely wanted to do a custom setup. The only 2 accounts it lists are...
NT Authority\Network Service
NT Authority\System
(I'm just confused as to why it's asking what accounts I want to use to run those services)
The services I need to assign a login to are...
SQL Server Agent
SQL Server Database Engine
SQL Server Analysis Services
SQL Server Reporting Services
Which account would you suggest I run for each service?
This virtual pc is being setup solely for the purposes of me learning BI topics. I have a book that has exercises in it that I'd like to follow along with. The material I create or mess around with won't ever touch our LIVE environment.
TIA,
John
May 29, 2009 at 2:07 pm
I'd use NT Authority\System. You don't need\want network access so there is no reason to use Network Service.
This is a step that was missing in earlier versions which is nice now as it also sets up local groups and assigns the user(s) you select to the appropriate groups so you don't have to worry about getting the right permissions especially for SQL Server Agent.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 29, 2009 at 2:26 pm
Thank you. I went with your suggestion and my install is running.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply