857f80b5   
   From: hugo@perFact.REMOVETHIS.info.INVALID   
      
   On Tue, 19 Oct 2010 15:09:49 -0700 (PDT), xo wrote:   
      
   >Hello,   
   >   
   >I am getting the following error when I tried to connect with a user   
   >logon through SQL Query Analyzer. And this user has Database Creator   
   >server role, and public, db_owner database access granted. Does it   
   >require more permission?   
   >   
   >   
   >Unable to Connect to Server G1:   
   >Server: Msg 18456, Level 16, State 1   
   >[Microsoft][ODBC SQL Server Driver][Sql Sever] Login failed for user   
   >'V1'   
   >   
   >   
   >Thanks in advance.   
      
   Hi xo,   
      
   Have you checked the default database assigned to the login? If the   
   login has no permissions in that database, the login will fail.   
      
   Also, check the error log. Messages returned to the client on a login   
   error are deliberatly sparse to make the hackers' life miserable, but   
   more details should be included in the error log.   
      
   --   
   Hugo Kornelis, SQL Server MVP   
   My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)