Create Windows Users and Change Administrator password

Create SQL Server User

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

Proceed as follows:

•Open the Computer Management Console: Right Click the Windows Start Button and select "Computer Management".

•Go to: Local Users and Groups > Users

•On the top menu: Click "Action > New User.."

•Enter these settings to create the sql service user: (or choose a name of your choice)

oUser Name: sql-service

oFull Name: sql-service

oDescription: User for MS SQL Services.

oPassword: Enter a strong password

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

Create a second TSS Admin User

This step describes how to generate a second Windows administrator.

Proceed as follows:

•Open the Computer Management Console: Right Click the Windows Start Button and select "Computer Management".

•Go to: Local Users and Groups > Users

•On the top menu: Click "Action > New User.."

•Enter these settings to create a "tss-admin2" user: (or choose a name of your choice)

oUser Name: tss-admin2

oFull Name: tss-admin2

oDescription: Second TSS Admin User.

oPassword: Enter a strong password

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

•Add "tss-admin2" to administrators group, Right click "tss-admin2" user and select "Properties"  and select the "Member Of" tab

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