From: genew@ocis.net   
      
   On Sat, 16 Oct 2010 19:46:42 +0200, Erland Sommarskog   
    wrote:   
      
   >Gene Wirchenko (genew@ocis.net) writes:   
   >>      Maybe, you could tell what information I should provide you.  I   
   >> am installing (trying to install) on a Windows XP Home system which is   
   >> a freestanding workstation.  I am installing from my account which is   
   >> administrative.  I apparently have no way of dealing with service   
   >> accounts; at least, I have not seen anything about them on my system.   
   >   
   >Again, right-click My Computer, select Manage. Go to the Services   
   >node (which is under Servics and Applications) as I recall. Here you   
   >see all service that are running on your system, or could be running.   
   >Select anyone of them. Right-click. Select Properties. Go to the second   
   >tab, Log On. Here you see a dialog "Log on As". Here you can select   
   >between "Local System account" or a specific user account. That is   
   >the account for the service, or simply the service account.   
      
        I made a list of the accounts that I found: Local System, Local   
   Service, and Network Service.  Yes, I went through every service.   
   Desperation.   
      
   >The user account can be your regular user account, or an account you   
   >create for the task. (The latter is to recommend, because then it will not   
   >be an admin account, and you don't have to remember to update the password   
   >if you change it.)   
      
        Not with SQL Express Setup.  It did not like my administrative   
   account (Loop\Gene).   
      
   >One thing I don't know exactly how it works. There are apparently at   
   >least three special system accounts: LocalSystem, LocalService and   
   >NetworkService. How you would specify the other two in the dialog I   
   >described, I don't know. What I know is that while Express may install   
      
        I used "NT Authority\".   
      
   >with Network Service by default it is not always a good choice. The   
      
        Oh?   
      
        Local Service did not work (failed installation).  Local System   
   was not acceptable to the setup program.   
      
        Network Service worked.   
      
        ***** Yes, I finally got SQL Express installed. *****   
      
   >certificate thing you ran into is one of them. Another is that Filestream   
   >does not work when you have Network Service. It worked when SQL 2008   
   >shipped, but then there came a security fix for Windows...   
      
        When I know what this means, I may be more concerned.   
      
   >Personally, I always install SQL Server to run under a user account   
   >(i.e. a domain account).   
      
        You mean like my Loop\Gene?  It was not acceptable to the set up   
   program.   
      
      
        FINALLY.  This has been a very traumatic month.  I definitely had   
   strong fear reactions comparable to someone who has been hit   
   repeatedly: anticipating more hitting.  Software installation should   
   not be this difficult.   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)