SQL Server 2005 create user and grant permission

http://123mosquito.blog.163.com/blog/static/5625719920106225842127/

 

Method 1:

 

--ADD User

use master

exec sp_addlogin 'test','test908123456','AdventureWorks'        --Add Login

Error: Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.

Solusion:

1.        Go to Start - Administrative Tools - Local Security Policy

2.        Look for Account Policies - Password Policy node

3.        Disable "Password must meet complexity requirement"

Method   2:

--ADD User

-- Will fail

CREATE LOGIN [test] WITH PASSWORD = 'test908123456'

go

-- Will succeed

CREATE LOGIN [test] WITH PASSWORD = 'test908123456', CHECK_POLICY = OFF

go