28
Chapter 3
This opens the Local Security Settings window.
E
In the Tree frame, expand Local Policies and click
User Rights Assignment
.
E
In the right-hand frame, double-click
Log on as a service
. This allows the user to run services.
This opens the Log on as a service Properties dialog box.
E
Click
Add
.
E
In the list of names, choose the user name you created earlier and then click
Add
.
E
Click OK to close the Select Users or Groups dialog box.
E
Click OK again to return to the Local Security Settings window.
E
In the right-hand frame, double-click
Log on as a batch job
. This allows the user to run a service
that itself starts another application or service.
This opens the Log on as a batch job Properties dialog box.
E
Click
Add
.
E
In the list of names, choose the user name you created earlier and then click
Add
.
E
Click
OK
to close the Select Users or Groups dialog box.
E
Click
OK
again to return to the Local Security Settings window.
E
Close the Local Security Settings window.
E
Open your SQL administration program and grant the
Installing User
SYSADMIN
authority. For
example, if you have SQL Enterprise Manager, or SQL Server Management Studio, the steps
will be as follows:
From the Windows Start menu choose:
Programs > Microsoft SQL Server > Enterprise Manager or SQL Server Management Studio
Expand the tree in the left-hand frame until the contents of the Security node are visible for
the Interviewer Server Database server, and select Server Roles.
In the right-hand frame, double-click
System Administrators
or
sysadmin
.
This opens the Server Role Properties dialog box.
Click
Add
.
In the list of names, choose the user name you created earlier and then click
OK
.
Click
OK
to close the Server Role Properties dialog box and then close Enterprise
Manager/SQL Server Management Studio.
E
Repeat these steps, except the one to add
SYSADMIN
authority in SQL, to create the Running
User account.
