Re: Login/Account Lock
Venkatesh (Venkatesh@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I have a scenario in my application that I need to know whether the
account is locked or not before the password is reset. If the account is
locked the app should pop up a msg.
how to programmatically determine that the account is locked or not in sql
server 2005.
Some thing like @@islocked or @@lock_status or any system SP
Can any one help me as this is an urgent case needed immediate response.
sys.server_principals.is_disabled seems like it could be what you are
asking for.
--
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
.
Relevant Pages
- Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
(microsoft.public.sqlserver.security) - Re: SharePoint V3 Install Error
... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
(microsoft.public.sharepoint.windowsservices) - RE: Problems with WebParts
... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
(microsoft.public.dotnet.framework.aspnet) - Re: Cannot connect to Query Analyzer
... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
(microsoft.public.sqlserver.connect) - Re: Does anyone know how to fix this??
... > Inside the Active Directory Users and Computers in the folder of SYSTEM I ... Give the site's SMS Service account full control rights to the ... MP encountered an error when connecting to SQL Server. ...
(microsoft.public.sms.setup) |
|
