Re: Single Sign on

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 14:39:23 -0500

"Steve Thompson" wrote:

> Is you server and users in a domain configuration? If so, what you want to
> do is create an NT global group that contains your user accounts. Grant
that
> group appropriate permissions in SQL Server and appropriate permissions to
> the database(s). This is SQL Server Windows Authentication model and only
> requires one signon (login).
>

"Nextcert" <Nextcert@discussions.microsoft.com> wrote in message
news:37748C17-06D2-424D-AADD-BDC4E2291CC6@microsoft.com...
> Thank you again. I am currently looking into getting a third party
> application that will allow single sign-on. Any suggestions. Thanks.

You're quite welcome. Check that the 3rd party application supports SQL
Server Windows Authentication, sometimes refered to NT integrated security.
>From a connection standpoint, this is usually a fairly trivial change from
requiring a user account and password (separate login), to passing current
nt user credentials in an integrated manner. In my opinion, this is the way
you want to go from a security and administrative point of view.

Steve

Relevant Pages

  • Re: SELECT permission denied...
    ... of user accounts: SQL Server and Windows. ... you aren't selecting a Windows user; ... and grant that the necessary permissions. ...
    (microsoft.public.dotnet.framework.aspnet)
  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: field level security question
    ... Vyas, MVP ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
    (microsoft.public.sqlserver.security)
  • Re: Inheriting Permissions from Parent
    ... When you delegate permissions using the Delegation of Control wizard, these permissions rely on the user object that inherits the permissions from the parent container. ... Members of protected groups do not inherit permissions from the parent container. ... Within one of my OU's I have many user accounts ...
    (microsoft.public.windows.server.active_directory)
  • Re: Inheriting Permissions from Parent
    ... When you delegate permissions using the Delegation of Control wizard, ... Members of protected groups do not inherit permissions ... these permissions are not applied to members ... Within one of my OU's I have many user accounts ...
    (microsoft.public.windows.server.active_directory)