SQl 2008 "Service Accounts" Set-up

route217
route217 used Ask the Experts™
on
Hi Experts

I am trying to set up the Service Account for Sql 2008 in Computer Management using xp 2007 home edition....

and i cannot do it...as the Local User and Group folder is missing.....

i have purchased MS Sql 2008 step - by - step book and I am following the instruction....

 
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
The home edition has some restrictions.

On the microsoft website the home edition is not supported by sql 2008 R2
http://msdn.microsoft.com/en-us/library/ms143506.aspx

It seems that the main difference is the possibility to login on a windows domain.

It is possible to install a developer edition on the home edition

route217Junior

Author

Commented:
many thanks for the feedback...

would installing sp3 make any difference?

what about installing sql 2008.....or is that the same as sql 2008 r2
Commented:
Makes no difference sp3 or not.

On the top of the website you can switch sql version and see the results for sql 2008
http://msdn.microsoft.com/en-us/library/ms143506.aspx

It mainly the difference between professional and home edition.
The developer edition is for almost all os versions.

For example xp professional is possible with sql 2008R2.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial