Re: Single Sign on
From: Nextcert (Nextcert_at_discussions.microsoft.com)
Date: 02/23/05
- Next message: Robert Richards via SQLMonster.com: "Log shrinking in simple recovery"
- Previous message: Leon Shargorodsky: "RE: alert for database drop"
- In reply to: Tibor Karaszi: "Re: Single Sign on"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Feb 2005 10:11:08 -0800
Thank you again. I am currently looking into getting a third party
application that will allow single sign-on. Any suggestions. Thanks.
"Tibor Karaszi" wrote:
> A single login is definitely possible, but it work a bit differently from how you describe it:
>
> There are two types of login in SQL Server. The one you want to use is called "Windows login". You
> allow a windows account to logon to SQL Server. SQL Server does not store any password for windows
> logins. However, the application need to do the login as a Windows login, as I mentioned this is an
> attribute in the connection string that the application submits with the login packet. Look as Query
> Analyzer, for instance, there you have a choice of doing either a SQL Server login (supply the login
> name and a password), or a Windows login (where you don't specify anything). In other words, you
> need to check if your application allow you to use Windows logins. If not, you are out of luck until
> they fix it.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
>
> "Nextcert" <Nextcert@discussions.microsoft.com> wrote in message
> news:ADE13187-56B5-45CB-A413-FE0B8F4930DB@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.
> >
> >
> > "Nextcert" wrote:
> >
> >> 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.
>
>
>
- Next message: Robert Richards via SQLMonster.com: "Log shrinking in simple recovery"
- Previous message: Leon Shargorodsky: "RE: alert for database drop"
- In reply to: Tibor Karaszi: "Re: Single Sign on"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
