Re: Login Authentication for Standard Accounts
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 22 Jun 2007 21:46:44 +0000 (UTC)
RogerT (roger.tompkins@xxxxxxxxx) writes:
We have a couple of vendor applications that create standard accounts.
These accounts have the same format as our domain accounts. For
example, my Windows account would be <domain>\<user_name>. The SQL
standard account would be <user_name>.
What we would like to do is change the login process to validate
against active directory either prior to or instead of checking the
SQL password. Everything else could remain the same.
This would be on SQL 2000 or SQL 2005. Any suggestions or other
insight would be appreciated.
I'm not really sure what you mean here. SQL Server provides to
means of authentication: SQL authentication and Windows authentication.
It sounds from your description that the vendor accounts are for
SQL authentication. But you cannot change a login from being an SQL
login, to be a Windows login. These two types of logins are competely
unconnected.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Login Authentication for Standard Accounts
- From: RogerT
- Login Authentication for Standard Accounts
- Prev by Date: Login Authentication for Standard Accounts
- Next by Date: Re: Change Password Role
- Previous by thread: Login Authentication for Standard Accounts
- Next by thread: Re: Change Password Role
- Index(es):
Relevant Pages
|
|
