Create Windows users and Change Administrator password

Change Current Administrator Password

The purpose of this step is to change the default password of the local administrator.

In an active session on the TSS, type Ctrl+Alt+Delete and click on Change Password.

Write the old password and give the secure password generated on previous chapter.

Create SQL Server User

The purpose of this step is to create a user with restricted right to run SQL Server. It is more secure than running SQL under local service account.

Proceed as follows:

•Open the Computer Management Console: right click on "My Computer and select Manage".

•Go to Local: Users and Groups > Users.

•Right click on right pane and select New user.

•Enter these settings to create the sql service user:

oUser Name: sql-service.

oFull Name: sql-service.

oDescription: User for MS SQL Services.

oPassword: paste the password create in previous chapter for this user.

oSelect the check boxes: User cannot change password - Password never expires.

Create tss-admin2 user

This step describes how to generate a second Windows administrator.

Proceed as follows:

•Follow steps 1-3 in above section (create sql service user).

•Enter these settings to create the tss-admin2 user:

oUser Name: tss-admin2.

oFull Name: tss-admin2.

oDescription: Second admin user.

oPassword: paste the password create in previous chapter for this user.

•Select the check boxes: User cannot change password - Password never expires.

•Add tss-admin2 to administrators group, open the properties of tss-admin2 and go to Member of tab;

•Click "Add" and select administrators, click on "Check names" and select "OK".