Browse by Tags

SQL Server 2005 Login Security - CHECK_POLICY and CHECK_EXPIRATION setting, how it affects the password policy?

Published 30 April 8 3:53 AM | SSQA.net

Adding password complexity and password expiration to SQL Server logins is one of best feature I quote for SQL Server version 2005 onwards, similarly such password complexity policies are designed to deter brute force attacks by increasing the number...

Filed under: sql server, microsoft, security, feature, password, best practice, trustworthy, computing, logins, policies, settings, check_policy, check_expiration

SQL Server logins - enforce Password Expiration and policies

Published 7 January 8 1:11 PM | SSQA.net

Here is a quick snippet on enabling a SQL login to password expiration and password policies as per the Windows server: Open the SQL Server 2005 Management Studio. In the left pane, go to the desired server and navigate to the Security folder and expand...

Filed under: sql server, security, windows, BOL, password, best practice, authentication, books online, policy, logins, sql authentication

Error message in the SQL Server Errorlog file after you upgrade SQL Server 2000 to SQL Server 2005 on a server that is running Windows Server 2003: "Unable to update password policy"

Published 28 October 7 9:53 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Error message in the SQL Server Errorlog file...

Filed under: sql server, security, kba, password, servers, windows 2003, policy

Export SQL Servers registration using Management Studio?

Published 3 October 7 4:5 AM | SSQA.net

If you are managing hundreds of SQL Server and you might have organised your Management Studio screen with relevant server groups under Server registration. In this case if a new starter has joined and required to assist you in monitoring all of the SQL...

Filed under: sql server, ssms, best practices, password, 2005, management studio, servers, export, registered

Error: Property MustChangePassword is not available for login

Published 7 August 7 9:50 AM | SSQA.net

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...

Filed under: sql server, ssms, users, login, password, property, sqlsmo

Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005

Published 24 July 7 6:21 AM | SSQA.net

As a DBA you might have come across this situation where you have forgotten the sa password for SQL Server - so what can you do? If you are experienced with such situation then definetly you might have an alternative solution to keep the passwords in...

Filed under: sql server, security, disaster recovery, sa, password, sysadmin, privilege

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

Published 23 July 7 7:22 AM | SSQA.net

declare @name nchar ( 100 ) SET @name = '<LoginName' SELECT LOGINPROPERTY ( @name , 'PasswordLastSetTime' ) AS PasswordLastSetTime , LOGINPROPERTY ( @name , 'IsExpired' ) AS IsExpiried , LOGINPROPERTY ( @name , 'IsLocked'...

Filed under: login, password, tsql, expiry, property

Alert particular set of users about PASSWORDY EXPIRY policy notification

Published 23 July 7 3:33 AM | SSQA.net

As you may be aware using SQL 2005 version you can set PASSWORD EXPIRY policy that can apply the same complexity and expiration policies used in Windows Server 2003 operating system to passwords used inside SQL Server. This functionality depends on the...

Filed under: sql server, management, security, mail, login, alerts, password, dbmail, expiry

How to transfer logins and passwords between instances of SQL Server

Published 19 July 7 3:2 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to transfer logins and passwords between instances of SQL Server http://support...

Filed under: sql server, login, kba, password

Is it possible to restore all databases from Enterprise Edition to Standard Edition in SQL Server?

Published 2 July 7 5:3 AM | SSQA.net

Question> Is it possible to restore all the databses from Enterrise Edition to Standard Edition in SQL Server? Answer> Yes and No! Yes is you can restore user databases ( only ) from Standard Edition to Enterprise Edition and vice-versa for further...

Filed under: sql server, databases, move, system, password