Re: Single Sign on

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Nextcert (Nextcert_at_discussions.microsoft.com)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 08:55:02 -0800

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
>
>
>

Relevant Pages

  • Re: Microsoft Informational Alert
    ... > PSS Security Response Team Alert - SQL Security Recommendations ... > PRODUCTS AFFECTED: SQL Server ... Secure your SA login account with a non-NULL password. ...
    (microsoft.public.security)
  • Re: integrated security over vpn
    ... SQL 2000 is using Windows Authentication, and I can access tables, Stored ... > Are you using Windows authentication with SQL Server or SQL Server ... > easy to do on a home machine scenario as I would expect the home machine ...
    (microsoft.public.dotnet.security)
  • Maximum Number of Database Users and Roles
    ... of security accounts for sql server is 16379 ... I have a web site that I had/have to change the security model for which was ... originally setup using a Windows Domain Group and users to access our sql ...
    (microsoft.public.inetserver.asp.db)
  • Maximum Number of Database Users and Roles
    ... of security accounts for sql server is 16379 ... I have a web site that I had/have to change the security model for which was ... originally setup using a Windows Domain Group and users to access our sql ...
    (microsoft.public.sqlserver.server)
  • Re: [despammed] RE: SQL Slammer doing the rounds again?
    ... > and other ISA lists about how to allow inbound SQL connections ... > direct access to a SQL server across whatever network they're installed ... Network with over 10,000 of the brightest minds in information security ...
    (Incidents)