强密码Strong Passwords

适用对象:是SQL Server 是Azure SQL 数据库 是Azure Synapse Analytics (SQL DW) 是并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

在服务器安全部署中,密码可能是最薄弱的一个环节。Passwords can be the weakest link in a server security deployment. 请务必在选择密码时保持高度谨慎。You should always take great care when you select a password. 强密码有以下特征:A strong password has the following characteristics:

  • 长度至少有 8 个字符。Is at least 8 characters long.

  • 密码中组合使用字母、数字和符号字符。Combines letters, numbers, and symbol characters within the password.

  • 字典中查不到。Is not found in a dictionary.

  • 不是命令名。Is not the name of a command.

  • 不是人名。Is not the name of a person.

  • 不是用户名。Is not the name of a user.

  • 不是计算机名。Is not the name of a computer.

  • 定期更改。Is changed regularly.

  • 与以前的密码明显不同。Is significantly different from previous passwords.

MicrosoftMicrosoft SQL ServerSQL Server 密码最多可包含 128 个字符,其中包括字母、符号和数字。SQL ServerSQL Server passwords can contain up to 128 characters, including letters, symbols, and digits. 由于在 Transact-SQLTransact-SQL 语句中经常使用登录名、用户名、角色和密码,所以必须用英文双引号 (") 或方括号 ([ ]) 括起某些符号。Because logins, user names, roles, and passwords are frequently used in Transact-SQLTransact-SQL statements, certain symbols must be enclosed by double quotation marks (") or square brackets ([ ]). 如果 Transact-SQLTransact-SQL 登录名、用户、角色或密码具有以下特征,请在 SQL ServerSQL Server 语句中使用以下分隔符:Use these delimiters in Transact-SQLTransact-SQL statements when the SQL ServerSQL Server login, user, role, or password has the following characteristics:

  • 含有空格或以空格开头。Contains or starts with a space character.

  • 以 $ 或 @ 字符开头。Starts with the $ or @ character.

如果用于 OLE DB 或 ODBC 连接字符串,则登录名或密码不能包含以下字符:[] {}() , ; ?If used in an OLE DB or ODBC connection string, a login or password must not contain the following characters: [] {}() , ; ? * !* ! @ 列中的一个值匹配。@. 这些字符用于初始化连接或分隔连接值。These characters are used to either initialize a connection or separate connection values.

密码策略Password Policy