up vote 1 down vote favorite
share [g+] share [fb]

Ok I am setting up SQL Server Express 2008 R2 and I am at the following screen:

enter image description here

What do I need to do here. Can I just press next? I'm guessing if I press next it will work but is this what you're really supposed to do?

Basically I don't fully understand what's going on here and I don't just wan't to keep hitting next as I know it will come back to bit me in the ass later.

Thanks

link|improve this question
100% accept rate
1  
This probably belongs on Serverfault, although I guess maybe the OP want to set up a development machine. – ConcernedOfTunbridgeWells Nov 8 '11 at 12:07
That's correct, I'm setting up a development machine so need to know what options will get me the optimum development environment. – JMK Nov 8 '11 at 12:10
feedback

migrated from stackoverflow.com Nov 8 '11 at 12:14

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 3 down vote accepted

Yep, just press next.

Basicall SQL2008 is asking you which system user should run the database executables. If you are installing this in your own developer machine I wouldnt worry too much about it.

If you are installing this on a DEV, UAT or LIVE server then I would pay more attention to who is running these processes, you can pick a specific account but SYSTEM, NETWORK SERVICE are all good choices.

link|improve this answer
1  
Agreed - if it's a dev machine, I'd start the SQL Server Browser service, too. – Dan Nov 8 '11 at 12:26
1  
And as you the answer states, if this is going to be live, make sure you have a good understanding of what you need to do. Make a new user account and give it the minimum necessary privileges to run SQL. msdn.microsoft.com/en-us/library/ms143504.aspx?ppud=4 has a great explanation. – Chris N Nov 8 '11 at 12:33
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.