Beranda > Error > How do I change password policies in SQL Server 2005?

How do I change password policies in SQL Server 2005?

How do I change password policies in SQL Server 2005?

An error about password policy has been causing some confusion among users. Most are trying to find an option within SQL Server itself to manage password policies, when in fact this is coming from Windows. When you create a SQL Server login, the server will validate the password against the password policy of the local machine.

For example, I have the following password policy on my local machine:

(You can get to this MMC dialog from Administrative Tools | Local Security Policy.)

So, when I try to create the following SQL Server account with a password < 7 characters:

CREATE LOGIN foo WITH PASSWORD = ‘bar’

I get the following error message:

Msg 15116, Level 16, State 1, Line 1
Password validation failed. The password does not meet policy requirements because it is too short.

You will see similar errors for different violations, such as:

Msg 15118, Level 16, State 1, Line 1
Password validation failed. The password does not meet policy requirements because it is not complex enough.

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:
    CREATE LOGIN foo WITH PASSWORD = ‘bar’,
    CHECK_POLICY = OFF

You might also want to look at the CHECK_EXPIRATION option, which will help prevent your accounts from expiring without warning you.

Source: http://www.aspfaq.com/sql2005/show.asp?id=26

Note:

Kalau pengalaman saya sih, ketika membuat user login pada SQL Server 2005, di uncheck aja “Enforce password policy” -nya.

Semoga bermanfaat,

Nana Sutisna

Iklan
Kategori:Error
  1. Juli 28, 2013 pukul 8:24 am

    I loved as much as you’ll receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get got an shakiness over that you wish be delivering the following. unwell unquestionably come further formerly again as exactly the same nearly a lot often inside case you shield this hike.

  1. No trackbacks yet.

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout /  Ubah )

Foto Google+

You are commenting using your Google+ account. Logout /  Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout /  Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout /  Ubah )

Connecting to %s

%d blogger menyukai ini: