Re: Single Sign on
From: Steve Thompson (stevethompson_at_nomail.please)
Date: 02/23/05
- Next message: Steve Thompson: "Re: Simple Question (I hope)"
- Previous message: Nextcert: "Re: Single Sign on"
- In reply to: Nextcert: "Re: Single Sign on"
- Next in thread: Nextcert: "Re: Single Sign on"
- Reply: Nextcert: "Re: Single Sign on"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Feb 2005 12:31:50 -0500
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).
Steve
"Nextcert" <Nextcert@discussions.microsoft.com> wrote in message
news:10D612F7-E8F5-4AAA-B3B5-4893ACC138B8@microsoft.com...
> Thank you for your response. The way we do it now, is that we assign users
> their passwords and do not allow them to change it. we also assign the
same
> password in sql, so they log on twice, in windows and the application
which
> uses sql database. Because of security requirement, we want to implement a
> passthrough authentication and let users assign and change their password.
Is
> this possible with w2k and sql2k. Thanks.
>
> "Steve Thompson" wrote:
>
> > "Nextcert" <Nextcert@discussions.microsoft.com> wrote in message
> > news:A9C750C3-B3C4-41EA-801D-7FDFB6D53B50@microsoft.com...
> > > We are in w2k domain, and we have some softwares that uses sql2k as
the
> > logon
> > > database. How do I configure the sql logon to use windows
authentication.
> >
> > Does the software support windows authentication? Normally integrated
> > security requires no user credentials for the connection to SQL Server
to
> > take place.
> >
> > In the off chance you are asking how to change SQL Server from SQL
> > Authentication (mixed) to Windows Authentication, use the Enterprise
Manager
> > MMC and change the security properties setting and restart MSSQLServer
> > service.
> >
> > Steve
> >
> >
> >
- Next message: Steve Thompson: "Re: Simple Question (I hope)"
- Previous message: Nextcert: "Re: Single Sign on"
- In reply to: Nextcert: "Re: Single Sign on"
- Next in thread: Nextcert: "Re: Single Sign on"
- Reply: Nextcert: "Re: Single Sign on"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
