Procedure
-
Click Start > All Programs > Microsoft SQL Server 2017 > SQL Server Management Studio.
Note: If Microsoft SQL Server Management Studio 2018 is installed, instead click Start > All Programs > Microsoft SQL Server Tools 18 > Microsoft SQL Server Management Studio 18.
- In the Connect to Server window, select the local server name from the Server name list, and then select SQL Server Authentication from the Authentication list.
-
Enter sa for the login
name, and then enter the default SQL Server administrator password.
Note: To identify the default SQL Server administrator password, refer to the documentation that ships with the Turnkey.
- Click Connect to access the server.
- In Object Explorer, expand Security > Logins.
- Right-click the sa user, and then click Properties.
-
In the Login Properties window, enter a new password in
the Password field. Enter the password again in the
Confirm Password field.
Note: To comply with the SQL Server complex password policy, enter a password that is at least eight characters long and contains characters from three of the following categories: uppercase letters A to Z, lowercase letters a to z, numbers 0 to 9, and non-alphanumeric characters. However, do not use the following characters: &, <, >, or /.
- Click OK.