Re: can login from (Windows) Admin account

From: Michael C (nospam_at_lol.net)
Date: 07/17/04 

Date: Sat, 17 Jul 2004 23:44:43 GMT

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?

Relevant Pages

  • Re: winnt vs. sql auth
    ... The biggest benefit of using Windows Authentication is the security of the ... account access, then somewhere that account information must be stored. ... the storage of this information is on the very server that is at ... login credentials are transmitted over the network in cleartext. ...
    (microsoft.public.sqlserver.server)
  • Re: Confused about Windows Authentication
    ... appears that Windows Authentication or Mixed Mode is set at the server ... explanation on how to set up the user accounts that is  better than ... account when the normal accounts for Windows logins are restricted to ... but I want to be able to change connection strings so ...
    (microsoft.public.sqlserver.security)
  • Re: Windows authentication from ASP.net application to Sql Server
    ... | Subject: Re: Windows authentication from ASP.net application to Sql Server ... | server or on the same server with the IIS/ASP.Net? ... Use a single fixed impersonate account, ... | client/server to use restricted kerberos delegation which has critical ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: ASP.NET and IIS Security
    ... Make sure that the domain account's "Trust this account to delegate ... an application pool using an account local to the server. ... they get directed from the anonymous site to the Windows authentication site. ... If I access via the hostname I get the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: WebDAV and windows authentication?
    ... exchange store, but we are changing to WebDAV so that it won't have to ... be installed directly on the server. ... the exchange server by an account with correct access rights, ... For the Windows Authentication: Do you have enabled Integrated Security ...
    (microsoft.public.exchange.development)