Solved

Turn off SQL 2008 Password Policy for entire instance

Posted on 2010-08-17
2
13,030 Views
Last Modified: 2012-05-10
I am importing a database and users, but when I do,  I receive an error about the passwords not being complex enough.  This is a SQL 2008 server, and I want to disable the password policy on the instance, then do the import.  Is this possible? I know how to do it for individual logins.

Thanks.
0
Comment
Question by:ITGhost
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 3

Accepted Solution

by:
PrakashRaoBS earned 250 total points
ID: 33455599
If you are creating a new login using CREATE LOGIN, you can use two clauses related to password policy: CHECK_POLICY and CHECK_EXPIRATION. If they are not specified, the default for CHECK_POLICY is ON and for CHECK_EXPIRATION is OFF.

These options can be changed at a later time using ALTER LOGIN. CHECK_POLICY governs the bulk of password policy enforcement related to password strength and lock out. CHECK_EXPIRATION separately covers the enforcement of password expiration, which was considered too disruptive for the rolling out of this feature, to be enabled by default.

CHECK_EXPIRATION is also required when using the MUST_CHANGE option, to force a password change on the first login through that account. CHECK EXPIRATION depends on CHECK_POLICY; other dependencies are covered in BOL.


USE [master]
GO
CREATE LOGIN LoginName WITH PASSWORD=N'Passw0rd', 
DEFAULT_DATABASE=[master], 
CHECK_EXPIRATION=OFF, 
CHECK_POLICY=OFF
GO

Open in new window

0
 
LVL 3

Expert Comment

by:PrakashRaoBS
ID: 33455879
Three possible workarounds are:

change the local/domain password policy;
use a password that meets the password policy requirements; or,
use the CHECK_POLICY option to disable policy validation:

Goto Start - > Run -> type secpol.msc ->
Then goto \Security Settings\Account Policies\Password Policy

disable complexity requirements and try.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Freeze portion of datamart 2 21
Need help with a query 3 37
SQL Select Query help 1 36
Related to SQL Query 5 19
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question