Basic Security Question

From: Jeff Rush (rushes@ev1.net)
Date: 12/12/02 

From: rushes@ev1.net (Jeff Rush)
Date: 11 Dec 2002 20:28:16 -0800

In Enterprise Manager, if I right-click the instance in the left pane,
I get a popup menu with many options. Two of the options are:

- Edit SQL Server Registration properties
- Properties

The "Edit SQL Server Registration properties" option has only one tab.
 There are two "Connection" options: 1) Use Windows authentication and
2) Use SQL Server authentication.

The "Properties" option has nine tabs, one of them being "Security".
On this security tab, there are two types of Authentication: 1) SQL
Server & Windows, and 2) Windows Only.

My question is, what is the difference between these two security
attributes. I understand Windows authentication versus SQL Server
authentication, but what is the purpose of the choice on "Edit SQL
Server Registration properties" versus "Properties". Does one apply
to normal database users while the other applies to Enterprise Manager
users?

Thanks,
Jeff

Relevant Pages

  • Re:Basic Security Question
    ... configuration for a particular SQL Server. ... authentication or Windows only authentication. ... >- Edit SQL Server Registration properties ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: I dont want to re-invent the Login/Login Wheel - Help with utilities
    ... Yes, if you use .NET1.1, there isn't built-in login control, and more importanltly there isn't ready-to-use membership component to use. ... the membership provider uses SQL Server or SQL Server Express. ... We feel that having the capability to force password change would be a better benefit in securing our application and data access. ... Both Windows authentication and authorization wolud be be fine if we wanted the world to have access to our application data, but not very intuitive for maintaining integrity over our data. ...
    (microsoft.public.vstudio.general)
  • RE: IIS (ASP) -> SQLServer Authentication Issue
    ... I understand that you'd like to use IIS Intergration authentication in the ... and ASP "impersonates" authencitaed users to access SQL Server on ... only kerberos authentication allows double-hops from clients ...
    (microsoft.public.sqlserver.security)
  • Re: SBS Premium Edition .. what way is SQL licenced
    ... Another thing to note in using your SQL Server as a backend database is the ... concept of Forms-based authentication and Integrated Windows authentication. ... thereby requiring individual CALs to access SQL Server. ... Chad A. Gross - SBS MVP ...
    (microsoft.public.windows.server.sbs)