can login from (Windows) Admin account

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Lolik (Lolik_at_discussions.microsoft.com)
Date: 07/17/04


Date: Sat, 17 Jul 2004 16:28:01 -0700

Can login from (Windows) Admin account but not from (Windows) Power User account. If I understood correctly, one can only log in with (Windows) _Admin_ account using Windows authentication. Non-admins should use the mixed mode, i.e., use SQL login rather than Windows authentication.

How does one assign (SQL) sysadmin permissions to a newly created (SQL) account?