Re: what happend if deny login to "sa"??

From: Hernán Castelo (hhh_at_hotmail.com)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 14:25:01 -0300

oh...of course
i understand 

-- 
atte,
Hernán Castelo
UTN Buenos Aires
.  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .
"Sue Hoegemeier" <Sue_H@nomail.please> escribió en el mensaje
news:i87o701h6bgq839p4he1pbs7efmafatich@4ax.com...
You can't use sp_denylogin with sa as it's not a Windows
user or group. For SQL Server logins, you need to use
sp_droplogin. And SQL Server does not allow you to use
sp_droplogin to drop sa. You'd have to hack the system
tables to remove sa and then you will end up with other
problems as a result of doing this.
If you want to prevent logins with sa, use Windows
authentication only. You have better security if you use
Windows authentication only.
-Sue
On Tue, 13 Apr 2004 13:36:21 -0300, Hernán Castelo
<hhh@hotmail.com> wrote:
>hello
>well, its all said:
>what happend if deny login to "sa"??
>
>i get more secure?

Relevant Pages

  • Re: Windows Authentication question
    ... logins for our applications, because we are using NetWare for users. ... Windows authentication is more secure. ... then connect to SQL Server on your behalf. ... If your application is a two-tier app, ...
    (microsoft.public.sqlserver.security)
  • Re: Need Help w/ SQLServer Express Authentication
    ... Windows Authentication can not be disabled using Mixed Authentication. ... You can only disable SQL Server authentication and Microsoft recommends using Windows Authentication when possible. ... Logins make your users to connect and perform their tasks in SQL Server. ...
    (microsoft.public.sqlserver.setup)
  • RE: Facing Error: 15401 while creating local logins
    ... I got that error today while doing some security accounts; ... I have SQL server installed on a cluster enviroment, ... 2005 with windows authentication, I am getting an Error: ... I am able to carete domain logins in sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... users must give their logins and passwords again. ... >> We're trying to make our Intranet pages use Sql Server ... >> Windows Authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
Loading