Re: Authentication mode questions

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 08/08/03 

Date: Fri, 08 Aug 2003 08:56:41 -0600

1. The same connection dialog box is used whenever
connecting with Query Analyzer. It's just giving you the
option of how you want to connect but doesn't have anything
to do with what authentication mode is valid on the server.
It wouldn't know what authentication mode would be valid as
this client tool doesn't know what server you may be
connecting to and it isn't connected to any server when the
dialog box comes up.
2. EM will use whatever you set up when you register the
server. You can change this by right clicking on the server
and selecting Edit Registration properties.

-Sue

On Fri, 8 Aug 2003 15:43:58 +0100, "Rob Rutherford"
<rob@rcrutherford.invalid> wrote:

>I'm trying to understand security having recently installed SQL Server 2000
>developer edition on a machine using Win XP Home and I'm confused already.
>I'd be grateful to receive advice on the following questions.
>
>1) With authentication set to Windows only , Query Analyzer lets me
>select how I want to connect - why is this (since I assume SQL Server authentication
>is not valid in this case)?
>2) Enterprise Manger seems to connect (or fail to connect) automatically, presumably
>using Windows authentication. This is the case even when authentication is set to SQL
>Server and Windows. Does this mean that EM never uses SQL Server authentication?
>

Relevant Pages

  • Re: Forms authentication - change password
    ... Contact the server administrator. ... I think your authentication validation method needs to be set to ... the change password feature within ISA ... | | meant not connecting to a Global Catalog. ...
    (microsoft.public.isa)
  • Re: HTTP Access to AS 2005 not working
    ... I agree with Darren that this Activex control such as pivottable on client ... side need to authenticate to server by itself when connecting. ... but prompted to input credential to access of server (basic authentication ...
    (microsoft.public.sqlserver.olap)
  • Hostname given to XP clients
    ... a firewall too) A Site is set up with Windows Authentication only. ... Now the actual dialog box says 'Connecting to ... So if the name of the server was web19 and the site being ...
    (Focus-Microsoft)
  • Re: Remote Desktop authentication
    ... So it's no way to use RDC with Windows Authentication then? ... Attempt authentication-->Trys to confirm the identity of the server ... you are connecting to by examining the server's certificate. ... The identity of the remote computer cannot be determined because the ...
    (microsoft.public.windows.terminal_services)
  • Re: Remote Desktop authentication
    ... No authentication-->Does not attempt to confirm the identity of the server you are connecting to. ... Attempt authentication-->Trys to confirm the identity of the server you are connecting to by examining the server's certificate. ... If I choose Require authentication I can't connect ... The identity of the remote computer cannot be determined because the ...
    (microsoft.public.windows.terminal_services)