Browse by Tags

• authentication
• copy
• disable
• error
• expiry
• management
• Microsoft
• mixed
• password
• property
• sa
• security
• self
• server
• sp_help_revlogin
• SQL Server
• sqlsmo
• ssma
• SSMS
• tsql
• users
• windows

• SP_HELP_REVLOGIN for SQL Server 2005

  SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins that exist on a server at a specific point in time script the logins along with password. I'm not sure how many DBA are aware of this Stored Procedure Read More... Posted Tuesday, September 04, 2007 11:54 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, self, server, login, copy, sp_help_revlogin

• Property IsLocked is not available for Login '[x]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

  One of my colleague has been getting following error when trying to open few logins properties to change their default databases using SSMS. TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ Read More... Posted Wednesday, August 22, 2007 11:56 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, SSMS, error, login, property, ssma

• Disable SA account on a live SQL Server2005 instance, any drawbacks?

  Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more Read More... Posted Monday, August 13, 2007 7:03 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, Microsoft, management, windows, sa, login, disable, authentication, mixed

• Error: Property MustChangePassword is not available for login

  If you have stumbled with the error "Error: Property MustChangePassword is not available for login.." or same as the picture show below: To solve the issue either you have to take out the "enforce password policy" using SA privileges or if you are the Read More... Posted Wednesday, August 08, 2007 12:50 AM from SSQA.net | (Comments Off) Filed under: SQL Server, SSMS, password, login, property, users, sqlsmo

• TSQL to find a login's properties such as password expiration?

  declare @name nchar ( 100 ) SET @name = '<LoginName' SELECT LOGINPROPERTY ( @name , 'PasswordLastSetTime' ) AS PasswordLastSetTime , LOGINPROPERTY ( @name , 'IsExpired' ) AS IsExpiried , LOGINPROPERTY ( @name , 'IsLocked' ) AS IsLocked , LOGINPROPERTY Read More... Posted Monday, July 23, 2007 10:22 PM from SSQA.net | (Comments Off) Filed under: tsql, password, login, expiry, property