XPost: microsoft.public.sqlserver.newusers   
   From: genew@ocis.net   
      
   Dear All:   
      
        I now have "Beginning SQL Server 2008 Express for Developers From   
   Novice to Professional" (hereafter referred to as "Book") by Robin   
   Dewson.  So far, so good.   
      
        Well, actually not, or I would not be posting, but the book is   
   pretty good.   
      
        My system is running under Windows XP Home.  This means that I   
   can not do some of the work in Book's chapter 4 (Security and   
   Compliance).  I have managed an approximation.   
      
        Either my system is missing something or I am.  Possibly, both   
   are true.   
      
        My system had one account prior to this: Loop\Gene which has   
   Windows admin rights.  Per earlier Book work, I have created two more   
   accounts: Loop\VMcGlynn which has admin rights and Loop\AJMason which   
   is an ordinary account.   
      
        My understanding is that because VMcGlynn has admin rights, it   
   will have admin rights in SSE.  This will happen through   
   BUILTIN\Users.  It did not.  I had to create a login and give it admin   
   rights.   
      
        With AJMason, I also created a login, one with just public   
   rights.  I kept getting errors about permissions on various databases   
   when attempting under this login to expand the database node.  The   
   errors were like this:   
      
   Microsoft SQL Server Management Studio   
   ---   
   Failed to retrieve data for this request.   
   (Microsoft.SqlServer.Management.Sdk.Sfc)   
      
   Additional information:   
      
   |   
   -> An exception occurred while executing a Transact-SQL statement or   
   batch.   
      (Microsoft.SqlServer.ConnectionInfo)   
      
      |   
      -> The server principal "LOOP\AJMason" is not able to access the   
   database "ApressFinancial" under   
         the current security context. (Microsoft SQL Server, Error: 916)   
      
        A number of these were for the AdventureWorks databases.  What   
   would I have to do if I did not want the errors but also did not want   
   the login to have access to AdventureWorks?   
      
        One was for ReportServer$SQLEXPRESSTempDB.  Oddly, when I enabled   
   that ReportServer$SQLEXPRESS also showed in the node expansion though   
   I had not given access to it.   
      
        One was for ApressFinancial.  This is a database created in the   
   Book.  What if I do not want AJMason to have access to this database   
   but also do not want the errors?   
      
        If I get one of the above errors, the node does not expand to   
   other than system databases, so just ignoring the errors will not work   
   at all.   
      
        There are other databases installed when SSE is installed.  Which   
   of these should an ordinary user have?   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)