Hi Chris,

There is an application in house that builds a user name that is entered by a admininstrative user of the application. There is a job in SQL Server that will give grant DB rights to the user. The job fails when the user is not a valid NT user. The problem really is in the application...they need to check if the user is valid or not. I'm just wondering if it's possible for SQL Server to check this. Anyone?

Kaze

"Lepingwell, Christopher" <Christopher.[Email Address Removed] wrote:
Define valid. If they can connect to SQLserver they are by definition
valid.

-----Original Message-----
From: Kaze [mailto:[Email Address Removed] 28 July 2003 16:55
To: LazyDBA.com Discussion
Subject: Checking for Valid NT User in SQL Server



Hi all,

Is there anyway of checking if a user is a valid NT or Windows 2000 user
from SQL Server?

Thanks!

Kaze


---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software


---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
MS Sql Server LazyDBA home page