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?
sp_addrolemember
"Lolik" <Lolik@.discussions.microsoft.com> wrote in message
news:81DA72A8-E3AF-43FC-8764-C779CAF4D337@.microsoft.com...
> 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?
|||OOps, that's
sp_addsrvrolemember [ @.loginame = ] 'login', [ @.rolename = ] 'role'
"Lolik" <Lolik@.discussions.microsoft.com> wrote in message
news:81DA72A8-E3AF-43FC-8764-C779CAF4D337@.microsoft.com...
> 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?
|||Thanks Michael, I just had found another workaround before I read your suggestion. Please check in the following posting.
Lolik
No comments:
Post a Comment