Check validity of NT username

From: Andy (Andy_at_discussions.microsoft.com)
Date: 06/02/05 

Date: Thu, 2 Jun 2005 11:10:05 -0700

Is there a stored procedure that can be run where you pass in a NT username
and it tells you if it is valid or not? I would like to do this because we
have users setup with access to our SQL Servers and as somebody leaves the
company we want to remove their login. Something like

sp_ntusername 'domain\username'????

Thanks

Relevant Pages

  • Re: Creating Customer Web Portal
    ... Roles and Profiles system that integrates with the database ... which a stored procedure builds for us. ... I want a simple login page with username and password. ...
    (microsoft.public.frontpage.addins)
  • Re: Delpoyment Issue
    ... you can attempt to call a stored procedure on the database. ... the connection string is wrong (username and password), ... and you know the login is invalid. ... I'm using is SQL 2000. ...
    (microsoft.public.dotnet.languages.csharp)
  • Permissions
    ... I have a stored procedure that I am trying to run through an application. ... login through query analyzer using the same username and password as the ... Through query analyzer I am able to run the stored ...
    (microsoft.public.sqlserver.programming)
  • Problem handling Login control Authenticate event
    ... login process. ... required for login… they have a username, password, and another “location ... and when the extra input field is submitted ... for the users where this concatenation of the two input field ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: unable to login as user
    ... unable to login as user ... Log in as root and look closely at the user account. ... the system just seems to hang and then go back to the username ...
    (RedHat)