Re: Client Enterprise manager security

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 09/26/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Wed, 25 Sep 2002 20:35:34 -0600

But Alli's post specifically stated:
without having to manipulate the "always prompt for login
name and password"

-Sue

On Wed, 25 Sep 2002 22:18:39 GMT, lanlb@online.microsoft.com
(Lan Lewis-Bevan [MS]) wrote:

>To configure it from client side, you can check the box of " Always prompt
>for login name and password" from registered SQL server properties page for
>SQL authentication:
>
>This check box specify that SQL Server must always prompt for the login
>name and password when a user connects to the server using SQL SEM and SQL
>Server Authentication.
>
>
>Regards,
>
>Lan Lewis-Bevan
>SQL Server Support
>
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>Are you secure? For information about the Strategic Technology Protection
>Program and to order your FREE Security Tool Kit, please visit
>http://www.microsoft.com/security.

Relevant Pages

  • Re: Client Enterprise manager security
    ... To configure it from client side, you can check the box of " Always prompt ... SQL authentication: ... This check box specify that SQL Server must always prompt for the login ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server 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)