增強式密碼Strong Passwords

適用於: 是SQL Server 是Azure SQL Database 是Azure Synapse Analytics (SQL 資料倉儲) 是平行處理資料倉儲 APPLIES TO: YesSQL Server YesAzure SQL Database YesAzure Synapse Analytics (SQL Data Warehouse) YesParallel Data Warehouse

密碼會是伺服器安全性部署中最薄弱的連結。Passwords can be the weakest link in a server security deployment. 當選取密碼時,請格外小心。Take great care when you select a password. 增強式密碼具有下列特性:A strong password has the following characteristics:

  • 長度至少為 8 個字元。Is at least eight 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 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